Settings –> SQL Script –> Mysqldump not working in SiteGround hosting

  • Resolved evridigit

    (@evridigit)


    6 years, 1 month ago

    I host my website on SiteGround, one of the Web Hosting recommended by www.ads-software.com (https://www.ads-software.com/hosting/)
    The hosting service level is “GoGeek”, the most powerful and expensive between the shared hosting service provided by SiteGround.

    Trying to create a Duplicator package using the Mysqldump option in Settings –> SQL Script is not working.

    I contacted the SiteGround’s Support and this is their answer:
    —

    
The problem is that the duplicator was trying to use incorrect details to perform an export of your DB:
Code:
/ * DUPLICATOR-LITE (MYSQL-DUMP BUILD MODE) MYSQL SCRIPT CREATED ON: 2019-02-05 04:39:34 * /

mysqldump: Got error: 1045: Access denied for user 'xxxxxxxxxx' @ 'localhost' (using password: YES) when trying to connect

/ * WordPress Duplicator Timestamp: 2019-02-05 04: 39: 34 * /
/ * DUPLICATOR_MYSQLDUMP_EOF * /

Unfortunately I can not tell you why the plugin is not able to get the correct DB details - your wp-config is obviously correct because the site itself works and the DB does not seem to be defined anywhere else, and the Duplicator plugin itself is able to detect the complete information of the DB before the last step in the creation of the archive.

I have however changed the backup method of the DB from mysqldump to php script and the process was able to terminate almost instantly, so something within their MysQL configuration must read incorrect data. If you want to solve this problem you can contact the plugin developers for further assistance, but for now your plugin will work with PHP based database backup.

    Hope this helps.

    Ciao
    Andrea

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

  • Hey @evridigit,

    We also use Siteground for our testing and don’t have any issue with it. It might be that you have a special character in your password that is having issues getting processed on the command line or that your DB user does not have enough privileges, most likely the former.

    If you want to submit a support ticket for this issue I can have a closer look at your setup. Please provide a link to this thread when submitting the ticket.

    Thanks~

    You are right bro.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Settings –> SQL Script –> Mysqldump not working in SiteGround hosting’ is closed to new replies.