How to export MySQL schema with data?

December 24, 2023 by Tarik

I`m not sure where are you working, you could export it to file, and send it to your friend.
(root is my localhost username)

mysqldump -u root -p --databases DB_NAME >databasename.sql

PS: mysqldump is actually a executable file present in your /MySQL\MySQL Server 5.6\bin

for example [ on windows ]

C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysqldump.exe

or [ on linux ]

/usr/bin/mysqldump