Error when importing into MySQL

pilsnermonkey
12 years, 11 months ago
dryabov wrote:
idemsisvoje, just run
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_RIS`
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_FallBackDevices`

to remove terawurfl's procedures.


Where would one 'run' this?
idemsisvoje
12 years, 11 months ago
pilsnermonkey wrote:
dryabov wrote:
idemsisvoje, just run
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_RIS`
DROP PROCEDURE IF EXISTS `<joomla-db-prefix>TeraWurfl_FallBackDevices`

to remove terawurfl's procedures.


Where would one 'run' this?


go to phpmyadmin
open your database
click sql
insert the mentioned query
hit go
it will execute the query
note it will DROP the terawurfl procedures

or you can use the extension I mentioned
pilsnermonkey
12 years, 11 months ago
Copied & pasted those lines individually. Query successful. Exported local db. Tried to import to a new db on server via phpmyadmin, same error.

Tried the program you suggested. It did not install properly. Tried twice so I dl'd acesql. That installed ok.

Still stumped, still dead in the water.

Thanks for your help though; appreciate that.

PS...if I can locate the table where these procedures exist I might be able to remove them through acesql (assuming the procedures are stored in a table. Here's an odd thing: I can't import the db on my server via phpmyadmin but I can import the db via phpmyadmin on my local machine.
LoveBoat
12 years, 3 months ago
Buonasera,
same error during the importing process, same approach (I disintalled the plugin and then also run the strings is sql)..but still the same problem and I'm still not able to import the db. What else can be done?
khitk
12 years, 2 months ago
Thanks for the sharing.
2

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.