MYSQL Database restore

Discussion in 'Server Operation' started by nidhintomson, Nov 23, 2007.

  1. nidhintomson

    nidhintomson New Member

    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
  2. Hans

    Hans Moderator ISPConfig Developer


    You can execute the following command as root on the shell:

    mysql -p -h localhost webX_dbX < filename.sql


Share This Page