mysql command prompt backup on windows

Open command prompt  by typing cmd in windows run window

locate mysql installation directory if mysql bin path is not added on your system .

for example ,

command_prompt>cd  C:\Program Files\MySQL\MySQL Server 5.0\bin


command_prompt>mysqldump.exe -uROOT -pMYPASSWORD MY_DATABASE > c:\backup.sql

to bakup all the databases  just type the command mysqldump.exe -uROOT -pMYPASSWORD –all-databases > c:\backup.sql







Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top