To back up MySQL, log on as the root user and run:
mysqldump –opt -u user -p dbname > {path}/backup.sql
To restore the database run:
mysql -u user -p dbname < {path}/backup.sql
Paul AndersonPaul is an Avid Tech Geek who Loves writing, Cycling and All Things Linux! He comes from a Background of Windows Administration along with Ubuntu/Centos Server administration. Paul holds industry wide certifications include CompTIA & Microsoft Accredited certifications.
