CODE EXAMPLE FOR SQL

dump multiple tables mysql

mysqldump -h<hostname> -u<username> -p 
<databasename>  <table1> <table2> <table3>
--single-transaction --no-create-info > dumpfile.sql