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
mysql -u root -pPassword customer_sales | truncate customer_credit_info | truncate customer_information;
How would I go about doing this?