Menggunakan MySQL / Mariadb dengan Sintax Command

Query OK, 4 rows affected (0.61 sec)        

Records: 4  Duplicates: 0  Warnings: 0        

•Menambah Primary Key        

MariaDB [kampusdb]> alter table mahasiswa add primary key  (nim) ;        

Query OK, 0 rows affected (0.74 sec)        

Records: 0  Duplicates: 0  Warnings: 0        

Export / Import & Backup MySQL / MariaDB        

Export Database Kamus ke File DBF        

mysql –host=... –user=... –password=... -vvf MySQL database name < dump file name        

Contoh:        

$ mysql -h localhost -u kamus -ppasword -vvf kamusdb < kamus.dbf        

Update Database        

$ mysql -h [alamat_IP] -u [nama_user] -p[password] nama_database < nama_database.sql        

Contoh: