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
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
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
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.
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
