Database restore problem.

  • Resolved VP

    (@studio500)


    13 years, 7 months ago

    Hi Tobias
    Great plugin many thanks.

    I’ve had to re install worpress but only had one export file backed up which has loaded onto the new install fine.

    The only other stored data was from a database stored on my onld server.

    I copied these files from old database and imported them into my new database.

    “wp_table_reloaded_data_X”, and you will have two more general entries, named “wp_table_reloaded_tables” and “wp_table_reloaded_options”.
    All of those need to be re-inserted into your database.

    The import went fine but when I log into WP T Reloaded I cannot see anything other than my one original imported back up file.

    Am I missing something?

    Regards

    Marc

    http://ww.wp.xz.cn/extend/plugins/wp-table-reloaded/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 7 months ago

    Hi Marc,

    sorry to hear that you had to reinstall WordPress 🙁 Unfortunately, without proper backups this can indeed be troublesome.

    From what I understand, you tried to restore tables from two different backups, and that didn’t quite work out.
    Instead, I would suggest to focus on restoring from the mySQL backup, as that seems to be your complete backup. So, delete everything related to WP-Table Reloaded from the database again (all the options that you already mentioned in the “wp_options” table).
    Then restore those mentioned again from your mySQL backup.
    That should hopefully get your tables back.
    Another possibility, that allows you to play with this more, might be to first try this on a temporary test installation (e.g. on a localhost dev environment). Once the restore process succeeds there, you could create a WP-Table Reloaded Dump File to also restore everything on the real site, and to also have a better backup in case this happens again.

    Regards,
    Tobias

    Thread Starter VP

    (@studio500)

    13 years, 7 months ago

    Brilliant!

    Thank you Tobias for getting me back up and running.
    It worked like a charm!

    I really do think your plugin is excellent and I really do appreciate you taking the time to respond to my support question in a well explained manner.

    I have made a $15.00 Paypal donation, I tried Euros but for some reason that didn’t work for me lol.

    It’s not my day :0(
    Anyway thank you once again.

    Regards

    Marc

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 7 months ago

    Hi Marc,

    very good news! Great to hear that the second try was successful! 🙂

    And thanks for the donation, that’s really very nice!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database restore problem.’ is closed to new replies.

Tags