- Published on
Export Import Database MySQL
- Authors
- Name
- Bryan Wibowo
- X
- @brynwibowo
Pertama buka terminal Ctrl+Alt+T
Export Database
mysqldump --routines -u [username] -p [database-name] > [file-hasil-export.sql]
contohnya
mysqldump --routines -u bryn -p employee_db > employee_db.sql
jika menggunakan user root gunakan sudo
sudo mysqldump --routines -u root -p employee_db > employee_db.sql
Import Database
Sebelum import database, pastikan database baru sudah dibuat
mysql -u [username] -p [database-name] < [file-backup-database.sql]
contohnya
mysql -u bryn -p products_db < backup-products_db.sql
jika menggunakan user root gunakan sudo
sudo mysql -u root -p products_db < backup-products_db.sql