Title: Migration lost tablepress data
Last modified: December 13, 2022

---

# Migration lost tablepress data

 *  Resolved [patrickmg](https://wordpress.org/support/users/patrickmg/)
 * (@patrickmg)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/)
 * Having undergone a migration the tables were not exported prior to migration.
   Is there any utility or method of recreating the table data so that the posts
   which the shortcode is used display the data .. as opposed to the just shortcode.
   The old server has been decommissioned. The reason I am desperate is that it 
   effects about 200 tables created over a 6 year span!

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16284825)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * How exactly did you migrate your site from the old to the new server? What kind
   of data transfer did you use? What kind of backups do you have available?
 * If you are lucky, the table data was migrated, but just the connection between
   table ID and internal WordPress post ID was lost. If the data was not migrated
   as well, the only chance would be to restore it from the backup — especially 
   if the old server/site is no longer available.
 * Regards,
    Tobias
 *  Thread Starter [patrickmg](https://wordpress.org/support/users/patrickmg/)
 * (@patrickmg)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16295498)
 * Sorry I responded to the eMail:
 * I FTP’d all the files to my laptop and the did the same in reverse to my empty
   website that was created on the new server. The host software to migrate automatically
   didn’t work. Then I updated and loaded the plug ins. imported all the posts and
   media and menu and  theme information. I needed to configure the header settings
   and then had a website which looked like what i was expecting. Later looking 
   at some older posts I noticed I was just seeing the shortcode for the table. 
   The plug in showed no tables.
 * I also have a backup of the website and database  – a managewp one  – which I
   have loaded to the new servers staging platform. But the server wont display 
   the website!
 * I thought the tablepress info might be stored in the posts somewhere and worse
   cas i could get an extract of post/tableod/filename.
 * By the way I am 72 and not too technical. Just ended up inheriting looking after
   our website and blog posts!!
 * Kind regards
 * Patrick
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16295537)
 * Hi,
 * thanks for the details! Tables are indeed not stored in files, so we will likely
   need to look at the backup.
 * Also, what exactly does “imported all the posts and media and menu and  theme
   information” mean? How did you do that?
 * And what did ManageWP give you as a backup? Is it some sort of file?
 * Regards,
   Tobias
 *  Thread Starter [patrickmg](https://wordpress.org/support/users/patrickmg/)
 * (@patrickmg)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16302101)
 *     ```wp-block-code
       I copied, via FTP,  the Public_html folders and the mysql_backups folder to my laptop.
   
       The latter seems to be a daily backup of a file with the date and time e.g.
   
       wilmslow7_site – 10.169.0.73—14-11-2022-10-15-25.sql.gz
   
       I also had a managedwp backup. This is a zip file
   
       “wilmslowrunningclub.co.uk_2022-Nov-09_backup_637522e0491aa6.62042390”   - size 2.33gb  which is supposed to contain all the files needed to restore my website. I restore this to the staging environment – but can’t access it. It just hangs on the url https://xxx.com/wp-admin. Where xxx is the staging Server name.
   
       I had to create a new empty WordPress website on the new server and the SFTP’d the folders back.
   
       In the old website Dashboard I then used the Tools/Export and exported all. Then on the new website did a Tools/import.   For some reason 14  months of media were missing! So I used a plugin Extract all media on the old website and its import functionality on the new website to restore thos missing folders!
   
       For the new website to look like the old one It needed me to configure the header, menu, footer, widget parameters on the new site site.Just did compare and made sure they matched.  
   
       As for the themes. The old website used Nirvana. It didn’t look anything like it used to on the new website. So on the old website I  used the dashboard Nirvana Settings  and exported  the Nirvana Theme Options and on the new website I imported them.
   
       Then on testing I found the table short codes didn’t work. There was no table entries on the new website.
   
       I tried to go back to the old website – but it was no longer available. Hence the problem.
       ```
   
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16302134)
 * Hi,
 * If possible, I’d like to take a direct look at this on your site. Could you therefore
   please get in touch via email (the address is in the main plugin file “tablepress.
   php”)? That way, I can investigate this directly. Thanks!
 * Regards,
   Tobias

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

The topic ‘Migration lost tablepress data’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/migration-lost-tablepress-data/#post-16302134)
 * Status: resolved