Title: SQL dump incomplete
Last modified: October 2, 2024

---

# SQL dump incomplete

 *  [sebuser](https://wordpress.org/support/users/sebuser/)
 * (@sebuser)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/)
 * I used to be able to create an export of my WordPress website with WP Migrate
   Lite without problems. Now I encounter the issue that whenever I do an export
   that contains the database plus anything else (e.g., any of the theme or the 
   WordPress config file), the SQL dump file is only 136KB big and only contains
   one table (xrq_yoast_seo_links). When I do an export that contains only the database,
   the sql dump is correct.
   This is annoying as it means I need to do 2 exports,
   one of the db alone and one of the rest and then replace the sql dump in the 
   second export with the correct sql dump of the first.

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

 *  Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/)
 * (@dbisupport)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/#post-18051851)
 * Hi [@sebuser](https://wordpress.org/support/users/sebuser/) ,
 * WP Migrate Support Team here. Thanks for reaching out with your query, we would
   be happy to assist!
 * We would like to check if you have any server limitations that could be affecting
   the migration (e.g. max upload size, max post size, etc.). Would you be able 
   to send us the debugging information from the Help tab on the site that you are
   having issues in?
    1. Go to the Help tab of your local install
    2. Scroll down to the “Diagnostic Info & Error Log”
    3. Click the “Download” button and save to your computer
    4. Reply to this thread with the contents of the diagnostic file. You may remove
       any sensitive information.
 * Also, is debugging activated on your site? Do you see any errors in your debug.
   log file that could be related to the issue?
 *  Thread Starter [sebuser](https://wordpress.org/support/users/sebuser/)
 * (@sebuser)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/#post-18057729)
 * Sure, here are the relevant bits from the diagnostic file:
 * Web Server: ………………… Apache
   PHP: ………………………. 8.2.24WP Memory Limit: ……………. 256MPHP
   Time Limit: …………….. 120
 * WP Max Upload Size: 256 MB
   PHP Post Max Size: 256 MB
 * Media Uploads
   Transfer Bottleneck: …… 256 MBUpload Folder Permissions: 755
 * Themes & Plugins
   Transfer Bottleneck: ……… 256 MBThemes Permissions: ………. 755Plugins
   Permissions: ……… 755Must-Use Plugins Permissions: 755WP-Content Permissions: ……
   755WP-Core Permissions: ……… 755WPMDB Bottleneck: …… 1 MBCompatibility Mode: ….
   NoDelay Between Requests: 0
 *  Thread Starter [sebuser](https://wordpress.org/support/users/sebuser/)
 * (@sebuser)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/#post-18058344)
 * I switched on DEBUG and made an export, which again created the too small sqldump.
   Nothing meaningful in the debug logs.
 *  Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/)
 * (@dbisupport)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/#post-18058508)
 * Hi [@sebuser](https://wordpress.org/support/users/sebuser/),
 * Thanks for providing further information!
 * Could you please try and temporarily deactivate all other plugins except WP Migrate
   and switch to a default theme then retry the migration to check for any compatibility
   issues?
 * If you also have any firewalls / security setting in place, please also try and
   temporarily deactivate those.
 * Please also confirm if there were any errors found on the diagnostic information
   of the plugin.
 * Looking forward to hearing back.

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

The topic ‘SQL dump incomplete’ is closed to new replies.

 * ![](https://ps.w.org/wp-migrate-db/assets/icon.svg?rev=2851356)
 * [WP Migrate Lite - Migration Made Easy](https://wordpress.org/plugins/wp-migrate-db/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-migrate-db/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-migrate-db/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-migrate-db/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-migrate-db/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-migrate-db/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/)
 * Last activity: [1 year, 8 months ago](https://wordpress.org/support/topic/sql-dump-incomplete/#post-18058508)
 * Status: not resolved