MySQL Backup and Restore Commands

To Take Backup For Local MySQL Server:

1. Login DB Server.

mysqldump -u username -p'password' --add-drop-table --routines --events --single_transaction exampledb > /home/sysuser/db_backups/26022015/exampledb.sql;

Here:
--routines  - used for Stored Procedure
-- events    - For Events & Transaction
exampledb  - db name


For Normal Backup If Stored Procedure or Events not in DB then try with below commands :

mysqldump -u username -p'password' exampledb > /home/sysuser/db_backups/26022015/exampledb.sql;



To take DB Backup For Remote Server:

mysqldump -h '192.168.100.101' -u username -p'password' --add-drop-table --routines --events --single_transaction exampledb > /home/sysuser/db_backups/26022015/exampledb.sql;


Here :
192.168.100.101   -  This one is remote db server ip


For DB Restore :

mysql -u username -p'password'  exampledb < /home/sysuser/db_backups/26022015/exampledb.sql;