Mysql Restore

[wayne]

I used cpanel at my old host to create a mysql backup.

When I uploaded the backup here, and go to phpmyadmin there are no tables.

I had one table before so I created the table in case it has to exist before I restore however still no luck.

 

Any advice?

[LisaJill]

Mysql has an import function that asks you to import it from a .txt file on your harddrive; that is how I got my MT site up here.

 

The text file you exported will probably have some details at the top for the new dbname, dbuser and pwd, so that it has permissions to create. You should double check that those are ready to go.

 

I've had problems with that before, not sure why; when I did I just copied and pasted the entire file (below the variables for db name/user/etc) into the import query window and hit go.