Every 5 Hr, Automatically Backup my database
- Thread starter Fyruz
- Start date
10 Ways to Automatically & Manually Backup MySQL Database - Noupe Design Blog
I used something like:
How to Backup MySQL Database automatically (for Linux users) | Backup HowTo
Here is special script for Ubuntu:
Ubuntu Linux Backup MySQL server Shell Script
Manual backup:
You must install:
Then execute in Putty:
PASSWORD = your password to mysql (no space between p and password)
dont forget to create /var/db_backup folder and set rights to write
what %Y %d ... mean:
Programming in Lua : 22.1
------------------
On normal 2 core dedic backup of 150MB database should take less then 5 seconds.
I used something like:
How to Backup MySQL Database automatically (for Linux users) | Backup HowTo
Here is special script for Ubuntu:
Ubuntu Linux Backup MySQL server Shell Script
Manual backup:
You must install:
PHP:
apt-get install mysql-client
PHP:
mysqldump -u root -pPASSWORD --all-databases | gzip > /var/db_backup/database_`date '+%m-%d-%Y-%H-%M'`.sql.gzdont forget to create /var/db_backup folder and set rights to write
what %Y %d ... mean:
Programming in Lua : 22.1
------------------
On normal 2 core dedic backup of 150MB database should take less then 5 seconds.
Last edited:
Similar threads
- Question
- Question
- Locked