RE: trying to restore an old db to mysql 5.0

Hi Mark

I think you exported db when Innodb enabled. So you follow the steps to avoid losing the db datas.

1. back the data folder for safer side. ( before take backup stop the mysql service)
2. convert the DB (if Innodb then to MYIsam -- make sure take the back up)
3. then export the db with minimal settings
4. create the db in mysql 5 ( no issue even innodb or mysql in 5)
5. if you running the mysql 4 and 5 same machine stop the mysql 4 once you export operation over, then import to mysql 5

Hope you will find this and will help you to do your work .

Thanks
Muthukumar Selvarasu
Project Manager (Web Development)
Webmaster Ltd.

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com] Sent: Thursday, September 20, 2007 8:53 PM To: mysql list
Subject: trying to restore an old db to mysql 5.0

Hi,
I used mysqlbackup to backup and old database (4.x), i now need to restore this, but i'm using mysql 5.0, when i run the mysql < db.sql it wont work, anybody come accross this ?

thanks

Mark  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

--

MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32 To unsubscribe:
http://lists.mysql.com/win32?unsub=muthukumar_se@hotmail.com

--

MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=lists@pantek.com Received on Thu Sep 20 18:14:15 2007