LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 03-15-2012, 08:20 PM   #1
gurnav
LQ Newbie
 
Registered: Oct 2007
Posts: 2

Rep: Reputation: 0
S/w for backup/restore for Mysql


Hi,

We have Mysql Server in our environment used by webservers to run our website. Currently we are evaluating s/w for Backup / Restore of our Databases.

Any recommendation.

Thanks in advance.
 
Old 03-15-2012, 10:07 PM   #2
lisle2011
Member
 
Registered: Mar 2011
Location: Surrey B.C. Canada (Metro Vancouver)
Distribution: Slackware 2.6.33.4-smp
Posts: 179
Blog Entries: 1

Rep: Reputation: 25
Backup for MySQL

With such a dearth of information a person would be a fool to give advice on such flimsy information. Give us more and perhaps we can help you find a solution that fits the need.

Operating System Name and Version.
Web server Software, I could go on.

Abbreviations are not really appreciated, I looked up s/w and came up with the following:

Screaming Weasels;
Sand Wedge;
Smith and Wesson;
Country code for Sweden. There were more examples; but spelled out would always make it easier.
 
Old 03-16-2012, 02:13 AM   #3
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,627

Rep: Reputation: Disabled
Really not much information to suggest you anything. Apart from the platform you are using, you also need to say how important your data is. How frequently do you need to back things up. What kind of backup mechanism are you looking at? Do you have any theoretical backup policies on paper? Share them if you have. And where is your server located? Do you have full physical access to the server? Or is it a cloud server instance?
And yes, please spell your words completely. Short hands are frowned upon here. Makes you look lazy. If you are a sys admin you sure are lazy (thats why we automate things and script the tasks, dont we?)
 
Old 03-16-2012, 08:55 AM   #4
gurnav
LQ Newbie
 
Registered: Oct 2007
Posts: 2

Original Poster
Rep: Reputation: 0
I have mentioned the requirement need a s/w recommendation that can help with backup/restore of DB's we have in MYSQL.

Why do you care what web software we use, my need is not filesystem backup but mysql backup/restore s/w.

Regarding question about how important, why dont you give me options available to me if you know at all.

If this information looks less to you, then why even bother reply at all.

Thanks.
 
Old 03-16-2012, 08:58 AM   #5
gurnav
LQ Newbie
 
Registered: Oct 2007
Posts: 2

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by linuxlover.chaitanya View Post
Really not much information to suggest you anything. Apart from the platform you are using, you also need to say how important your data is. How frequently do you need to back things up. What kind of backup mechanism are you looking at? Do you have any theoretical backup policies on paper? Share them if you have. And where is your server located? Do you have full physical access to the server? Or is it a cloud server instance?
And yes, please spell your words completely. Short hands are frowned upon here. Makes you look lazy. If you are a sys admin you sure are lazy (thats why we automate things and script the tasks, dont we?)
No I am not short cutting and I am not a sysadmin. Stick to the topic, if you have recommendation please provide otherwise excuse the topic is the least I would say.

Regarding your question, no it is not on cloud it is a physical setup.

Thanks.
 
Old 03-16-2012, 09:16 AM   #6
lithos
Senior Member
 
Registered: Jan 2010
Location: SI : 45.9531, 15.4894
Distribution: CentOS, OpenNA/Trustix, testing desktop openSuse 12.1 /Cinnamon/KDE4.8
Posts: 1,144

Rep: Reputation: 217Reputation: 217Reputation: 217
Hi,

I think that LQ forum has much to show in the search bar.
Please use it, because with your attitude you are not going to get any answer or suggestion (but I am wrong most of the time).

Have a nice day.

Regards.

Last edited by lithos; 03-16-2012 at 09:18 AM.
 
Old 03-16-2012, 10:42 AM   #7
gurnav
LQ Newbie
 
Registered: Oct 2007
Posts: 2

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by lithos View Post
Hi,

I think that LQ forum has much to show in the search bar.
Please use it, because with your attitude you are not going to get any answer or suggestion (but I am wrong most of the time).

Have a nice day.

Regards.
Sorry I dont understand your reply, what are you trying to say "LQ forum has much to show in the search bar. Please use it".

Thanks.
 
Old 03-16-2012, 11:43 AM   #8
lithos
Senior Member
 
Registered: Jan 2010
Location: SI : 45.9531, 15.4894
Distribution: CentOS, OpenNA/Trustix, testing desktop openSuse 12.1 /Cinnamon/KDE4.8
Posts: 1,144

Rep: Reputation: 217Reputation: 217Reputation: 217
Nevermind,

I'm not a native English speaker, I meant use search at the top bar.
 
Old 03-17-2012, 03:47 PM   #9
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-19-live-usb/ aix
Posts: 3,840

Rep: Reputation: 590Reputation: 590Reputation: 590Reputation: 590Reputation: 590Reputation: 590
mysqldump/ mysqlimport ?
 
Old 03-17-2012, 06:53 PM   #10
lisle2011
Member
 
