MariaDB:Bakup and Restore: Difference between revisions
Created page with "==Menggunakan MySQLDump== *Backing up a single database shell> mysqldump db_name > backup-file.sql *Restoring or loading the database shell> mysql db_name < backup-file.sq..." |
No edit summary |
||
| Line 3: | Line 3: | ||
shell> mysqldump db_name > backup-file.sql | shell> mysqldump db_name > backup-file.sql | ||
*atau | |||
mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup_Name.sql</span> | |||
*Restoring or loading the database | *Restoring or loading the database | ||
Revision as of 05:48, 5 November 2021
Menggunakan MySQLDump
- Backing up a single database
shell> mysqldump db_name > backup-file.sql
- atau
mysqldump -u DB_Name -p -A > Backup_Name.sql
- Restoring or loading the database
shell> mysql db_name < backup-file.sql
See the mysqldump page for detailed syntax and examples.