Hello, folks! I need some help with transferring DB form one host to another. So on the old host, I backed up the databases of my 5 sites, and it gave me one .sql file. Now, on the new host I crated 5 databases and need to restore the old DB. But now I am confused since I have 5 different data bases and only one .sql file, how do I do it?
If you're still needing assistance with your database transfer, I'd be happy to do it for you. Please contact me via pm to discuss. Thanks!
I guess not all of your websites are using database. may be some are using text files to store data or something. anyway I guess just go ahead and import the sql file into a database and see which one works and which doesn't
After reading through lots of materials I was even more confused. I contacted Hostgator and they did everything for me free of charge Problem solved!
i usually in this way dump every db in a separate .sql file with mysqldump then create on a new server db with correspondent name and just use mysql < yourdumpfile.sql dont forget to put necessary parameters for mysql to connect. this is for shell in unix/linux systems
Why do you import/export database using phpmyadmin or mysql administrator? It is very easy to do this using these applications.
The reason why your database was being saved in one sql file is that you had several website on one database. So a solution would have been to get that file and make several.
see my this blog post http://www.webnol.org/backup-and-restore-large-mysql-database/ might be helpful