I am trying to export my database running this command :
sudo mysqldump -h wordpress -u root -p bitnami_wordpress >rescue2.database.sql
and got this error :
mysqldump: Got error: 2005: “Unknown MySQL server host ‘wordpress’ (-2)” when trying to connect
I am on a Debian 4.19.208-1 (2021-09-29) x86_64
Thanks for helping it’s been 2 weeks I am searching for…
CodePudding user response:
As suggested by Akina, -h specifies the IP Address of the host, for example localhost or any local ip on which the mysql server might be running.
Refer below command for further usage.
mysqldump -u [user name] –p [password] [options] [database_name] [tablename] > [dumpfilename.sql]
or:
mysqldump [OPTIONS] database [tables]
where the [OPTIONS]
can be (only some often used):
- -h, --host=name Connect to host.
- -p, --password[=name]
- -u, --user=name User for login if not current user.
for a complete list you can do: mysqldump --help
, or take a look at the documentation
CodePudding user response:
Look at the file called wp-config.php
at the top level of your WordPress installation. It contains lines like these:
define( 'DB_NAME', 'my_wordpress' );
define( 'DB_USER', 'EmileCantero' );
define( 'DB_PASSWORD', 'some_secret_password' );
define( 'DB_HOST', 'whatever.example.com' );
Use that information in your mysqldump
command like so
mysqldump -h whatever.example.com -u EmileCantero -p my_wordpress >rescue2.database.sql
Avoid running this as root (avoid sudo
) unless you cannot get it to work any other way.
A better way for most WP site operators: use one of the free WordPress backup plugins.