Question

Im installing Wordpress Using EasyEngine, How I backup my database, when My site has been take down by DMCA in Digital Ocean

Posted February 27, 2020 202 views
NginxWordPressBackups

My site got hit by DMCA and badly I didnt know until I see my site was down, Im planing to move my site to another hosting, but how do I backup my wordpress database and download it, wp file already succeed being backup, but I cant dump any database

Add a comment
caknoris696
By:
caknoris696
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
KDSys February 28, 2020

Hi @caknoris696,

I’m sorry to hear that, can you confirm exactly what happened, maybe we can remedy the situation somehow?

As for the Database backup, it should be fairly easy. Find your DB credentials which should be located in your website’s wp-config.php.

As soon as you do, executing the following command 

mysqldump -u username -p database > databasebackup.sql

As soon as you hit enter, you’ll be asked for the Database’s password.

Regards,
KDSys

Reply Report
caknoris696 February 28, 2020

Hey @KDSys,

Thats it, I’m already see my wp-config configuration which is:

/** The name of the database for WordPress */
define( 'DB_NAME', 'taruhaneuro2020_com' );

but when im using

mysqldump -u root -p taruhaneuro2020_com > databasebackup.sql

its give me this error

mysqldump: Got error: 1049: Unknown database 'taruhaneuro2020_com' when selecting the database
edited by MattIPv4
Reply Report
  • KDSys February 28, 2020

    Hi @caknoris696,

    Are you sude the Database is actually hosted on this Droplet and not somewhere else? What does it state in your wp-config.php file for DB_HOST ?

    Regards,
    KDSys

    Reply Report
    • caknoris696 February 29, 2020 
      /** MySQL hostname */
define( 'DB_HOST', 'global-db:3306' );
      Reply Report
      • KDSys February 29, 2020

        It seems like your database is stored somewhere else and not on your current droplet. That’s why when you execute the mysqldump command you get an error - unknown database.

        You’ll need to include the host in your mysqldump command like so

        mysqldump -u username -p database -h host > database.sql

        Regards,
        KDSys

        Reply Report
        • caknoris696 March 1, 2020

          thx for response, I dont know where is my database host because im just installing wordpress using EasyEngine…

          Im tryin this but result the same error

          mysqldump -u root -p taruhaneuro2020_com -h global-db:3306 > gaspol.sql

mysqldump: Got error: 2005: Unknown MySQL server host 'global-db:3306' (11) when trying to connect
          Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help