A simple command to dump or import large data on a mysql database:
mysql -h localhost -uroot -pAa5sD1 nightcrawler < /home/tux/Desktop/nightcrawler.sql
where:
- -h localhost is for my mysql host or server
- -u root is the mysql user
- -p pAa5sD1 is the user’s password
- nightcrawler is the empty database
- /home/tux/Desktop/nightcrawler.sql is the data to import or usually a back of the database
- < is use to import and > is used to export data from a mysql database
