After Update...

[arch3angel]

As many know the incompatiabllity issues we all got a message on, well one of my employees freaked out and updated the mysql due to the fear of a security issue.

Now none of the sites on that server are working. The problem is he never backed up the databases prior to doing anything. So here is my questions...

Is there a way to go back to a previous version after this update?

Is there a way to recover the databases, if not i have a slightly older copy from a previous backup but would like the most recent.

What is everyones suggestions on this one...





P.s. I know the first rule is BACKUP, BACKUP, BACKUP and I fault myself for not explaining things to him better, but on that same note he was meaning well when he did it...

 

[AndyReed]

As many know the incompatiabllity issues we all got a message on, well one of my employees freaked out and updated the mysql due to the fear of a security issue.

Now none of the sites on that server are working.

Did he follow the instructions given in the cPanel on how to upgrade MySQL? Did you check the log files for errors? There is a way to fix the DBs and related tables, if they are not completely fried.

 

[dalem]

5.0 to 4.1 I did it no problems (but I did make backups just in case)

5.0/4.1 to 4.0 might have some trouble with this one

 

[arch3angel]

Did he follow the instructions given in the cPanel on how to upgrade MySQL? Did you check the log files for errors? There is a way to fix the DBs and related tables, if they are not completely fried.

From what I seen, NO he did not follow the directions, thus not having any backups...

So not having backups, my main concern is moving back to the original version and using the older databases...

Suggestions welcome...

Thanks

 

[arch3angel]

Ok...

If i have the older databases what is the process to go back to the original MySQL version?

Thanks...