LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 01-22-2007, 04:14 AM   #1
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Rep: Reputation: 30
MySQL :: Auto backup all newly created database


hi guys,

i backup my db running a simple shell script using scp and ssh. But everytime I create a new dB i have to manually create a new entry in the script so as to backup the database.

is there anyway to automate it?
 
Old 01-22-2007, 06:16 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 261Reputation: 261Reputation: 261
Unless you want them all seperate from one another, just use the --all-databases option with mysqldump. Other than that, create a shell script to add whatever database you need to your existing script..
 
Old 01-22-2007, 07:43 PM   #3
Swakoo
Member
 
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Original Poster
Rep: Reputation: 30
ah, i should have thought of that.

a shell script to update the script running the dB backup

but nope, don't wanna backup all my databases onto one .sql file. makes restoration troublesome. since I can't choose to restore a portion of it only, right?
 
Old 01-22-2007, 09:49 PM   #4
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 261Reputation: 261Reputation: 261
Quote:
Originally Posted by Swakoo
but nope, don't wanna backup all my databases onto one .sql file. makes restoration troublesome. since I can't choose to restore a portion of it only, right?
Not that I know of since it's all in one large sql file.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import a mysql database from backup WindowBreaker Slackware 6 03-16-2006 11:08 PM
Auto backup of www and mysql critical Linux - Software 6 08-18-2005 02:13 AM
permissions for newly created files dialbat Linux - General 2 10-04-2004 02:58 PM
Accessing newly created partitions cragwolf Slackware 5 09-13-2004 08:19 PM
I can't login with newly created user r_ibsen Linux - Newbie 2 06-19-2004 08:32 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 08:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration