[SOLVED] Single Command ninjitsu

wh33t · 09-03-2014, 05:39 PM

Hey LQ,

I'm making some scripts that will eventually rsync a whole website to a development server. I've managed to get it to remotely create an sql backup, copy it to the dev server and perform a mysql import. Now what I want to do is truncate two tables which contain transaction data.

So something like

Code:

mysql -u root -pPassword customer_sales | truncate customer_credit_info | truncate customer_information;

How would I go about doing this?

solarisguy · 09-03-2014, 06:39 PM

You're on the right track with pipelining, it's just in the incorrect order.

Here's what you're wanting:

Code:

echo "truncate customer_credit_info; truncate customer_information;" | mysql -u root -pPassword customer_sales

wh33t · 09-03-2014, 10:09 PM

Quote:

Originally Posted by solarisguy

You're on the right track with pipelining, it's just in the incorrect order.

Here's what you're wanting:

Code:

echo "truncate customer_credit_info; truncate customer_information;" | mysql -u root -pPassword customer_sales

Thanks! I really appreciate it.