Rob, Spyros, you can simply copy .frm, .MYI, .MYD, ibdata files, and ib_logfiles between Windows and Linux. The binary formats on disk are the same.
Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL ----- Original Message ----- From: "Rob Kings" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 25, 2003 2:20 PM Subject: Re: Move a MySQL Database to another system > spyros > > Well I just did pretty much the opposite. From Linux to XP. Take a look at > mySQLDump. I don't have the exact syntax in front of me, but I dumped out > the database into a .SQL. This contains both the SQL to create the tables > and the data. Then on the target machine I created the new database: > > C:\mysql\bin\mysqladmin create xyz -u root > > Where xyz was the name of the database I wanted to create. > > Then I imported the attached file using something like > > C:\mysql\bin\mysql xyz < xyz.sql -u root > > You'll have to look up the mySQLdump documentation (you can dump the entire > DB or just certain tables) and of course where I've used a DOS path yours > will be something like /mysql/bin/<whatever> > > HTH > > Rob > > > "Spyros" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000 > > Server to a 4.0.14-max on a Redhat Linux Server. > > Any idea will be welcome. > > Thanks > > Spyros > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
