Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MYSQL Backups Expand / Collapse
Author
Message
Posted Thursday, October 16, 2008 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 16, 2008 7:03 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:11 PM
Points: 31,018, Visits: 15,455
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
Posted Thursday, October 16, 2008 9:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,827, Visits: 8,479
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
Posted Saturday, April 14, 2012 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse