Restore db from 4.1.12 to 3.23

mailing.database.mysql - MySQL database issues discussed in this best MySQL group in USENET 

Subject Author Date Restore db from 4.1.12 to 3.23 Kees 07-13-2005  Re: Restore db from 4.1.12 to 3.23 Gordon Burditt 07-13-2005  Re: Restore db from 4.1.12 to 3.23 Kees 07-14-2005

Posted by Kees on July 13, 2005, 11:21 am Please log in for more thread options I've a backup from my database running on mysql 4.1.12 Now i want to restore this to an old machine running 3.23. How to do this. I get several errors. Kees Posted by Gordon Burditt on July 13, 2005, 4:04 pm Please log in for more thread options show/hide quoted text >I've a backup from my database running on mysql 4.1.12 >Now i want to restore this to an old machine running 3.23. >How to do this. >I get several errors. mysqldump, and the mysql command-line utility to restore it. You want to dump the data with the --compatible=mysql323 option. It may be you will have to restore the data to mysql 4.1.12, then mysqldump it again with that option. Possibly you can edit the dump to eliminate the errors; I'm not sure what in your dump it's having problems with.                                                 Gordon L. Burditt Posted by Kees on July 14, 2005, 6:53 pm Please log in for more thread options show/hide quoted text > >I've a backup from my database running on mysql 4.1.12 >>Now i want to restore this to an old machine running 3.23. >>How to do this. >>I get several errors. > mysqldump, and the mysql command-line utility to restore it. You > want to dump the data with the --compatible=mysql323 option. It > may be you will have to restore the data to mysql 4.1.12, then > mysqldump it again with that option. Possibly you can edit the > dump to eliminate the errors; I'm not sure what in your dump it's > having problems with. > Gordon L. Burditt Tnx Gordon. That works. Kees Similar Threads Posted Restore Your Account August 11, 2005, 1:45 am slow restore March 7, 2006, 12:41 pm cannot restore 3.23.58 db to MySQL 4.0.22-debug November 29, 2005, 3:42 pm mysql backup and restore for 4.1.x April 16, 2006, 12:22 am mysqldump restore db syntax April 29, 2006, 4:38 pm Quality of Backup and Restore June 2, 2006, 3:38 am backup and restore of var lib mysq February 12, 2009, 2:12 pm What is the fastest way to restore a mysqldumped table? October 31, 2005, 8:12 pm Database Restore / MySQL 4.1 -- InnoDB May 1, 2006, 12:11 pm Newbie seeks help using backup/restore August 11, 2006, 11:59 am