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. 🙂