LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Multiple mysqldump lines (https://www.linuxquestions.org/questions/linux-software-2/multiple-mysqldump-lines-861709/)

immortaltechnique 02-09-2011 07:12 PM

Multiple mysqldump lines
 
Hi all.
I have a text file with about 300 mysqldump lines of the following nature
Code:

mysqldump --single-transaction --opt -C -hlocalhost -uanony
-p customers Details > customers_10Feb2011/customers.10-Feb-2011.Details.sql

My challenge is i dont want to run one line at a time and instead i want to write a script that simply reads from the above text file and runs the dumps

Question, does mysqldump allow multiple instances of it to be called? and how would the above idea work and is there an easier way to automate the above

goossen 02-10-2011 10:14 AM

It can be done in a shell script, you need to define your variables first, to understand better your needs.


All times are GMT -5. The time now is 11:18 PM.