Mysql Dump

For export : mysqldump -u root -p  DBNAME  > mybackUP.sql
For import : mysql -u root -p DBNAME  < mybackUP.sql

mysqldump  -p -h  192.168.1.11 DBName > filename.sql

mysqldump –no-data -u root -p  DBNAME  > mybackUP.sql

mysql -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname  < C:\wamp\bin\mysql\filename.sql

mysqldump -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname >filename.sql

mysqldump -u username -e -q –single-transaction –master-data –databases dbname -p > fulldump.sql

grant replication slave on *.* to ‘user’@’localhost’ identified by ‘pass’;flush privileges;

phpMyAdmin Session Timeout

Increase the phpMyAdmin Session Timeout

 in the root phpMyAdmin directory and add this setting (anywhere):

$cfg['LoginCookieValidity'] = <your_new_timeout>;

Where <your_new_timeout> is some number larger than 1800. Personally, I chose 28800, which is 8 hours.