Exporting from MySQL
The best tool for exporting a MySQL database to a text file is mysqldump.
To use mysqldump, you will need to know the login credentials of an appropriate MySQL user that has the necessary privileges to export the database .
$ mysqldump -u my_username -p database_name > output_file_path
mysqldump -u root -p corp > /home/jandj/Pictures/db_dump.sql