**************************************************
*
* All Database Backup and Restore 
*
**************************************************



#Backingup all database

mysqldump --user=User_Name --password=Password --all-databases > /path/to/mysql_DUMP_File.sql



**************************************************
*
* Single Table Backup and Restore 
*
**************************************************



#Backuping a single table from a database

mysqldump -u username -p Database_Name Table_Name > /path/to/mysql_DUMP_File.sql

mysqldump --user=User_Name --password=Password Database_Name Table_Name > /path/to/mysql_DUMP_File.sql



#Restoring the single table into another database

mysql -u username -p Database_Name < /path/to/mysql_DUMP_File_Name.sql

mysql --user=User_Name --password=Password Database_Name > /path/to/mysql_DUMP_File.sql