Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th October 2007, 20:01
tennents tennents is offline
Junior Member
 
Join Date: Apr 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to restore database?

I have a little problem:

i accidentally deleted some crucial file and the ispconfig box do not start anymore (moving an empty file on .passwd and not vice versa!).

The problem is not this, because this is a testing server, not my production machine! BUT i had some database that i would like to restore. Now i have connected the hd to my notebook (whith a usb-to-ide cable). it's possible to find and restore the two databases (web7_db1 and web7_db2)? where does the ispconfig's mysql store the databases?

Thanks a lot!
Reply With Quote
Sponsored Links
  #2  
Old 5th October 2007, 20:17
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default restore

hi try to look to /var/lib/mysql/ and there are mysql dumps try to restore than..
may this will help if i understand what u posted before ..


gl
Reply With Quote
  #3  
Old 5th October 2007, 20:50
tennents tennents is offline
Junior Member
 
Join Date: Apr 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok, i found a lot of .frm files in a directory called as the database was...

now i'm going to try to recovery the db!

any hint?

thanks!
Reply With Quote
  #4  
Old 5th October 2007, 21:02
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default restore

google how to restore mysql db or dump from .frm ,i am sure u will find some howto, many there, if not i will post here some steps may
Reply With Quote
  #5  
Old 5th October 2007, 21:10
Snowman Snowman is offline
Senior Member
 
Join Date: Apr 2007
Posts: 120
Thanks: 38
Thanked 3 Times in 3 Posts
Default btw

only .frm there ? because MySQL will always create a `.frm' file to hold the table and column definitions. The table's index and data will be stored in one or more other files, depending on the table type as i know.
Reply With Quote
  #6  
Old 6th October 2007, 14:14
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

Quote:
Originally Posted by tennents
it's possible to find and restore the two databases (web7_db1 and web7_db2)?
Take a look here: http://www.howtoforge.com/faq/6_3_en.html
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
  #7  
Old 6th October 2007, 16:18
tennents tennents is offline
Junior Member
 
Join Date: Apr 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks falko, but unfortunately i don't have dumps, and i do not know how to dump the databases because the server does not start! (actually, it does start, but i could not login because i accidentally deleted the .passwd file!)
Reply With Quote
  #8  
Old 7th October 2007, 20:03
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

The database files are in /var/lib/mysql.
__________________
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
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
Database Backup and Restore PoleCat Feature Requests 5 16th May 2007 15:36
How do I restore a MySQL database from an sql dump? controlmac Installation/Configuration 4 16th March 2007 17:45
Recreating ISPConfig database retran Installation/Configuration 2 15th April 2006 23:22
./install doesn't create database benjami Installation/Configuration 3 26th November 2005 14:25


All times are GMT +2. The time now is 05:20.


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