MYSQL Backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » MYSQL Backups

MYSQL Backups

Rate Topic

Display Mode

Topic Options

Author

Message

vijayam123

Posted Thursday, October 16, 2008 6:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, October 18, 2008 6:28 AM
Points: 3, Visits: 5

Hello,
Explain How to take backups in My SQL Server
i) Command prompt
ii) MYSQL administrator
I have taken two backups but it don’t know whether it is correct or wrong.
I) I open Administrator Menu fig.1
ii) I am Entering the Server Host is localhost port No.3306 fig.2
iii) Enter password
iv) MySQL administrator window will be displayed. My database was BWTExperss , but how to select and how to take backup that project database has been Explained fig.3
v) I push the BWTExpress database as same as in that fig.4
After clicking the Execute backupnow button
vi) Then the Execute Backup file will be stored in .sql Exception
Please Explain How to create database backup file

Regards
vijayam
vijayam123@live.com

Post Attachments

fig1.JPG (22 views, 47.38 KB)

fig.2.JPG (20 views, 44.53 KB)

fig.3.JPG (19 views, 69.05 KB)

fig.4.JPG (19 views, 93.38 KB)

Post #586881

Steve Jones - SSC Editor

Posted Thursday, October 16, 2008 7:03 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

This isn't a MySQL site, it's for Microsoft SQL Server. I'd suggest you post this somewhere like this http://forums.mysql.com/list.php?35

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #586923

homebrew01

Posted Thursday, October 16, 2008 9:22 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 2,551, Visits: 7,205

I didn't realize you double posted (bad)
Your screen shots look correct. Give the projects a good name. Then test it by restoring your backup to a new database name ... "My_Database_Restore_Test" and verify all your tables and SPs are there.

Post #587082

daleto

Posted Saturday, April 14, 2012 12:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 14, 2012 12:00 PM
Points: 4, Visits: 0

Hi,

You can use the "Data Protector for MySQL using IBM Tivoli Storage Manager".
It is a GUI friendly backup and recovery solution.

Regards Tomas
www.repostor.com

Post #1283662

« Prev Topic | Next Topic »

Permissions