Error while backing up database

itdungpt

Verified User
Joined
Aug 8, 2015
Messages
24
Error while backing up database
mysqldump error output: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': Unknown system variable 'OPTION' (1193) Please tell me tips to fix use directadmin with mariadb 10.1

Please tell me tips to fix use directadmin with mariadb 10.1
Ticket #11775
 
Hello,

What do you see with:

Code:
rpm -qa | egrep -i "mysql|mariadb" | sort

and

Code:
mysqldump -V
?
 
# rpm -qa | egrep -i "mysql|mariadb" | sort

MariaDB-client-10.1.31-1.el6.x86_64
MariaDB-common-10.1.31-1.el6.x86_64
MariaDB-compat-10.1.31-1.el6.x86_64
MariaDB-devel-10.1.31-1.el6.x86_64
MariaDB-server-10.1.31-1.el6.x86_64
MariaDB-shared-10.1.31-1.el6.x86_64
MySQL-client-5.5.31-1.linux2.6.x86_64
MySQL-devel-5.5.31-1.linux2.6.x86_64
MySQL-shared-5.5.31-1.linux2.6.x86_64



# mysqldump -V
mysqldump Ver 10.13 Distrib 5.5.31, for Linux (x86_64)
 
Try and remove the following rpms:

MySQL-client-5.5.31-1.linux2.6.x86_64
MySQL-devel-5.5.31-1.linux2.6.x86_64
MySQL-shared-5.5.31-1.linux2.6.x86_64

use
--noscripts parameter for rpm if you get a "scriptlet failed" error.
 
Then removed
MySQL-client-5.5.31-1.linux2.6.x86_64
MySQL-devel-5.5.31-1.linux2.6.x86_64
MySQL-shared-5.5.31-1.linux2.6.x86_64

/etc/init.d/mysqld start very slow and can not start
 
By itself the deleted rpm`s do not effect MariaDB server and does not prevent MySQL/MariaDB from starting, you probably had a running process of MySQL server which failed to stop earlier when you migrated to MariaDB. And now it can not start dues to possible DBs corruption or errors in /etc/my.cnf.

You need to read MySQL error logs, without knowing details we can not help you. If you don't know how to do it yourself post errors here or hire somebody to fix it for you.
 
Back
Top