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 (32 views, 47.38 KB)
fig.2.JPG (25 views, 44.53 KB)
fig.3.JPG (24 views, 69.05 KB)
fig.4.JPG (25 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 @ 11:02 AM
Points: 31,664, Visits: 16,113
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: Tuesday, February 24, 2015 2:31 PM
Points: 2,851, Visits: 8,630
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
Posted Wednesday, February 4, 2015 12:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 4, 2015 12:31 AM
Points: 3, Visits: 6
TRY using "Ahsay software" i am using it from long time and quite impressed with its working. so if you want to know more about the "Ahsay software" it actually gives backup and restoring too si i am leaving a link just go through the link and go through it.http://www.ahsay.com/jsp/en/home/index.jsp?pageContentKey=ahsay_products_overview
Post #1657344
Posted Wednesday, February 4, 2015 1:14 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 3,217, Visits: 3,392
If the backups are small (let's say up to couple of GBs) than you can proceed with a .sql file. The MySQL Workbench offers that via Server->Enterprise backup manager.
But for bigger databases you'll have performance issues while restoring, ... and there are other ways.
So as some proposed above, you'd better visit MySQL sites where you'll be given more precise answers.




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1657349
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse