|
|
|
|
![]() ![]() |
Feb 2 2006, 03:05 PM
Post
#1
|
|
|
Member [Level 1] ![]() ![]() ![]() ![]() Group: Members Posts: 58 Joined: 31-January 06 Member No.: 17,937 |
i'd like to make an automated database backup as following:
1- i would like to optimize my databse's tables. 2- I would like to remove any existing backup tarfile. 3- I dump the database to a /tmp file. 4- I tar the database dump and then delete it. i wrote the following shell: CODE #!/bin/sh
rm -rf /tmp/mybackup.sql.tgz mysqldump -uroot -pmypass --opt mybackup > /tmp/mybackup.sql.backup cd /tmp/ tar -zcvf mybackup.sql.tgz mybackup.sql.backup rm -rf /tmp/mybackup.sql.backup |
|
|
|
Feb 2 2006, 03:08 PM
Post
#2
|
|
|
Member [Level 1] ![]() ![]() ![]() ![]() Group: Members Posts: 58 Joined: 31-January 06 Member No.: 17,937 |
in my crontab command i wrote:
CODE GET /home/adly3000/tmp/mkbackup.sh |
|
|
|
Feb 3 2006, 07:19 PM
Post
#3
|
|
|
Member [Level 1] ![]() ![]() ![]() ![]() Group: Members Posts: 58 Joined: 31-January 06 Member No.: 17,937 |
please any help would be appricated. help me.
any suggestions!!! |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 7th September 2008 - 03:43 AM |