Textpattern CMS

#1 2011-08-05 22:12:22

dreamer

Member

Registered: 2007-06-08

Posts: 242

How to recover lost data after upgrading Mysql 5.0

So my site was running on Mysql 4.1.25 and I needed to upgrade to v5.0 through my host. After upgrading, all content is gone on my site . Luckily, I downloaded the sql backup file before upgrading. I can’t access the backend of TXP anymore after this upgrade so I will have to go through phpmyadmin. My question is if there are certain procedures or checkboxes I need to check off as I go through the process of injecting the sql file? I’m not a DB guru so don’t want to screw up.

And once I inject the file, will the site start working again despite my being on 5.0?

#2 2011-08-06 02:38:30

maruchan

Member

From: Ukiah, California

Registered: 2010-06-12

Posts: 596

Website

Re: How to recover lost data after upgrading Mysql 5.0

It’s very quick and painless to import the SQL, and you can always delete and start again if you need to. I’m guessing it’ll work just fine. No checkboxes should be necessary.

One thing I heard about the MySQL 4 —> 5 upgrade process is that it will leave a backup of your database under /tmp somewhere, but I’m not sure if that’s true in all cases. Just saw somebody lose their data and find it again thanks to that tip. :-)

Last edited by maruchan (2011-08-06 02:39:16)