In this example I will use database named testiranje, with root password pillow, First of all we need to backup table in database testiranje. We will do this on next way:

root@mysql1:~$ mysql -u root -p -h mysql1 testiranje > /path/to/dump.sql

If you want to do reverse process, you should do next: Before this you should remove database (testiranje) if she exist on system.

root@mysql1:~$ mysql -u root -p
mysql> drop database testiranje;
mysql> quit;
root@mysql1:~$ mysql -u root -p -h mysql1 testiranje < /path/to/dump.sql

If you want to MySQL backup do every day, and not to run it manually, you should make script which will have next content.

[root@mysql1 ]# cat backup.sh
#!/bin/bash
# backup mysql-a
mysqldump -u root -ppillow --all-databases | gzip > /home/sqlbackup/database_`date +%Y-%m-%d`.sql.gz dump databases
find /home/sqlbackup/database_20* -mtime +3 -exec rm -f {} \; delete all files in /home/sqlbackup/database* which are older than 3 day

After this I will add this in root crontab, so it will be start every day in 18.00h.

[root@mysql1 ]# crontab -e
00 18 * * * sh /path/to/backup.sh