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:[email protected]] 
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 


 
____________________________________________________________________________
________
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/[email protected]



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]