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/win32?unsub=gcdmw-win32@m.gmane.org

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



____________________________________________________________ ________________
________
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/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=gcdmw-win32@m.gmane.org

RE: trying to restore an old db to mysql 5.0

I think we need a bit more than "it wont work". Do you get any error
messages? What exactly happens?

I do restores like this

mysql -hlocalhost -uroot -p [DatabaseName]
Replace [DatabaseName] with the name of your database. You may need a
different host and user name too. I suspect you need some more
parameters on your restore command line.

John Bonnett

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com]=20
Sent: Thursday, 20 September 2007 6:23 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=20


=20
____________________________________________________________ ____________
____________
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/win32?unsub=3Dgcdmw-win32@m.gmane.org