Create Backup File in MySql in Windows

To create a Backup File

Create a database named mydb in mysql…

ms1

Create a table named Student in it and put some records…

ms2

Now to create a backup file,

  • Open c:/
  • Open Program Files
  • Open MySQL
  • Open MySQL Server 5.5 ( version depends that you have installed)
  • Open Bin

Now you will get the following path

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

Now open command prompt, i.e. cmd and write following commands

1. ms3

 it will get you to c:\

2. ms5

 it will let you to access mysqldump command

3.

ms7

in this command -u is for user , -p is for password

user is root and i have used password 123, remember if you dont have used password in you database write following command instead of this…

mysqldump -u root mydb > temp.sql

now backup file is ready in C:\Program Files\MySQL\MySQL Server 5.5\bin .

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s