Hi,
thanks for your post, and sorry for the trouble.
How exactly did you migrate, i.e. what did the backup files contain?
Do you still have access to the old site? If so, you could export the tables from there again, within TablePress, to the JSON format, and then import those files on the new site.
Regards,
Tobias
Hi Tobias,
Thanks for the quick response. I have backup file of public_html folder and sql database file and wordpress xml files and I don’t have access to the old site.Kindly help me.
Thanks
Andy
Hi Andy,
ok, the SQL database file and the WordPress XML export are good starting points here. With those, it should be possible to restore the tables.
To find out if the table data is in your database (and only the relationship between the table ID and internal WordPress post ID went missing), you can use the small plugin from https://tablepress.org/download/extension/tablepress-debug.zip
This will add a “TP Tables” entry in the admin menu, which should show all tables in their raw format. If that page then shows all your tables, we can continue with restoring the mentioned relationship via the “Debug” tab in TablePress.
Regards,
Tobias
Hi Tobias
Thanks for the comment. I have installed the debug plugin and I see the below options please check the link below for the screenshot
regards
Andy
Hi,
ok, what’s a bit strange is that this Plugin Option is there, but the tables are not …
Do you see a “TP Tables” entry in the main admin menu on the left? When you open that, do you see a list of your tables?
Regards,
Tobias
Hi No tables available there.its empty.
Thanks
Hi,
ok, then the migration didn’t take into account the tables for some reason.
Can you maybe send me the XML file by email (the address is in https://tablepress.org/impressum/ )? I’ll check if I can extract the table data from that.
Regards,
Tobias
Hi Tobias,
email sent.Kindly check and help me out.
Thanks
Andy
Hi,
thanks! I just emailed you back. I was able to extract four tables from the export and could restore them to the JSON format 🙂
Regards,
Tobias
Hi Tobias
Perfect.Thanks for your support. I am able to extract the tables now.
Regards
Andy
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!