diff options
author | luxagraf <sng@luxagraf.net> | 2016-09-02 10:21:50 -0400 |
---|---|---|
committer | luxagraf <sng@luxagraf.net> | 2016-09-02 10:21:50 -0400 |
commit | b4f23fee8108383b96563adb29c4582864d9ca28 (patch) | |
tree | 207c6b4ccd22337b9f6803f8040a0d65b7901bc9 /dump database psql mysql.txt | |
parent | 4b5c9125ed630a1fbea97020a4d639afe0ac9798 (diff) |
added notes on how to dump database and rename drives
Diffstat (limited to 'dump database psql mysql.txt')
-rw-r--r-- | dump database psql mysql.txt | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/dump database psql mysql.txt b/dump database psql mysql.txt new file mode 100644 index 0000000..8c265fd --- /dev/null +++ b/dump database psql mysql.txt @@ -0,0 +1,13 @@ + + +For mysql: + +mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql + +To dump multiple at once, use the databases flag: + +mysqldump -u root -p[root_password] --databases db1 db2 > combined.sql + +Then to restore: + +mysql -u root -p[root_password] [database_name] < dumpfilename.sql |