System Backup - mysql problem

slsystems

Verified User
Joined
Feb 23, 2010
Messages
7
Location
Poland, Krakow
Hello
I make a "system backup" , I choose only the mysql database and the results message is as follows:

Performing sanity checks: Completed
Checking load average: Completed
Checking free disk space: Completed
Performing MySQL backup
Stage 1 MySQL backup:Backup path for full-mysql invalid, aborting...
Performing cleanup operations: Completed

(mysql data is in /var/lib/mysql, not /home/mysql if it matters)

Where to setup a path for "full-mysql"?
 
Hello,

Are you running debian or FreeBSD?

To solve the issue either create a symlink from /var/lib/mysql to /home/mysql

Or open /usr/local/sysbk/conf.sysbk

and change

Code:
MYSQL_PATH="/home/mysql"

to

Code:
MYSQL_PATH="/var/lib/mysql"

see

Code:
if [ "$OS" = "FreeBSD" ]; then
[B]        MYSQL_PATH="/home/mysql"[/B]
        MYSQL_INIT="/usr/local/etc/rc.d/mysqld"
        MYSQL_PID="$MYSQL_PATH/`hostname -s`.pid"
        MYSQL_DUMP="/usr/local/mysql/bin/mysqldump"
        MYSQL_MYICHK="/usr/local/mysql/bin/myisamchk"
else
        if [ "$OS" = "debian" ]; then
[B]                MYSQL_PATH="/home/mysql"[/B]
                MYSQL_INIT="/etc/init.d/mysqld"
                MYSQL_PID="$MYSQL_PATH/`hostname -s`.pid"
                MYSQL_DUMP="/usr/local/mysql/bin/mysqldump"
                MYSQL_MYICHK="/usr/local/mysql/bin/myisamchk"
        else
                MYSQL_PATH="/var/lib/mysql"                             # Installed location of mysql [no trailing slash]
                MYSQL_INIT="/etc/init.d/mysqld"                         # Locationof MySQL INIT script
                MYSQL_PID="$MYSQL_PATH/`hostname`.pid"                  # Location of MySQL PID file
                MYSQL_DUMP="/usr/bin/mysqldump"                         # Path to the 'mysqldump' binary
                MYSQL_MYICHK="/usr/bin/myisamchk"                               # Path to the 'myisamchk' binary
        fi
fi


P.S. You can use "Admin Backup/Transfer" for backuping only MySQL.
 
Same issue here - your solution works with latest DirectAdmin and Debian 11. Thank you!
 
Back
Top