Thursday, November 17, 2011

Taking MySQL Backup [with mysqldump utility]

mysqldump -u cron -p -h IP astguiclient > FullBackup.sql


[-h :- for host. This is optional if you are creating backup of localhost]


To Restore from the created dump(*.sql) file:-

mysql -u cron -p astguiclient < FullBackup.sql

0 comments:

Post a Comment