SQL db export fails: is –no-tablespaces supported?

  • Resolved MrMattEastwood

    (@mrmatteastwood)


    4 years, 4 months ago

    Hello, All in One WP Migration team,

    On beauty-direct.de, the site export fails when attempting to export the SQL database. The site’s hosting company, iWelt, tells me the following:

    Starting with MySQL version 5.7.31 (from Jul 13th, 2020), a certain “PROCESS” privilege is required, as outlined in the release notes, section “Security Notes” – “Incompatible Change” (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html).

    They say that since theirs is shared hosting, they cannot set that permission on a per-user basis. In order for exports to work, AIO WP Migration would need to support the “–no-tablespaces” flag.

    Is this implemented? Is there a way to enable it? We’re running version 7.31.

    Thanks!
    Matt and the 2SINN team.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Yani

    (@yaniiliev)

    Hi Matt,

    What error do you see when you attempt to export the database?

    The MySQL change only affects mysqldump but the plugin is not using it so it does not have any effect on the export.

    Thread Starter MrMattEastwood

    (@mrmatteastwood)

    Hey Yani, thanks for your quick response. Unfortunately, the error message is only the standard “Unable to export”:

    https://pasteboard.co/JC8UdrC.png

    Would you be willing to provide any further information on how the plugin exports SQL databases? I could go back to the hosting company with that and perhaps they’ll be able to investigate further on their end.

    Plugin Author Yani

    (@yaniiliev)

    See if there is an error.log file in the wp-content/plugins/all-in-one-wp-migration/storage folder.
    Download the file then examine it.
    If the file does not exist, reach over to your hosting provider and ask them for the php error log for your website. Examine it and look for errors around the time when you ran the export.

    Thread Starter MrMattEastwood

    (@mrmatteastwood)

    A-ha! Look a lot like it’s running out of memory.

    Nov 26 2020 12:03:46
    {“type”:1,”message”:”Allowed memory size of 67108864 bytes exhausted (tried to allocate 585728 bytes)”,”file”:”\/var\/www\/web436\/htdocs\/prod\/beautydirect\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database-mysqli.php”,”line”:42}

    Gonna let the host know.

    Plugin Author Yani

    (@yaniiliev)

    Yes, that’s quite low, 64MB.
    Try it with 128MB or 256MB.

    You also want to request the PHP error log from your hosting to see if there are other times when the site is running out of memory, making your website inaccessible to your users.

    Thread Starter MrMattEastwood

    (@mrmatteastwood)

    Sounds good, thanks again for the quick response. AIO WP Migration rocks, btw. I’ve used it constantly for many years now and it’s never let me down! Keep up the awesome work ??

    Plugin Author Yani

    (@yaniiliev)

    I am happy to learn about your experience.
    Thank you!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘SQL db export fails: is –no-tablespaces supported?’ is closed to new replies.