From a2128d89bc501071ef1abc83e011f0aa02eca54e Mon Sep 17 00:00:00 2001 From: luxagraf Date: Sun, 22 Dec 2019 11:50:57 -0500 Subject: brought notes up-to-date --- tech/dump database psql mysql.txt | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 tech/dump database psql mysql.txt (limited to 'tech/dump database psql mysql.txt') diff --git a/tech/dump database psql mysql.txt b/tech/dump database psql mysql.txt new file mode 100644 index 0000000..8c265fd --- /dev/null +++ b/tech/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 -- cgit v1.2.3