nixCraft
Linux / UNIX Tech Support Forum
Mysql backup hourly
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 |
26-08-2008, 11:46 PM
|
||||
|
||||
Mysql backup hourly
How do I backup mysql database hourly? Can you point to any script or url to automate backup stuff?
__________________
Raj Linux rulz. I have never turned back in my life ; I shall not do so today.. haha 
|
| Sponsored Links | ||
|
|
|
27-08-2008, 09:48 AM
|
||||
|
||||
|
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
|
|
27-08-2008, 02:02 PM
|
||||
|
||||
|
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  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
| Tags |
| backup , mysql , scripting |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| 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 |
All times are GMT +5.5. The time now is 06:58 PM.
