MySQL database import-export from Shell

The control panels provide GUI for import / export databases. However, it is very easy doing the same from shell. Exporting Database mysqldump dbname > exportfile.sql This will export the database to exportfile.sql. You can optionally compress the file to save bandwidth during server to server transfer. Run the following command: gzip exportfile.sql Database Import [...]