$ 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
