MySQL How To Grant Access To ALL Databases For Export and Backup Purposes
GRANT SELECT, LOCK TABLES ON *.* TO yourmysqluser@localhost;
All you need to do a full MySQL dump on all databases is the SELECT and LOCK TABLES privileges. This way you don't have to use the mysql root user. Data could be compromised this way but at least no harm from manipulation, changes or deletion are possible by locking down the privileges to the minimum for a full MySQL dump and backup.........
MySQL HowTo Copy Duplicate a Table for backup purposes
This is a great way to test and experiment without risking your current table, or to make a backup of your current table to avoid corruption or dataloss due to malicious activity eg. deletion etc..
There are two steps and two commands
1.)Copy Table Structure
"cars_backup" is the new table and it will be a copy of the table called "cars"........