DirectAdmin Auto Database Backup

[Solidjeuh]

Hello,

Is there a command that I can use to auto backup all my databases everyday of every week?
Some kind of cronejob..
The backups needs to be send to an external server.
Or if that is not working, it should be send to a folder on the current server.

Kind regards,
Andy

 

[Harry Tang]

You can use DA backup function, only check backup database, you can config to send bk to ext server as well.

 

[zEitEr]

Hello,

If you need only MySQL tables dumped you can run this:

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

with this you will have dumps created in /usr/local/directadmin/custombuild/mysql_backups/

but you'd better use Directadmin level backup and configure it to run with cron and backup only MySQL data.

 

[Solidjeuh]

And what command do I need to enter for the cronejob?
I created a folder, backups need to save there: /home/solidjeuh/dbbackups/

 

[Fred.]

This is what I have been using for years https://sourceforge.net/projects/automysqlbackup/

 

[zEitEr]

In Directadmin at admin level you have nice Web-interface where you choose what and when to backup and where to store.

And what command do I need to enter for the cronejob?
I created a folder, backups need to save there: /home/solidjeuh/dbbackups/

 

[Solidjeuh]

I found this:
/usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path/backup.sql
Seem to work fine for the moment ..