How to Export MySQL Database via Windows MySQL Command Line Client

Navigate to the following directory in Command Prompt

C:\Program Files\MySQL\MySQL Server 5.0\bin

Run the following command replacing the bold with your details

mysqldump –host=localhost –user=username  –password=password database_name  -r “C:\filename.sql”

 

(No Ratings Yet)