Mysql: Create, Import, Export

From Catatan IBM
Revision as of 10:28, 1 June 2022 by Ibm (talk | contribs) (Created page with "==Ubuntu 22.04== ===Create Database=== Login Mysql sudo mysql atau mysql -u root -p CREATE DATABASE nama_db DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; CREATE USER 'nama_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; GRANT ALL ON nama_db.* TO 'nama_user'@'%'; FLUSH PRIVILEGES; EXIT; ===Import Database=== mysql -u nama_user -p nama_db < file_db.sql ===Export Database=== mysqldump -u nama_user -p nama_db > nama_file_db.sql Ke...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Ubuntu 22.04

Create Database

Login Mysql

sudo mysql

atau

mysql -u root -p
CREATE DATABASE nama_db DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'nama_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL ON nama_db.* TO 'nama_user'@'%';
FLUSH PRIVILEGES;
EXIT;


Import Database

mysql -u nama_user -p nama_db < file_db.sql


Export Database

mysqldump -u nama_user -p nama_db > nama_file_db.sql


Keterangan:

Cara mudahnya:

Coba perhatikan command > (pada export MySQL) dan command < (pada import MySQL). Command tersebut adalah simbol instruksi Unix.

> adalah STDOUT sedangkan < adalah STDIN.

Jika ingin melakukan export MySQL, silakan tulis > sebelum file export (dbexport.sql)

Jika ingin melakukan import MySQL, silakan tulis < sebelum file export (dbexport.sql)