I am going from a shared hosting server to a dedicated server and need to get my database over. On the shared server I only have phpmyadmin access and can do an export of the db that way. On the dedicated server I have phpmyadmin and ssh access. Phpmyadmin times out when trying to import the database and I can't get it to work in ssh even after following the command instructions. Uncompressed, my db is about 50mb. Is there any other way to accomplish this? Would Impex do this?
Thanks.
The best way i found (before SSH) was to import bits of the db at a time, took maybe 30 mins or so but it did work....
BigDump: http://www.ozerov.de/bigdump.php
Or if you need help send me a PM and I'll do it for you.
Upload your dump to your server into the /home directory then use the following command to restore it
mysql -u USERNAME -p mysql_database_name < /home/database_dumpname.sql
the next thing that will popup is the password prompt.
Thanks guys, your suggestions worked. I'm all set now.