HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   How do I restore a MySQL database from an sql dump? (http://www.howtoforge.com/forums/showthread.php?t=11402)

controlmac 15th March 2007 11:21

How do I restore a MySQL database from an sql dump?
 
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

till 15th March 2007 15:12

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?

controlmac 15th March 2007 15:43

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

Walter

AngelDrago 15th March 2007 15:54

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

falko 16th March 2007 17:45

Take a look here: http://www.howtoforge.com/faq/6_4_en.html


All times are GMT +2. The time now is 18:41.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.