MySQL

From QAOP Wiki

Jump to: navigation, search

To backup all databases accessible by a user:

> mysqldump -u <user> --password=<password> --all-databases > filename.sql

or

> mysqldump -u <user> --password=<password> --all-databases --xml > filename.xml

Personal tools