MySQL: Import and Export Databases in MySQL or MariaDB

From Catatan IBM
Revision as of 07:54, 18 January 2023 by Ibm (talk | contribs) (Created page with "===Export=== mysqldump -u username -p database_name > data-dump.sql ===Import=== mysql -u username -p new_database < data-dump.sql")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Export

mysqldump -u username -p database_name > data-dump.sql

Import

mysql -u username -p new_database < data-dump.sql