Export all MySQL databases for backup

http://dev.mysql.com/downloads/utilities/

backup user with the following global rights; SELECT, INDEX, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT, TRIGGER, SHOW VIEW

C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe -u USERNAME -pPASSWORDHERE –all-databases –result-file=LOCATION

Leave a Reply

Your email address will not be published. Required fields are marked *