This blog moved to medium->https://medium.com/@cocoamaemae

Wednesday, November 9, 2016

How to use mysqldump

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

Front End Development Tools

TaskRunner Tool executing multiple tasks by only one execution. Tasks are like CSS preprocessor, Transpire, Module Bundler, etc... e.g. ...