HOW TO DUMP ALL DATABASES FOR BACKUP. BACKUP FILE IS SQL COMMANDS TO RECREATE ALL DB'S.

Andrew Deniel

Total Post:5

Points:25
Posted by  Andrew Deniel
MYSQL 
 1291  View(s)
Ratings:
Rate this:
  1. Andrew Deniel

    Post:5

    Points:25
    How to dump all databases for backup. Backup file is sql commands to recreate all db's.

     # [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!