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 |