[Linux LAMPP] How to Export, Import MySQL Database with Command Line

Export MySQL Database

/opt/lampp/bin/mysqldump -u user -p database_name > database_name.sql

Import/Restore MySQL Database

/opt/lampp/bin/mysql -u user -p database_name < database_name.sql

1. https://stackoverflow.com/questions/29258769/how-to-restore-mysql-database-in-xampp
2. https://blog.devart.com/how-to-restore-mysql-database-from-backup.html