Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 18-02-2009
Member
 
Join Date: Feb 2008
Posts: 624
Restoring MySQL database

My server crashed recently. So everything is chopped over here, even my body of mySQL. I recovered the files from the old install and I have my bases (a file .FRM per table). Is there a way to put it in a new instance?
Reply With Quote
  #2  
Old 18-02-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Restoring MySQL database

In frm there's no data, so you can not just retrieve the diagram in fact? Otherwise, you create a base, you just recreate the tables, you cut mysql, then you replace your frm in place of those that has been created (but hey, no data).
Reply With Quote
  #3  
Old 18-02-2009
Member
 
Join Date: Feb 2008
Posts: 624
Re: Restoring MySQL database

Diagrams doesn't matter for me, I can recreate them by 1 click, what is the most important thing for me is the data.
Reply With Quote
  #4  
Old 18-02-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Restoring MySQL database

Bah data in files ibdata, so if you were not so much the worse for the data
(well, personal, I have copied my ibdata files savagely and done a mysql installation to another and I found the data and structure)
Reply With Quote
  #5  
Old 18-02-2009
Member
 
Join Date: Feb 2008
Posts: 624
Re: Restoring MySQL database

well, apparently is this the only method to restore the data?
Reply With Quote
  #6  
Old 18-02-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Restoring MySQL database

This is not unique at all, but hey, when I did, I had no time to fiddle around something else
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Restoring MySQL database"
Thread Thread Starter Forum Replies Last Post
Manipulating MySQL database using PHP blueprats Guides & Tutorials 1 30-04-2010 04:29 PM
Need MySQL database directory Osman84 Software Development 4 27-02-2010 05:18 AM
How to speed up the MySQL database Kalanidhi Software Development 5 27-02-2010 01:33 AM
Rename mysql database Antarjot Software Development 3 11-11-2009 11:39 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM


All times are GMT +5.5. The time now is 04:09 PM.