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
Our readers provide the funding for our platform, and we may receive a commission when you make a purchase using the links on our site.
