Slightly OT: Switching mySQL from win to Mac OSX

Alex Rice alex at mindlube.com
Fri Nov 14 18:35:39 EST 2003


On Nov 14, 2003, at 4:18 PM, tkuypers at pandora.be wrote:
> Anyone any suggestions?

I would not move the raw data files between different servers. It might 
work but a lot could go wrong: different mysql table types, different 
architecture, different mysql servers versions, etc.

Mysql has command-line tools for creating, exporting and importing 
databases. That's what I would use. Use "mysqldump" to get a snapshot 
of the database, use "mysqladmin" to create the database on a new 
server, then do something like "mysql -u username dbname < dump.sql " 
to load the sql dump file.

Alex Rice <alex at mindlube.com> | Mindlube Software | 
<http://mindlube.com>

what a waste of thumbs that are opposable
to make machines that are disposable  -Ani DiFranco



More information about the use-livecode mailing list