mysqldump -u root -p DBname > /var/tmp/test.com.sql
and check backup file size: cd /var/tmp
mysqldump -P 3306 -h remoteserverdnsname -u dbuser -p DBname > /var/tmp/test.com.sql
mysql -h localhost -P 3306 -u root -p
mysql>show databases;
mysqladmin -u root -p create tempdb
sudo mysql -h localhost -u root -p --max_allowed_packet=1073741824 DBname < /var/tmp/restoreDB.sql
DROP DATABASE dbname;
select database: use dbname;
DROP TABLE table_name ;
mysql localhost -u root -p dbname tableName > /var/tmp/table-name.sql
mysql -h localhost -P 3306 -u root -p -D dbname < /var/tmp/table-name.sql
Backup Database command with password
mysqldump --user=root --password=password dbname > dbname.sql