Posted By: Anonymous
I have a database that is quite large so I want to export it using Command Prompt but I don’t know how to.
I am using WAMP.
First check if your command line recognizes mysql command. If not go to command & type in:
Then use this command to export your database:
mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql
You will then be prompted for the database password.
This exports the database to the path you are currently in, while executing this command
Note: Here are some detailed instructions regarding both import and export