How to Export/Import database from command line
On this post, I will tell you how to export/import MySQL database using command line.
I share this because there’re many phpmyadmin injection, and probably your database server doesn’t have public IP
Export
mysqldump -u DBUSER -pPASSDB DBNAME > DBNAME.sql
Import
cat /home/txxxx/FILENAMEDB.sql | mysql -uUSERDB -pPASSDB NAMEDB
or
mysql -uUSERDB -pPASSDB NAMEDB < /home/txxxxx/FILENAMEDB.sql