View Single Post
Old 2005-04-08, 03:52 PM   #10
cd34
a.k.a. Sparky
 
cd34's Avatar
 
Join Date: Sep 2004
Location: West Palm Beach, FL, USA
Posts: 2,396
Quote:
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.
__________________
SnapReplay.com a different way to share photos - iPhone & Android
cd34 is offline   Reply With Quote