469,298 Members | 2,148 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,298 developers. It's quick & easy.

Restore db from 4.1.12 to 3.23

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
Jul 23 '05 #1
2 1149
>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
Jul 23 '05 #2

"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
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by For example John Smith | last post: by
3 posts views Thread by butatista | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.