dbTalk Databases Forums  

OK to copy old Data subdirectories to new MySQL instance?

comp.databases.mysql comp.databases.mysql


Discuss OK to copy old Data subdirectories to new MySQL instance? in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard
 
Posts: n/a

Default OK to copy old Data subdirectories to new MySQL instance? - 01-02-2007 , 08:56 PM






Hi All,

I was running MySQL 5.0.15-community-nt over WinXP/SP2.

My instance of MySQL 5.0.15 got corrupted recently: it no longer
accepted my root password. I managed to backup that instance and
reinstall a new instance, MySQL 5.0.27, which seems to be working
properly.

Question: Is it safe to restore subdirectories of the former data
directory to the data directory of the newly installed instance?
Notice that my new instance is a more recent version of MySQL.

Regards,
Richard


Reply With Quote
  #2  
Old   
Richard
 
Posts: n/a

Default Re: OK to copy old Data subdirectories to new MySQL instance? - 01-02-2007 , 10:32 PM







Hi All,

Quote:
Question: Is it safe to restore subdirectories of the former data
directory to the data directory of the newly installed instance?
Ok, I copied the data sub-directories for databases I wanted. No
problem, at first. However, MySQL didn't see any tables for those
databases.

So I stopped the server. Renamed ibdata1 to ibdata1-bkup. Copied that
saved version. Restarted the server. Tables and their content now seen
by MySQL.

Seems to work great.

Regards,
Richard



Reply With Quote
Reply




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

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.