1
caek9
Attempted upgrade FUBAR'd site. Anyway to recover data?
  • 2008/7/9 22:02

  • caek9

  • Friend of XOOPS

  • Posts: 35

  • Since: 2008/7/9 2


I attempted to upgrade an outdated installation of xoops, long story short, I messed up somewhere along the line, and I am left unable to restore the site to it's previous state. Is there anyway I can restore this data. I have a copy of the MySQL database after the failed upgrade.


My question is, is there anyway to recover users and news, forum posts, at all?

My site has been using XOOPS for 4 years and I would hate to loose all my data.

Please tell me if you need any more information to answer my question and I will be happy to provide.

2
jdseymour
Re: Attempted upgrade FUBAR'd site. Anyway to recover data?

You should be able to extract the data from the modules from your backup. It should import with no trouble as long as the module installed is of the same version backed up in the database.

3
caek9
Re: Attempted upgrade FUBAR'd site. Anyway to recover data?
  • 2008/7/9 22:56

  • caek9

  • Friend of XOOPS

  • Posts: 35

  • Since: 2008/7/9 2


That sounds perfect, just, I'm not sure how I would go about doing it. Could you give me some detailed instructions or point me to a guide?

4
ghia
Re: Attempted upgrade FUBAR'd site. Anyway to recover data?
  • 2008/7/9 23:28

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
I have a copy of the MySQL database after the failed upgrade.
You shoud have a backup of BEFORE the upgrade!

If your site provides phpMyAdmin, you can do it with the export (out of the old DB) and import to the new fresh database. Verify the differences of the fields in the required tables between original and target and adapt the SQL-scripts. You find also inspiration in the update.php and readme files from the final and intermediate versions.
BTW what was the original version?

Login

Who's Online

403 user(s) are online (268 user(s) are browsing Support Forums)


Members: 0


Guests: 403


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits