[Plugin: WP-Table Reloaded] importing table data from WP backup files

  • Resolved TheCCE

    (@thecce)


    15 years, 5 months ago

    Hi, Tobias.

    I’m wondering if you can help me recover two tables I can’t find after deleting and restoring one of my sites (TheCCE.org).

    I didn’t export my tables before deleting and restoring the site, figuring that the data would be captured in the backup files. I restored the site using an XML import, but the plugin isn’t showing that any any tables are present.

    Where can I locate, and how do I restore, the info for my tables in my backup files? I have an SQL backup of my database, a full FTP download of the site files and the XML file. I’ve searched in each of these and…I found the data. Unfortunately it was before I’d had my first cup of coffee and I can’t relocate the info/don’t know which file it was in.

    I’m really enjoying the functionality of WP-Table Reloaded, and greatly appreciate any assistance you can provide here.

    Thanks!

    Allan

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter TheCCE

    (@thecce)

    15 years, 5 months ago

    Okay, I’ve managed to find the data for both tables, within an SQL backup file.

    Tobias, you you please let me know which part of the code I need to import as SQL in phpMyAdmin?

    Here is what I believe to be the first line relating to the table:

    INSERT INTO wp_options (option_id, blog_id, option_name, option_value, autoload) VALUES
    (4257, 0, ‘wp_table_reloaded_data_3’,…

    I tried copying everything down to the next INSERT INTO tag, but got a duplicate entry error:

    Duplicate entry ‘_transient_timeout_feed_********’ for key 2

    Two questions:
    1) What code do I need to copy (and how do I avoid a duplicate entry error)?
    2) Is there an easier way than importing the SQL to restore the tables?

    Thanks very much!

    Allan

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 5 months ago

    Hi,

    yes, the tables are in the SQL backup.

    You will have one entry for each table, named like “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 “_transient_timeout_feed_” entry that you mention seems to be an additional line in your backup file already, i.e. the next database row. I guess you selected too much text in the file.

    The much easier way to restore tables is of course from a WP-Table Reloaded Dump file, the plugin’s custom backup file. But unfortunately you don’t have one and now it is too late to create one :-/

    Regards,
    Tobias

    Thread Starter TheCCE

    (@thecce)

    15 years, 5 months ago

    Thanks, Tobias. I’ll give this a try, and will be sure to create backup files after.

    Is there some kind of configuration I need to do to have the SQL file import the table data properly, or can that only be done with a dump file via WP-Table Reloaded?

    Allan

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    15 years, 5 months ago

    Hi,

    no, there is nothing special that you need, just a database access tool, like phpMyAdmin. Then, execute the extracted parts of the SQL backup there, and the database rows will be added for you.

    For a WP-Table Reloaded Dump file, you don’t need such extra database tool, the file is simply re-imported on the “Plugin Options” screen.

    Regards,
    Tobias

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

The topic ‘[Plugin: WP-Table Reloaded] importing table data from WP backup files’ is closed to new replies.

Tags