mysql console backup restore

Question: How to backup the whole database? Answer: Just omit the “table_name” argument. For example, mysqldump -u root -pwordpress > D:\wordpress.sql Question: How to backup all the databases in MySQL? USE –force to continue on errors Answer: Use “–all-databases”. For example, mysqldump -u root -p –all-databases > D:\db.sql linux mysqldump -u admin -p –all-databases > db.sql Restoring Now let’s …