AutoGallery SQL - changing host provider

[cd34]

Originally Posted by tortus32

I still have access to the old files on my old provider's server, and I tried downloading the back up .txt files and uploading them to the new server with no luck.

Do you have phpmyadmin or ssh access?

If phpmyadmin, you can backup the database and restore it specifically. Log in, select the database, Export (or backup depending on the version), Select all, hit go. it will then chug for a few minutes, then you should get a 'save file' dialog box. Save it, import it on the other side.

If you have ssh access, you can use mysqldump to do the same thing.

mysqldump -u username -p -q databasename > file.sql

download file.sql

Once you get it to the other side, you can import it either through mysql/ssh or phpmyadmin.

Or, we can figure out why the import didn't work.

Its possible that their import routine uses /usr/bin/mysql and the path for mysql might be different on the machine, i.e. /usr/local/bin/mysql or something.