SQL dump incomplete

  • sebuser

    (@sebuser)


    1 year, 5 months ago

    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

    (@dbisupport)

    1 year, 5 months ago

    Hi @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

    (@sebuser)

    1 year, 5 months ago

    Sure, here are the relevant bits from the diagnostic file:

    Web Server: ………………… Apache
    PHP: ………………………. 8.2.24
    WP Memory Limit: ……………. 256M
    PHP Time Limit: …………….. 120

    WP Max Upload Size: 256 MB
    PHP Post Max Size: 256 MB

    Media Uploads
    Transfer Bottleneck: …… 256 MB
    Upload Folder Permissions: 755

    Themes & Plugins
    Transfer Bottleneck: ……… 256 MB
    Themes Permissions: ………. 755
    Plugins Permissions: ……… 755
    Must-Use Plugins Permissions: 755
    WP-Content Permissions: …… 755
    WP-Core Permissions: ……… 755

    WPMDB Bottleneck: …… 1 MB
    Compatibility Mode: …. No
    Delay Between Requests: 0

    Thread Starter sebuser

    (@sebuser)

    1 year, 5 months ago

    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

    (@dbisupport)

    1 year, 5 months ago

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