Archive

Posts Tagged ‘mysql query browser’

Backup And Restore MySql Database Using MySql Administrator

March 16, 2010 2 comments

Here in this article we will learn how to take backup and restore database in mysql using MySql Administrator Utility.

Steps:

1) Open  MySql Administrator

2) Select Backup in the Left hand side menu

3) Click on “New Project” Button shown at the bottom in the right hand side

4) select your database from the list shown and click “>” arrow button

5) Click on “Execute Backup Now

and save as file dialog will open and save the file accordingly.

To Restore the database, follow the following steps

1) Open MySql Administrator

2) Click on “Restore

3) Click on “Open Backup File

4) Browse file and specify Target Schema click on new schema or specify existing database

5) Click on “Start Restore

Another way of Restoring Db is, follow the below steps:

1) Open MySql Query Browser

2) Click on File menu -> open script – > browse to the backup file

3) Click on Execute

Advertisements

Tutorial using MySQL with Asp.Net

September 10, 2009 Leave a comment

If you want to use MySQL Database with Asp.net, then here is a link which explains:

http://www.15seconds.com/issue/050407.htm

  • Download of MySQL Server
  • MySQL Administrator
  • MySQL Query Browser
  • .Net Connector (For Asp.net Integration)

The above link has explained in detail, with proper screenshots, from where to download installers, how to install with step by step screens and explanations, and also how to create sample asp.net application with MySQL database, create MySQL database (schema), create MySQL Table, Insert Data, and populate that data in asp.net gridview.