How do I restore a MySQL database from an sql dump?

Discussion in 'Installation/Configuration' started by controlmac, Mar 15, 2007.

  1. controlmac

    controlmac New Member HowtoForge Supporter

    I moved all my services to an new server. I dumped all (customer)databases from MySql and imported them in the new server using my MySql -root account. But none of the sites using these databases works.

    Sites give things as:


    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

    What did I do wrong?

    Walter
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Hvae you created the users to access the websites in the mysql database? Does all databases show up correctly when you open them with phpmyadmin?
     
  3. controlmac

    controlmac New Member HowtoForge Supporter

    I just found out how to do it. Thanks anyhow.

    Walter
     
  4. AngelDrago

    AngelDrago Member

    controlmac can you give us/me the steps you took to do that i will need to that as well...
     
  5. falko

    falko Super Moderator ISPConfig Developer

Share This Page