Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Crontab Automated Database Backup, using crontab to make automated database
adly3000
post 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

(list)

Go to the top of the page
 
+Quote Post
adly3000
post 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

(list)

Go to the top of the page
 
+Quote Post
adly3000
post 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!!!

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · PHP Programming · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Key Logger.(36)
  2. Mysql Database Setup : Setting Up Mysql Database(6)
  3. Making Money Creating Logo's(19)
  4. A Pretty Good Easy Way To Make Some Money(21)
  5. Import From Excel File Into Mysql Database(9)
  6. Connect To Remote Oracle Database With Toad(7)
  7. How Do I Make Gold Fast In Runescape/(126)
  8. How Do I Make A Website(20)
  9. Make Money Online!(17)
  10. Best Ways To Make Money In Runescape(12)
  11. How To Make A Counter Strike 1.6 Dedicated Server(16)
  12. I Need Recipes That Are Easy And Very Quick To Make(25)
  13. Runescape Private Server(69)
  14. How To Get A Girl That Has Refused You(12)
  15. Magical Ball *psi*(10)
  1. What Kind Of Car Do You Have?(26)
  2. Is It Really Possible To Make Any Money Online?(14)
  3. Budding Java Game Developers?(9)
  4. How To Make A Website ?(11)
  5. How To Make Your Own Counter Strike Source Dedicated Server!(34)
  6. Paypal(10)
  7. File Sharing Hosts!(3)
  8. Make Free Money Online(2)
  9. Need Advice On Setting Up Mysql Database.(3)
  10. Make An Extra $50 Or More Per Day!(5)
  11. Ips Installer Database Details [resolved](6)
  12. Mysql Database Not Working(3)
  13. Getting Started With Photoshop!(0)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 7th September 2008 - 03:43 AM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation