What's mysqldump?
It dumps Mysql or MariaDB contents. Basically it is used for backup.
Basic Usage
# Extract database definition
mysqldump -h <host> -u <user> -p <password> -d <database name>
# Extract table definition
mysqldump -h <host> -u <user> -p <password> -t <database name> <table name>
# Specify where condition when extracting table
mysqldump -h <host> -u <user> -p <password> -t <database name> <table name> --where="condition"
No comments:
Post a Comment