Restore db from 4.1.12 to 3.23

[Kees]

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

[Gordon Burditt]

>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

[Kees]

"Gordon Burditt" <go***********@burditt.org> wrote in message
news:11*************@corp.supernews.com...

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