Bash Script: MySQL Database backup to AWS S3
MySQL backup bash script which will upload the backup files in AWS s3 bucket.
mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
It was time to take backup of mysql database of my server. I run the command mysqldump with some options and found the error, ” mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed and should be repaired when using LOCK TABLES ” I have seen this error before but not written on this…
mysqldump Error Binlogging on server not active
While using the mysqldump command in one of the MySQL server I got the error mysqldump: Error: Binlogging on server not active . Below given is the quick solution for it. Details of MySQL Server: MySQL Server: mysql-server-5.5.34 Error: Binlogging on server not active Note: The path of my.cnf file In CentOS and Red Hat…