Jump to content

MariaDB:Bakup and Restore: Difference between revisions

From Wiki
← Older editNewer edit →
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
Line 2: Line 2:
===Cara 1===
===Cara 1===
*Backing up a single database
*Backing up a single database
  {{Terminal|shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span>}}
  {{Terminal|shell> mysqldump DB_Name > Backup-Name.sql}}


*atau
*atau
  {{Terminal|mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup-Name.sql</span>}}
  {{Terminal|mysqldump -u DB_Name -p -A > Backup-Name.sql}}


*Restoring or loading the database
*Restoring or loading the database
  {{Terminal|shell> mysql <span style="color:#ff0000">DB_Name</span> < <span style="color:#ff0000">Backup-Name.sql</span>}}
  {{Terminal|shell> mysql DB_Name < Backup-Name.sql}}


See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples.
See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples.

Revision as of 16:21, 8 November 2021

Menggunakan MySQLDump

Cara 1

  • Backing up a single database
Template:Terminal
  • atau
Template:Terminal
  • Restoring or loading the database
Template:Terminal

See the mysqldump page for detailed syntax and examples.

Cara 2

  • BackUp
Template:Terminal
  • Resotore
Template:Terminal

Source

Retrieved from "https://kangtain.com/wiki/index.php?title=MariaDB:Bakup_and_Restore&oldid=965"