SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MYSQL Backups


MYSQL Backups

Author
Message
vijayam123
vijayam123
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 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
Attachments
fig1.JPG (48 views, 47.00 KB)
fig.2.JPG (40 views, 44.00 KB)
fig.3.JPG (35 views, 69.00 KB)
fig.4.JPG (41 views, 93.00 KB)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)SSC Guru (149K reputation)

Group: Administrators
Points: 149324 Visits: 19448
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
My Blog: www.voiceofthedba.com
homebrew01
homebrew01
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12654 Visits: 9222
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.



daleto
daleto
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 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
katia.puente
katia.puente
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
Igor Micev
Igor Micev
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10502 Visits: 5157
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,
My blog: www.igormicev.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search