Import database
mysql -u DB_USERNAME -p DB_NAME < /PATH/OF/DB/softsql.sql
Export database
mysqldump -u DB_USERNAME -p DB_NAME > /PATH/TO/DB/softsql.sql
Dump error
- Error Access denied need PROCESS privilege [MySQL]
- mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
Solusion
Add ‘–no-tablespaces‘ option to the command as shown below:
mysqldump -u DB_USERNAME -p DB_NAME --no-tablespaces > /PATH/TO/DB/softsql.sql