Hi All I have taken the dump of my mysql database. say mydump.sql . it is around 5 GB file. My database contains around 98 different databases. I have to restore the dump to a new mysql server on different machine. The mysql version on the new server is 5.0.27. How do i restore the database in the new server. Is it possible to do it in one line command ? or do i need to create all the databases seperatly and do mysql dump and restore sepertaly ? Any help is highly appreciated. Looking forward to you all Thanks and Regards Nidhin Tomson
Hi, You can execute the following command as root on the shell: mysql -p -h localhost webX_dbX < filename.sql
