Linux / UNIX Tech Support Forum
This is a discussion on Mysql backup hourly within the Databases servers forums, part of the Mastering Servers category; How do I backup mysql database hourly? Can you point to any script or url to automate backup stuff?...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
| Sponsored Links | ||
|
|
|
||||
|
I don't have much experience with mysql backup process, but u can simply write a script and call it through cronjob every hour:
Code:
#!/bin/sh date=`date -I` mysqldump --all-databases | gzip > /var/backup/backup-$date.sql.gz For more info, take a look at this page: Backing Up and Restoring Your MySQL Database |
|
||||
|
We have script for backup in our shell scripting directory, try this and let me know:
Shell Script To Dump All MySQL Databases Every Hour To NAS Storage
__________________
Vivek Gite Linux Evangelist |
![]() |
| Tags |
| backup , mysql , scripting |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ssh backup particular mysql table / database | brothers | Databases servers | 11 | 25-10-2007 05:06 PM |
| MySql FTP server backup script | zafar466 | Shell scripting | 3 | 25-09-2007 05:43 PM |
| problem with System + MySQL backup script | massoo | Shell scripting | 1 | 20-08-2007 09:50 PM |
| MySQL Backup Script | krisa | Shell scripting | 1 | 02-02-2007 11:57 PM |
| How do I backup MySQL Databases? | chiku | All about FreeBSD/OpenBSD/NetBSD | 2 | 19-08-2006 07:15 PM |