Hi all, I have several mysql databases that I want to run separate backups of rather than doing an entire database dump into 1 file. The idea is that each database backup would go into its own directory at the end of the backup path i.e. /dbbackups/database1/db-back1 /dbbackups/database 2/db-back2 etc What I have done so far is use the sql "SHOW DATABASES" command to redirect to a dblist text file. What I would like the script to do is go through the file and backup every database in the list. I am already using sed to remove the word database that gets generated by the show command and any databases I don't want backed up from the list so that the result is a list of databases that want backed up. Periodically databases get added. The idea is that the backup will automatically add the new databases without my editing the script based upong the list generated by the "Show Databases" command. I am getting to a level of complexity in scripting that I have not done before. I want the same set of commands run on every db in the list. Thanks.
Dave -- David Tisdell. Music Teacher Browns River Middle School 20 River Road Jericho, VT 05465 [email protected] (e-mail) -- This e-mail may contain information protected under the Family Educational Rights and Privacy Act (FERPA). If this e-mail contains student information and you are not entitled to access such information under FERPA, please notify the sender. Federal regulations require that you destroy this e-mail without reviewing it and you may not forward it to anyone.
