This command will help you backup a specified table using mysql command.. This would be useful if you have a large database and have few tables only frequently modified.
How to dump particular tables
#mysqldump database_name tables_name -r outout.sql -uusername -h192.168.10.15 -ppass
sometimes you may required to restore the database frequently from the back up using script which is automated. I found source command will not be worked while we using mysql ” -e ” parameter
eg : mysql -uuser -hhost -ppassword -e “use slocal; call import_twom_data1(0,12000);”
So the best way to use following command during the automated script execution time to restore the database.
$mysql database name -uusername -ppass <mysqldump.sql
$mysql slocal -udbslocal -ppass < csv_import.sql