How to manage SQL dumps in console on Directadmin server

There are some ready tools to manage MySQL dumps in a console on Directadmin server. And here we'd like to say a couple of words about most useful of them.

Creating dumps

Custombuild 2 script has an option to dump all existing MySQL/MariaDB tables. It is suggested to enable it in case if you install/upgrade SQL server with custombuild. And even if you use repos of your OS to install and update database server, you still can use custombuild to create SQL dumps for any needs, and here is how you can do it:

cd /usr/local/directadmin/custombuild/
./build set mysql_backup yes
./build mysql_backup

All the created dumps will be moved into /usr/local/directadmin/custombuild/mysql_backups if it's not redefined in options.conf

Importing dumps

It's not a big deal to import one-two dumps into SQL server manually, but that might take a while to recover/restore a bulk of databases. To make things simpler Directadmin has a nice script: restore_sql_files.sh. In order to utilize the script and import all the databases run the following code:

cd /usr/local/directadmin/custombuild/mysql_backups
wget http://files1.directadmin.com/services/all/mysql/restore_sql_files.sh
chmod 755 restore_sql_files.sh
./restore_sql_files.sh

With this all databases will be restored from dumps for the exception of mysql.sql, performance_schema.sql and information_schema.sql. If you need the script to restore mysql table from the dump as well run the script with with_mysql flag:

./restore_sql_files.sh with_mysql

Using these two options you can do a MySQL migration from one server to another without much issues.

Good luck ;)