Exporting MySQL Databases Command Line in Linux

To export a mysql database by linux command line,
for example your database name is my_database, your mysql username is my_username, and your mysql password is my_password, you can use this command :

mysqldump --opt --single-transaction -umy_username -pmy_password my_database > /your/path/here/export.sql

Note: after “-u” and “-p”, there is NO space. 🙂