Keywords: WordPress - Amazon Web Services - Technical issue - Other
I'm trying to do database management via SSH for Bitnami's WordPress Multi-tier Stack/ Specifically I want to export and do an initial import (though I will probably just create a new database).
When I run the following commands, I get the following errors:
mysqldump -u root -p bitnami_wordpress > bitnami_wordpress.sql
mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (2)" when trying to connect
This also creates an 0B SQL file in my home directory.
mysqladmin -u root -p status (I enter my password)
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket .
Check that mysqld is running and that the socket:
cd /opt/bitnami/mariadb/ +
bin CREDITS include licenses README-wsrep
COPYING data INSTALL-BINARY plugin sbin
COPYING.thirdparty EXCEPTIONS-CLIENT lib README.md share
sudo find . -name mysql
find /opt/bitnami/mysql/ -name "*.cnf"
find /opt/bitnami/mariadb/ -name "my.cnf"
nano /opt/bitnami/mariadb/share/my-medium.cnf (what's the difference between my-medium, my-small, and my-large)?
# The following options will be passed to all MariaDB clients
#password = your_password
port = 3306
socket = /opt/bitnami/mariadb/tmp/mysql.sock
/opt/bitnami/mariadb/tmp/mysql.sock does not exist.
mysql.server start (Though if my WP site is working wouldn't this already be running?)
-bash: mysql.server: command not found
I've poked around a bit and came across MariaDB's Documentation about 2002 errors, but I don't seem to have the same .conf file (nor do I know where to look)
...from here I have no idea where to go, I've only done limited database management via shell.
- How do I export my database without getting the 2002 error?
- How do I overwrite / update my database?
Any help would be much appreciated and thanks in advance!