TechieDan

You’re stuck in a new place, with no Internet connection and you have no extra additional softwares to install for GUI for mySQL updates and stuffs. Now then suddenly the client asked you to backup his database using the UNIX server. You, as a fresh database administrator suddenly felt lost and don’t know what to do.

If only everyone have learnt the basics of command line prompt, one will not have panic like the above scenario. How to backup your mysql database using command line prompt.

Windows Environment for simplicity

C:\> [MYSQL HOME]\bin\ mysqldump -u[user] -p [databasename] > something.ddl

Yes, a single line and it’s all done.

What does this line meant?

The rest is pretty understandable
Example if I have a username ‘root’ for the database and password ‘abc’ with the database name called db and I wanted to save all the data onto a file name data.ddl, this is what I would write below.

If you have any questions pertaining this issue, do drop a line.

Your Windows OS (Operating System) is down. Dang… and you need a data seriously that you don’t want to bother installing another windows. So how do you do it. Yes, one can copy files using the DOS command.
Let’s say you’re in the command prompt c:\>

Now you wanted to copy multiple folders for backup purposes onto another folder. This is the way one should do

Now let’s say example from folder C:\>techiedan\ and all it’s subdirectories, I want to copy all this into another folder name C:\>blog\techiedan\.

Now you know this, so with this knowledge, you can start writing a schedule or a batch file to run this script at certain period to backup your files.