brought notes up-to-date

1 files changed, 13 insertions, 0 deletions

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