SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:52 AM
| ||||
| ||||
 OK to copy old Data subdirectories to new MySQL instance? 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      |
|
02-28-2008, 08:52 AM
| ||||
| ||||
| 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 |
 |
« Lost ability to logon .. how can I recover (revised)?
|
Help with Transitioning to Spatial Columns »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:26 AM.
