diff options
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 |