MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Berikut adalah cara backup dan restore [[database]] di [[MySQL]] dan [[MariaDB]] | |||
==Menggunakan MySQLDump== | ==Menggunakan MySQLDump== | ||
===Cara 1=== | ===Cara 1=== | ||
*Backing up a single database | *Backing up a single database | ||
shell> mysqldump | shell> mysqldump DB_Name > Backup-Name.sql | ||
*atau | *atau | ||
mysqldump -u | mysqldump -u DB_Name -p -A > Backup-Name.sql | ||
*Restoring or loading the database | *Restoring or loading the database | ||
shell> mysql DB_Name < Backup-Name.sql | |||
See the [https://bit.ly/30eYG4Y mysqldump] page for detailed syntax and examples. | |||
See the [https:// | |||
===Cara 2=== | ===Cara 2=== | ||
| Line 25: | Line 27: | ||
[[Category:Website]] | [[Category:Website]] | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Database]] | |||
[[Category:Tutorial]] | |||