Articles

MySql

How to Export MySQL Database from MySQL 5.5

Use the mysqldump utility to create a backup of your database.

1.  Open windows command prompt on the server you with mysql installed.

2.  Click Start -> Run

3.  Type CMD

4.  Command Prompt opens.

5.  Change the directory to following C:Program FilesMySQLMySQL Server 5.5bin

6.  Type "cd C:Program FilesMySQLMySQL Server 5.5bin" without the quotes to change the directory.

Capture

7.  To Create a dump or backup of your current mysql database Type "mysqldump.exe -e -u[username] -p[password] [databasename] > C:[filename].sql"

Capture1

8.  There is no message indicating command complete.  Cursor will simply move to the next line.

Leave A Comment