2 Oct
2007
2 Oct
'07
2:35 p.m.
Richard Lewis wrote:
In my experience, you can just copy MySQL database directories and they work. It may not work for you though.
It's supposed to work (ie MySQL do state that this is "allowed", even across platforms.
I've never had any problems.
Of-course its wise to make sure that the database server is not writing to the files when you copy them! Shutting down the database is the easiest way for personal use.
If moving files between MySQL versions a REPAIR TABLES is worthwhile after the copy.
Mark Rogers