Sử dụng mysql bằng command line (ok) export

Xem trạng thái xampp: $sudo /opt/lampp/lampp status

$sudo apt install mysql-client-core-5.7

$sudo apt install mariadb-client-core-10.1

just start mysql using the command

example: $sudo /opt/lampp/lampp startmysql

and find path of mysql , it will be placed in bin directory of lampp, then login

example: $/opt/lampp/bin/mysql -u root

Chú ý: Nếu root có mật khẩu thì ta thêm tham số

example: $/opt/lampp/bin/mysql -u root -p

$/opt/lampp/bin/mysql -u root
MariaDB [(none)]>show databases;
MariaDB [(none)]> use mysql;
MariaDB [mysql]> show tables;
Tạo bảng :)))
MariaDB [mysql]>CREATE DATABASE tintuc_shopdunk;
$/opt/lampp/bin/mysql -u root -p tintuc_shopdunk < tintuc.backup.sql
  Tuong tự:
  Export database
  /opt/lampp/bin/mysqldump --user=root --password="" bitnami_wordpress > bitnami_wordpress.sql
  Export all databases
  /opt/lampp/bin/mysqldump --user=root --password="" --all-databases  > all.sql

Với Windows