Welcome to Olinewebmarket

Reply  
Thread: Backup of mySQL database using cron job
  post #1   fajarmulya is offline
Old 11-01-2008, 08:20 PM
fajarmulya
More info Spam Post
Join Date: Nov 2008
Posts:
 14
fajarmulya is on a distinguished road
Default Backup of mySQL database using cron job
You can set the Cron job to generate the database backup for your database.

Here's For Dumping MySQL DB To File In Your Server

1) Cron job syntax to take database backup in simple .sql format is as follows
Quote:
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of the database store file.sql
2) To compress the database backup file in the gz format.
Quote:
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of the database store file.gz
3) To compress the database backup in the bz2 format
Quote:
* * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of the database store file .bz2
- 0 -
Bara.. Wala... Dada
Reply With Quote

masterweb's Avatar
  post #2   masterweb is offline
Old 11-01-2008, 08:22 PM
masterweb
Site Owner
More info Spam Post Send a message via Yahoo to masterweb
Join Date: Aug 2007
Location:
 Italy
Posts:
 4,861
masterweb is an unknown quantity at this point
Default
Reply With Quote
  post #3   fajarmulya is offline
Old 11-01-2008, 08:24 PM
fajarmulya
More info Spam Post
Join Date: Nov 2008
Posts:
 14
fajarmulya is on a distinguished road
Default
Thanks, I still find out how to dump mysql db to email
- 0 -
Bara.. Wala... Dada
Reply With Quote
masterweb's Avatar
  post #4   masterweb is offline
Old 11-02-2008, 06:26 PM
masterweb
Site Owner
More info Spam Post Send a message via Yahoo to masterweb
Join Date: Aug 2007
Location:
 Italy
Posts:
 4,861
masterweb is an unknown quantity at this point
Default
That's exactly what i'm looking for

Quote:
Originally Posted by fajarmulya View Post
Thanks, I still find out how to dump mysql db to email
Reply With Quote
ravi's Avatar
  post #5   ravi is online now
Old 11-02-2008, 07:45 PM
ravi
Administrator
More info Spam Post
Join Date: Aug 2008
Location:
 www.TechHunt.org
Posts:
 1,660
ravi is on a distinguished road
Default
Nice informatie post, thanks @fajarmulya
Reply With Quote
Reply
Forum Jump Top
« Previous Thread | Next Thread »
Tags
backup, cron, database, job, mysql
Bookmarks
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Contact Us - Onlinewebmarket.net - SEO Talk, Domain Sales, Domain Appraisals, Free Tools and more - Archive - Top
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
 
 
All times are GMT. The time now is 12:30 PM.
original style @ vBulletin.com (version 4)