MySQL Forums
Forum List  »  MySQL Administrator

MySQL GUI Tool - BACKUP using command line
Posted by: Manhao Chen
Date: October 19, 2009 10:13PM

hi all,

after losing all my internal forum data (likely not a lot), i figured its time to have a schedule backup

but first i want to make sure i can run a backup using command line and then i can just make it a .bat file and schedule it after

so anyone knows how to write the line so that it backs up my database say my db name is... happy_db and save to... C:\happy_db_backup\

my database is on another machine say...
username: root
password: somepassword

i'm after the same way as how the GUI tool backs up so i can just restore the file

i'm using windows xp/vista 32bit


Edited 3 time(s). Last edit at 10/19/2009 10:19PM by Manhao Chen.

Options: ReplyQuote

Written By
MySQL GUI Tool - BACKUP using command line
October 19, 2009 10:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.