[vsurfer]

Going to install new version PHP and MySQl after clean install of Panther.
My Jaguar is a little corrupt -- but would like to keep MySQL databases an database structures.

Any quick hints on how to dump contents and structure then re-load after new versions installed?

Thanks,

[clam2000]

This should probably in the web development forum...

The command would be 'mysqldump'

options would probably be:

mysqldum --all-databases -u(name) -p(password) > (file)

note that there is no '=' sign in the -u and -p

this will create a dump of your databases, you can then reimport them using the command 'mysqlimport'

--will

[vsurfer]

Originally posted by clam2000:
This should probably in the web development forum...

The command would be 'mysqldump'

options would probably be:

mysqldum --all-databases -u(name) -p(password) > (file)

note that there is no '=' sign in the -u and -p

this will create a dump of your databases, you can then reimport them using the command 'mysqlimport'

--will

Thanks Will.

[Thor]

You should be using CocoaMySQL...

It can generate very nice dumps for you. After your upgrade, you can just read the dumps back in.

[Love Calm Quiet]

Thanks ever so much for that lead on CocoaMySQL. It's only a v0.5 but beats anything commercial available out there for all sort of MySQL admin via OS X GUI !

[Sarc]

thx Thor for the link !
very useful app indeed

[vsurfer]

Originally posted by Thor:
You should be using CocoaMySQL...

It can generate very nice dumps for you. After your upgrade, you can just read the dumps back in.

Thanks for this. Works well.

I like to be able to do things both ways (so as not to be so totally reliant of GUIs), but this time I did have a bit of syntax trouble near mysqldump -- so I'll go check the manual.

[foamy]

I used Complete Mysql to reinstall mysql after the upgrade to Panther. Linkage

Everything went well and it was the easiest migration thusfar. Complete mysql gives you a nice prefpane for turning mysql on/off and lets you easily set your root password for mysql. Using this in conjunction with CocoaMysql was very easy.

Good luck