I need create a Backup mysql

cebraic 2020-03-03 23:03:24 UTC #1

Keywords: WordPress + NGINX + SSL - Google Cloud Platform - How to - Other
Description:
I would like backup my database name named bn_wordpress in command line via putty

Anyone could help me? Excuse me, i do not fluent in english

I tried mysqldump -u root -p"password" bn_wordpress > backup.sql but fail

michiel 2020-03-04 07:48:06 UTC #2

Hi @cebraic,

The following guide shows how to create a MySQL backup:

https://docs.bitnami.com/google/apps/wordpress-pro/administration/backup-restore-mysql-mariadb/

Regards,
Michiel

cebraic 2020-03-04 12:02:53 UTC #4

I did just that and it didn't work out, buddy.
My database is named btn_wordpress.
I used the command: mysqldump -u root -p"password" bn_wordpress > backup.sql and it didn't work out.

jota 2020-03-05 08:05:19 UTC #5

Hi @cebraic,

What error did you get? Please note that the database we create by default is called bitnami_wordpress and not bn_wordpress (this is the username we configure in WordPress to access the database).

I hope this helps

cebraic 2020-03-05 12:20:34 UTC #7

using google translator

I was really putting it wrong, but now I corrected.

I got in with the right command. When prompt asked for a password, I entered correctly.
Still, it's still error message.

root@wordpresspro-2-vm:/home/cebraic# sudo su
root@wordpresspro-2-vm:/home/cebraic# mysqldump -u root -p bitnami_wordpress > backup.sql
Enter password:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
root@wordpresspro-2-vm:/home/cebraic#

Part my wp-config.php

/ ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define( 'DB_NAME', 'bitnami_wordpress' );
/** MySQL database username */
define( 'DB_USER', 'bn_wordpress' );
/** MySQL database password */
define( 'DB_PASSWORD', 'password' );
/** MySQL hostname */
define( 'DB_HOST', 'localhost:3306' )

jota 2020-03-06 07:52:51 UTC #8

Hi @cebraic,

Please note that if you use the root user when connecting to the database, you also need to use the main password we configured when you boot the instance. That password is the same one you use to access WordPress unless you changed it and you can obtain it by following this guide

https://docs.bitnami.com/google/faq/get-started/find-credentials/

You can also use the database user and password that is configured in the WordPress conf file. That means that you will need to use this command and the password that is shown in the wp-config.php file

mysqldump -u bn_wordpress -p bitnami_wordpress > backup.sql

Happy to help!

Was my answer helpful? Click on

cebraic 2020-03-06 12:28:10 UTC #9

mysqldump -u bn_wordpress -p bitnami_wordpress > backup.sql is ok

Thank you

Não consegui de jeito nenhum com a senha principal e nem com a senha quando entrando com o caminho anterior, mas usando bn_wordpress deu certo. Muito obrigado.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!