[Gllug] Extract the data from a MySQL database's *files*?

Richard Huxton dev at archonet.com
Thu Apr 1 14:48:05 UTC 2010


On 01/04/10 15:41, Dave Cross wrote:
>
> Might not work if the versions of the MySQL server software differ by
> more than a minor version or two.

Like Dave and Walter have said - version number is important in this 
process (as is stopping the server while you copy files about). Mysql 
can be more forgiving here than PostgreSQL, but is less predictable. 
There's no clear way of knowing if anything important changed in a 
particular Mysql release without reading the changelog.

With innodb or other transactional filetypes you'll need their 
associated transaction logs too of course, but I think myisam might just 
be readable as they are.

-- 
   Richard Huxton
   Archonet Ltd
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug




More information about the GLLUG mailing list