nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Backup Mysql

This is a discussion on Backup Mysql within the Databases servers forums, part of the Mastering Servers category; Hi Can any body help me out. I need to take backup arount 250 databases each in a diff file. ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-03-2009, 02:08 AM
Junior Member
User
 
Join Date: Mar 2009
OS: RedHat
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
benianil is on a distinguished road
Post Backup Mysql

Hi

Can any body help me out.
I need to take backup arount 250 databases each in a diff file.
And then same to restore them all one-by-one or as a few as requirement.

Can anybody let me know a easy way or any tweakable thing.

Regards
anil
Reply With Quote
  #2 (permalink)  
Old 03-03-2009, 10:56 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

You can write a shell script to backup all database and restore them using another shell script.
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #3 (permalink)  
Old 09-03-2009, 09:49 AM
Junior Member
User
 
Join Date: Mar 2009
OS: Debian
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
peterC is on a distinguished road
Default backup

backup by export
Reply With Quote
  #4 (permalink)  
Old 10-03-2009, 10:52 AM
Junior Member
User
 
Join Date: Mar 2009
OS: RedHat
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
benianil is on a distinguished road
Thumbs up mysql backup

Thanks a lot Everybody

How to get it with export i haven't done it . or it means the raw backup.

And can anybody get me a good backup script so that i can backup multiple db's and then can restore them.


Regards
anil beniwal

Be a lamp and let others lit their candles from it.
Reply With Quote
  #5 (permalink)  
Old 10-03-2009, 10:46 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

Try following
  1. Ubuntu Linux Backup MySQL server Shell Script
  2. mysqldump command How to
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #6 (permalink)  
Old 12-03-2009, 07:52 AM
Junior Member
User
 
Join Date: Mar 2009
OS: RedHat
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
benianil is on a distinguished road
Post mysql backup

Thanks Dear

its suiting my needs.


Thanks again to all
Reply With Quote
  #7 (permalink)  
Old 13-03-2009, 01:40 PM
kasimani's Avatar
Senior Member
User
 
Join Date: Jul 2006
Location: India, Delhi
OS: CentOS, RedHat, Fedora, Ubuntu
Posts: 151
Thanks: 3
Thanked 1 Time in 1 Post
Rep Power: 4
kasimani is on a distinguished road
Send a message via Yahoo to kasimani
Default

use this link

Shell script to backup MySql database
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Mysql backup hourly raj Databases servers 2 27-08-2008 02:02 PM
ssh backup particular mysql table / database brothers Databases servers 11 25-10-2007 05:06 PM
MySql FTP server backup script zafar466 Shell scripting 3 25-09-2007 05:43 PM
MySQL Backup Script krisa Shell scripting 1 02-02-2007 11:57 PM
How do I backup MySQL Databases? chiku All about FreeBSD/OpenBSD/NetBSD 2 19-08-2006 07:15 PM


All times are GMT +5.5. The time now is 11:26 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38