Forums

DB Import fails on remote host

Permalink
I've exported my db from C5 5.4 on my localhost using the built in BU uitility. When I try to import the sql file at dreamhost using phpmyadmin (it's the only tool available to us) I get the following error:

Error

SQL query:

DROP TABLE AreaGroupBlockTypes;

MySQL said: Documentation
#1051 - Unknown table 'AreaGroupBlockTypes'

Can anyone suggest what I'm doing wrong or suggest a work around?

Thanks,
Doug
 
agentorange replied on at Permalink Reply
agentorange
Hey I am not sure if you sorted this out, I was experiencing the exact same problem, and managed to find a way around it

My host uses a cpanel dashboard for accessing the server, what I had to do was backup the database via the cpanel backup wizard not the phpmyadmin and then restore it on my new server via the cpanel using the backup wizard then going to restore > databases > uploading my backup file.

The database is working perfectly. Not sure if this would be of any help since I would assume different hosts use different platforms.
Mainio replied on at Permalink Reply
Mainio
Try opening the SQL file with text editor and replacing all instances of: "DROP TABLE" with "DROP TABLE IF EXISTS".

That would also give you a workaround.