Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th March 2007, 11:21
controlmac controlmac is offline
HowtoForge Supporter
 
Join Date: Aug 2005
Location: Netherlands
Posts: 13
Thanks: 3
Thanked 1 Time in 1 Post
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 15th March 2007, 15:12
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,977
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th March 2007, 15:43
controlmac controlmac is offline
HowtoForge Supporter
 
Join Date: Aug 2005
Location: Netherlands
Posts: 13
Thanks: 3
Thanked 1 Time in 1 Post
Default

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

Walter
Reply With Quote
  #4  
Old 15th March 2007, 15:54
AngelDrago AngelDrago is offline
Senior Member
 
Join Date: Sep 2005
Location: Florida -- USA
Posts: 100
Thanks: 4
Thanked 0 Times in 0 Posts
Default

controlmac can you give us/me the steps you took to do that i will need to that as well...
__________________
Danke für Ihre Hilfe
AngelDrago
Reply With Quote
  #5  
Old 16th March 2007, 17:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Take a look here: http://www.howtoforge.com/faq/6_4_en.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SVN Broken, database sql dump is broken? danf.1979 Developers' Forum 4 16th February 2007 11:26
virtual mail boxes setup satimis Server Operation 3 25th January 2007 18:32
ISPConfig and adding an SQL Database Texaskilt General 1 7th December 2006 09:52
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 09:44.


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