View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 09:52 AM
Richard
 
Posts: n/a
Default Re: OK to copy old Data subdirectories to new MySQL instance?


Hi All,

> 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