How do I upgrade mysql from 3.23.56 to 4.1.9?

Um, I’m lost here. You have a hosting provider and they’re telling their end users that they have to upgrade MySQL? That’s server software and they should be doing it themselves.

I’m on Westhost.

To “upgrade”, I believe that I have to uninstall one and install the other. I’m guessing that when I uninstall, I’ll lose all my data. So I was looking for a way to back up all my data (yes, I see the backup instructions, but my version of myphpadmin is also old — 2.4.0), install the new database, and restore my data. At that point, I’m guessing I can try the WP upgrade.

I’m looking for help with this cross-version backup and restore… has anyone here had to do that before?

Also, if anyone sees a better way to do this that I’m missing, by all means, please suggest!

thanks.

I am still with drmike on this: I can’t imagine how YOU can update (uninstall/install) the server’s mysql version… Never heard anything like that. That’s their job, not yours.

Maybe, after backing up your site they will upgrade the MySQL version on the box where you are hosted, or move you to another machine – that’s the usual procedure.

Now, for the backup. Yes, just follow the backup instructions. I can’t remember older phpMyadmin versions but don’t they have an Export option, too?

After making sure you have working backups (both your WP files AND database) – install the same WP version on the new server/database, i.e. WP 1.5.x (which you have now).
Import (aka restore) the database and make sure the blog works.
Then you could proceed to upgrade, and for the moment I’d stick with 2.0.7.

p.s. The only problematic point in the process above might be the importing of the old version .sql file into the higher version of MySQL. Never tried that – maybe somebody can jump in and give you more info.

They have one of those control panels that you log into, with all your software options. This is pretty standard at a lot of hosts I’ve seen — you go in and select which software you want to install. So I would have to uninstall 3.23.56, then install 4.1.9. Here’s a screenshot of the manager, if you’re curious:

https://i126.photobucket.com/albums/p98/ouroborosind/stupidity.jpg

And I just confirmed with Westhost support that yes, all data will be lost. So I need to back it up first and restore on the new DB. Pretty sweet.

The myPHPAdmin version: yeah, the Export option is there, but it’s missing some stuff that’s mentioned in various tutorials I’ve seen:

https://i126.photobucket.com/albums/p98/ouroborosind/stupidity2.jpg

The files won’t be touched in the process, so in theory I shouldn’t have to change those. Just in case, can someone remind me where the MySQL connection info lives in the WordPress install?

Thanks for the help, moshu (including the caution to stay with 2.0.7). Yeah, it looks like the real tricky part will be importing the old file into the new version of the database. Anyone have any pointers on that one?

Thanks again.

Also, totally dumb question but I just want to make sure:

Will WP 1.5 actually *run* on mysql 4.1.9?

Just trying not to overlook the obvious. ??

I have a WP 1.5.2 install running on MySQL 4.1.10.