Error while backing up database alrnetwork_sitename
Error while backing up database alrnetwork_databasename The sql file is 0 bytes in size: /home/tmp/alrnetwork.550376/alrnetwork/backup/alrnetwork_databasename.sql
mysqldump error output: mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" when trying to connect
If you mean to what we are doing I would say no. Did this just start with the DA upgrade? I would most likely create a separate thread or log a support request.However, not sure if this is connected or not, but backups are no longer working:
ls /root/.my.cnf
root@srv1:/etc# ls my.cnf
my.cnf
GNU nano 4.8 /etc/my.cnf
[mysqld]
#local values
local-infile=0
#skip-name-resolve=1
#log-error=/usr/local/mysql/data/srv1.alr-network.co.uk.err
bind-address = 127.0.0.1
max_allowed_packet=64MB
#max_connections=25
wait_timeout=100
#innodb values
innodb_log_file_size=896MB #25% of Buffer pool
innodb_file_per_table
innodb_buffer_pool_size=7G # 50% of memory
innodb_buffer_pool_instances=7 #1 per GB
#temp values
tmpdir=/tmp
join_buffer_size=256k
table_definition_cache=1000
thread_cache_size=1000
Good I meant this. Its a known issue. Sometime some software creates a hidden my.cnfI receive: "ls: cannot access '/root/.my.cnf': No such file or directory"
what happens with
Code:cd /usr/local/directadmin/custombuild ./build mysql_backup
root@srv1:~# cd /usr/local/directadmin/custombuild
root@srv1:/usr/local/directadmin/custombuild# ./build mysql_backup
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@srv1:/usr/local/directadmin/custombuild#
root@srv1:~# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@srv1:~#
root@srv1:~# find / -name mysql.sock
/var/lib/mysql/mysql.sock
find: ‘/proc/167625’: No such file or directory
root@srv1:~# ls /usr/local/mysql/data/mysql.sock
/usr/local/mysql/data/mysql.sock
I wanted you to know for the current time I wont be able to help. I wanted to post this here. So others might help out.No worries. Just as long as you know, I'm ready to continue whenever you are