Menggunakan MySQL / Mariadb dengan Sintax Command

$ mysql -h 192.168.1.1 -u user -ppassword akademi_db < akademi_db.sql        

Import CSV to MySQL        

MariaDB [(none)]> load data infile ’kamus.csv’ into table eng_ind fields terminated by ’,’;        

Export MySQL to CSV        

$ mysql -uroot -h ip_server -ppasword nama_database -B -e "select * from        

\`nama_tabel\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > sms.csv        

Contoh:        

$ mysql -uroot -h localhost -pb1r0j4t3nk Jateng -B -e "select * from        

\`T_SMS_LOGEVENT\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > sms.csv        

Backup MySQL        

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql        

Contoh:        

$ mysqldump -u root -ptmppassword kampusdb > kampusdb.sql        

Restore MySQL ------------- $ mysql -u root -p[root_password] [database_name] < dumpfilename.sql        

Contoh:        

$ mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql        

Powered by:        

LATEX