Registered: Mar 2011
Location: Surrey B.C. Canada (Metro Vancouver)
Distribution: Slackware 2.6.33.4-smp
Posts: 179
Blog Entries: 1

Rep: Reputation: 25
MySQL Backup solutions

Since you are reluctant to share information about your system I would suggest you dump the database to the hard drive and using cpio make a backup to a tape drive or even a usb hard drive and just a ram stick if the data will fit.

The key to good backups is not the software in particular but the user. You should have a policy in place that permits absolute surety that your backups are working. Statistically more backups fail than succeed and it is more than 50% failure. Sometimes nothing no matter what the software tells you. Occasionally the backup is corrupted and unrestoreable.

The backup procedure I used is as follows:

Each server was backed up to tape, each server dumped the database to disk. I had triple redundancy on the servers (and double redundancy on the air-conditioning). After the tapes were removed and prior to being stored the data dump was burned to a DVD on each server. Labeled and stored. Each tape was then reinserted and a certain file, (it was just a small .bmp) was restored. If the restore was successful the backup was considered successful. Labeled and filed in rotation sequence. It took 1.5 man days to do this every day, but we never lost a bit or a byte and were never caught out even when the building flooded the server room because one of the Air-conditioners used water in it's system and spewed gallons of water all over my servers.

Now this was a Windows 2000 operation and every server did only one function, one for dhcp, one for dns and one for user shares. Three computers served the data but only one worked at a time. The telephone system was on yet another server and the security system on another.

Every cable was marked at each end and service was easy if setup was not. Am I anal, when it comes to corporate data, you bet.

I hope this helps, of course I am ASSUMING (makes an ass out of U and me) your running linux since this is a linux forum.
 
Old 03-17-2012, 07:12 PM   #11
lisle2011
Member
 
Registered: Mar 2011
Location: Surrey B.C. Canada (Metro Vancouver)
Distribution: Slackware 2.6.33.4-smp
Posts: 179
Blog Entries: 1

Rep: Reputation: 25
MySQL Backup

PS
-
To ensure that the cabling would not give us grief I had a specialty company come in and using a time domain reflectometer, test every inch of cable and every distribution point. The cabling passed 100%. And each year a different company would be hired to do an assessment of the IT dept, the hardware and software, the security of the firewall and the work methods in place. We always got an 'A' even on the year they hired two companies to come in and do the same thing twice suspecting a secret relationship might exist between me and IT and one of the contractors.

When I left (under duress, so I retired) within six months the whole thing collapsed because all my policies were 'too expensive' and were abandoned. Working in IT is one of the toughest jobs there is, it is harder than drilling rock and more treacherous than climbing mountains. Just do it right. Make sure the powers that be have given you appropriate funding and appropriate authority, then you will live to a ripe old age like me.

Most corporations like to keep their data and the more private and secret it is the more paranoid they are about losing it.
 
Old 03-17-2012, 07:19 PM   #12
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,211

Rep: Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474Reputation: 2474
Quote:
Originally Posted by gurnav View Post
Sorry I dont understand your reply, what are you trying to say "LQ forum has much to show in the search bar. Please use it".

Thanks.
It means "You're being nasty and rude, so look it up yourself".

Seriously, you provide next to no information, and when you're asked, you respond very rudely. Just putting the question into Google would pull you up more. If you're not the administrator, then why do you CARE what is used? If you ARE, then you should know why you need to ask a clear question.

MySQL has mysqldump and mysqlimport that are very commonly used. Again, you provide no information (HA cluster? Size? can you do cold backups? BCV snapshots on a SAN?), so saying anything past a basic answer is impossible.
 
Old 03-19-2012, 01:50 AM   #13
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,627

Rep: Reputation: Disabled
Quote:
Originally Posted by gurnav View Post
No I am not short cutting and I am not a sysadmin. Stick to the topic, if you have recommendation please provide otherwise excuse the topic is the least I would say.

Regarding your question, no it is not on cloud it is a physical setup.

Thanks.
I see that you do not understand how to ask questions on the online forum where you are not paying anyone to do your job. Everyone here is a volunteer trying to help you out when a consultant would have charged you with MONEY for the same. If you do not want to give information, do not expect any solutions.

And this is a must read for rudes like you.. http://www.catb.org/~esr/faqs/smart-questions.html
 
  


Reply

Tags
backup, database, mysql, restore


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] tar backup & restore in mysql ramecare Linux - Server 4 05-06-2011 11:12 PM
[SOLVED] Mysql Backup & Restore scripts ramecare Linux - Server 3 04-11-2011 05:29 AM
how to restore mysql from /var/lib/mysql files ? zonemikel Linux - Server 2 08-30-2009 12:15 AM
Restore MySQL Dump File But I want it to restore with different names? helptonewbie Linux - Newbie 5 07-08-2009 05:09 AM
restore mysql backup gabsik Linux - Software 3 01-15-2007 12:57 PM


All times are GMT -5. The time now is 08:08 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration