You can locate the sql clause code like /usr/bin/mysqlbinlog -v –start-position=142743807 –stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log Then compare slave and master database difference according to temp.log on specific pos. Then update slave database. Then skip that line with mysql -e “stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;”;
ERROR 1231 (42000): Variable ‘general_log_file’ can’t be set to the value of ‘/var/lib/msyql/ubuntu.log’ What’s going on? The simple answer is this file doesn’t exist. You type too fast. There is a typo in the file name, it should be /var/lib/mysql/ubuntu.log.
Contact Rackspace support.. That’s what they’re there for. Do everything they suggest. If that doesn’t work, try Dan’s suggestion of data recovery software. Use this as an opportunity for growth and learning. Always ensure that all your servers are backed up, and test the backups regularly. There’s no point in having a backup service if … Read more
Yes, you are correct that if you don’t specify –ssl-ca then the client does not check the server certificate at all. Since it works without that option the most likely reason for the failure is that the client doesn’t trust the server certificate. If you are using self-signed client and server certificates then the ca.cert … Read more
I think that it needs username and password mysql_upgrade -u root -p If I don’t pass them I get your error Edit: thanks to the comments now I know that there are other reasons, maybe less frequent but it’s best to be aware of them too So you get that error when you didn’t pass … Read more