Plesk and MySQL

[Jake]

Hi!

I'm new to the world of server maintenance and Plesk so I need some hand holding and reassurance

First of all, I'm using Plesk version psa-7.5.3-fc2.build75050506.13 on a Fedora Core 2 VPS server.

I currently have MySQL version mysql-3.23.58-9 installed on my server. I would like to update this to the 4.x series however I'm afraid of screwing things up (the server is live with various clients using the databases).

I figure I should backup everything before I do anything drastic. So I did some searching and found references to psadump and psarestore. I've looked in /usr/local/psa/bin/ as well as various other places but can't find either of them. My server doesn't seem to have them however I have found them at the downloads area of swsoft.com. The downloads area of swsoft.com has them listed for "Fedora Core1" and "PLESK 7 FOR UNIX"

Question 1 - Can I run these versions of psadump and psarestore on Fedora Core 2?
Question 2 - Will using these commands backup and restore EVERYTHING on Plesk 7.5 or will it miss things since it's written for Plesk 7?

ok. Now assuming I've got psadump working and I've backed up my server, I'd want to do the actual MySQL update. Are the following steps correct?
- Download and install YUM (does it matter which version? Can I get it from http://download.fedoralegacy.org/fedora/2/os/i386/ ?)
- Edit /etc/yum.conf to contain:

[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[atomic-app-vault]
name=Atomic Rocket Turtle - $releasever - Atomic PSA App Vault RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/app-vault/

[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[base]
name=Atomic Rocket Turtle - $releasever - Base OS RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-p ... eleasever/

[updates]
name=Atomic Rocket Turtle - $releasever - OS Update RPMS mirror
baseurl=http://3es.atomicrocketturtle.com/3rd-p ... eleasever/

- Type yum install mysql and hope for the best.
- Add old_passwords=1 to my.cnf

I keep reading horror stories of MySQL no longer restarting or the install failing/etc. hence why I want to back everything up first using psadump.

Any help would be appreciated!

Thanks,
Jake

[Jake]

Noone has any clue?

I guess if I know that the 7.0 versions of psadump and psarestore work 100% on 7.5x, I can figure out the rest myself with trial and error, so if anyone can help with answering that or any of the issues, I would appreciate it immensely.

Thanks,
Jake

[scott]

you've got to use the same version of the backup utils between PSA's. So a 7.0 restore will not work on a 7.5 box

[Jake]

Hi Scott.

Is there any place where I can get the 7.5.x versions? I don't have them on my server, nor do I have any idea where I'd be able to obtain them. I would ask SWSoft except I'm hosted on a GoDaddy VPS where the license belongs to them so I'm unable to get help. Additionally, GoDaddy are of no help whatsoever.

Can anyone provide the psadump and psarestore files (and any related files) for 7.5.x? (Fedora Core 2)

Thanks for the reply. Much appreciated.

[scott]

sure, you want the "psa-bu" rpm from the [psa-7.5] channel. Take a look at the downloads link off the main page, the yum config is listed in there.

[Jake]

Fantastic!
I did the install for the backup utilities and it worked fine.
I was a little worried since it needed to update my Plesk version to a later version, but everything's back up and running perfectly.

Now to muster up the courage to upgrade MySQL

Thanks for the help Scott!