Title: wp_posts table empty after restore Last modified: March 16, 2026 --- # wp_posts table empty after restore * Resolved [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [2 months, 3 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/) * Bonjour, * I saved the data base of my wordpress site in order to restore it locally on my computer running XAMPP. After restoring the full database I found that the wp-posts table was empty despite the message below extracted from the log file: * “[STEP] [2026-03-15 09:08:45] Getting data of table: wp_posts (76/131, 11.46 MB) [SUCCESS] [2026-03-15 09:08:46] Table export for: wp_posts finished (0.91100s)” * The wp-posts.sql file to be restored looks correct with a size of 12Mo. * Thanks in advance for your support Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Support [MixHa](https://wordpress.org/support/users/mixha/) * (@mixha) * [2 months, 3 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18854020) * Hey [@hefdut](https://wordpress.org/support/users/hefdut/) , * Thank you for reporting the issue, though issues of all kinds are not rare with XAMPP. * Can you please try to restore the backup on a test site on TasteWP and let us know how that went? * Please also share the debug log on the site where the restoration failed, so we can inspect details: Please navigate to the plugin section Troubleshooting > Check advanced options and click on the button: Share debug info with BackupBliss team * And here’s a screenshot that shows where to get it: [https://drive.google.com/file/d/1h76LMlMleF90JbsyaR2_PU8PZDAUMWsG/view?usp=sharing](https://drive.google.com/file/d/1h76LMlMleF90JbsyaR2_PU8PZDAUMWsG/view?usp=sharing) * Please paste the **debug code** in your reply (not the whole log please). * Kind regards * Thread Starter [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [2 months, 3 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18855360) * Bonjour, * thank you for your reply. * As suggested I have created a test site on TasteWP but I cannot restore the data base from the backup file (.zip). Nothing happens when I select the zipped backup file to upload it. And also there is no possibilty to store it in the backup folder through FTP. * Any suggestion about the best way to restore the data base ? * Thanks in advance * Plugin Support [MixHa](https://wordpress.org/support/users/mixha/) * (@mixha) * [2 months, 3 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18855410) * Hey [@hefdut](https://wordpress.org/support/users/hefdut/) , * Can you please confirm that for the creation of this backup, you used our plugin specifically, and in the section “What will be backed up?”, you unchecked Files, and left only Database selected for backing up? * If so, please run a simple quick validation check of the backup file: – Take a peek inside the backup file (zip), and check if it contains bmi_backup_manifest. json file as well as a folder (db_tables)? * If it doesn’t, then the backup file was not made correctly – in that case please provide the debug code from the site where the backup was created. * Looking forward to solving this issue. * Thread Starter [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [2 months, 3 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18855750) * Bonjour, * I confirm that I used your plugin for the backup and I left only Database selected for backing up. * Also I confirm that backup file (zip) contains “bmi_backup_manifest.json” and“ bmi_logs_this_backup” files, and the folder “db_tables”. In this folder there is the “wp-posts” table (size 11.7 Mo) which looks correct. In the log file everything looks OK. I have just checked and found that there is a debug code “BMI-FjviMTlx- 75141” but I am not sure whether it would be linked to this specific backup. * Il is when I restored this backup file to my local XAMPP environment that I found that the restored “wp-posts” table was empty. Nevertheless the restoring process did not fail. * Thanks in advance * Plugin Support [MixHa](https://wordpress.org/support/users/mixha/) * (@mixha) * [2 months, 2 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18856504) * Hey [@hefdut](https://wordpress.org/support/users/hefdut/) , Thank you for the additional information – so far everything seems in order. Could you also please generate a debug log from a site where you run the Restoration and share the code so we can inspect that too? Kind regards * Thread Starter [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [2 months, 2 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18857086) * Bonjour, * I have generated a debug log (debug code “BMI-eqNhm0F2-40889”) from the local XAMPP site where I run the Restoration. The issue is still the same (wp-posts table is empty despite the fact that it is correct in the backup file). * Regards * Plugin Support [MixHa](https://wordpress.org/support/users/mixha/) * (@mixha) * [2 months, 1 week ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18864472) * Hi [@hefdut](https://wordpress.org/support/users/hefdut/) , * Thank you for your detailed explanation. * After reviewing your source site, we noticed that your content is stored under a custom post type called “portfolio”, rather than the default WordPress “post” type. Because of this, these entries will not appear on the standard Posts page in the admin area or on the frontend blog page. * This behavior is expected and not related to a database restoration failure. The data is present in the ****_posts table, but it is categorized differently. * The “portfolio” post type is typically registered by your theme or its companion plugin. * To resolve the issue, please ensure that: – The same theme and required plugins are installed and activated on your local (XAMPP) environment. – After activation, check the admin sidebar for a “Portfolio” section—your content should appear there. – If the theme or plugin responsible for this post type is missing or inactive, WordPress will not recognize these entries properly, which can make it seem like the posts are missing. * Please let us know how it goes or if you need further assistance. * Kind regards * Plugin Support [MixHa](https://wordpress.org/support/users/mixha/) * (@mixha) * [2 months, 1 week ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18868888) * Hey [@hefdut](https://wordpress.org/support/users/hefdut/) , * We haven’t heard from you since, so I’ll assume that the issue is resolved and will close this support thread. If you face any new issues, please feel free to open a new thread. * Kind regards * Thread Starter [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [2 months, 1 week ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18869884) * Bonjour, * sorry for the delay in response. Unhappily the issue is not solved. * I can confirm that the same theme (Virtue) and required plugins are installed and activated on my local XAMPP environment. Also the “Portfolio” section appears in the admin sidebar but is empty. * As I mentionned in my fisrt mail, the “wp-posts” table in the backup file (zip) is correct but is not restored despite the following messages in the log file: * “[STEP] [2026-03-15 09:08:45] Getting data of table: wp_posts (76/131, 11.46 MB) [SUCCESS] [2026-03-15 09:08:46] Table export for: wp_posts finished (0.91100s)” * Do you think it could be due to XAMPP ? * Regards * Thread Starter [Hefdut](https://wordpress.org/support/users/hefdut/) * (@hefdut) * [1 month, 4 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18875916) * Bonjour, * for your information, I have replaced XAMPP with a local WAMPserver ….. and the database has been properly restored with your plugin. My site is working locally now. Backup and restore with your plugin are working with no problem. * The problem was due to XAMPP but I don’t know the reason why. * Thanks for your support. * The issue is resolved. * Regards Viewing 10 replies - 1 through 10 (of 10 total) You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwp_posts-table-empty-after-restore%2F%3Foutput_format%3Dmd&locale=en_US) to reply to this topic. * ![](https://ps.w.org/backup-backup/assets/icon-128x128.png?rev=2995566) * [Backup Migration](https://wordpress.org/plugins/backup-backup/) * [Frequently Asked Questions](https://wordpress.org/plugins/backup-backup/#faq) * [Support Threads](https://wordpress.org/support/plugin/backup-backup/) * [Active Topics](https://wordpress.org/support/plugin/backup-backup/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backup-backup/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backup-backup/reviews/) * 15 replies * 2 participants * Last reply from: [Hefdut](https://wordpress.org/support/users/hefdut/) * Last activity: [1 month, 4 weeks ago](https://wordpress.org/support/topic/wp_posts-table-empty-after-restore/#post-18875916) * Status: resolved