mysql command

dump data without creating table with condition :
mysqldump -t --max_allowed_packet=1G  --host=ip.add -uuser -ppassword database table --where=sys_date>='2012-02-01'  > /tmp/1.sql

dump data & table :

mysqldump --host=www.pembeda.com -uuser -ppassword database table > /tmp/1.sql

dump data & whole database:

mysqldump --host=www.pembeda.com -uuser -ppassword database > /tmp/1.sql


restore :

mysql -uuser -ppassword
mysql> use database_name
mysql> source /tmp/1.sql
mysql> exit;