moving and restoring a mysql db

liunx

Guest
I am moving hosts and my database is 34 mb. I can go into phpmyadmin and create the new stucture just fine. When I go to the old db and Download a fresh backup that also works fine of the data. when I try and load the large file into the new database via phpmyadmin it never works. I get errors everytime. I do not want to loose any of my information and I am wondering is there another way to upload a large file and get all the data into the new one.

Any help would be appreciated

Mikesplit the tables. so say you have 10 tables, backup the first 5 and then upload those to the new one, then go back and get the last 5.

or you can do just the data. instead of structure and data.

doing it all at once will make phpmyadmin choke most of the time.

what errors are you getting?
 
Top