LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-21-2016, 02:13 AM   #1
changlee
LQ Newbie
 
Registered: May 2011
Location: Piraeus Greece
Posts: 6

Rep: Reputation: 0
Suggest best back up method


Hello Linuxers,
I am using a casual CentOS dedicated server and I host 20 accounts. What is the best method to restore accounts files and mySql back up?

Thanks!
 
Old 06-21-2016, 03:13 AM   #2
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 8,505

Rep: Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434
noone can tell you what is the best process for you, because it depends on a lot of things (like amount of data to backup, the frequency of backups, ...)
About mysql: please check the official page to find suggested methods.
 
1 members found this post helpful.
Old 06-21-2016, 03:14 AM   #3
Keruskerfuerst
Senior Member
 
Registered: Oct 2005
Distribution: SLES 12
Posts: 1,641

Rep: Reputation: 111Reputation: 111
Depending on the backup volume.
1. DVD-RW
2. BD-RE
3. USB Stick
 
1 members found this post helpful.
Old 06-21-2016, 03:47 AM   #4
jamison20000e
Senior Member
 
Registered: Nov 2005
Location: ...uncanny valley... infinity\1975; (randomly born:) Milwaukee, WI, US, Earth, end border$! ◣◢┌∩┐ Fe26-E,e...
Distribution: any GPL that works well on my cheapest; has been KDE or CLI but open... http://goo.gl/NqgqJx &c ;-)
Posts: 3,288
Blog Entries: 2

Rep: Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929
+1 on as many as you can, "formats"$ too..!
 
Old 06-21-2016, 05:15 AM   #5
JJJCR
Senior Member
 
Registered: Apr 2010
Posts: 1,122

Rep: Reputation: 190Reputation: 190
Cool

Quote:
Originally Posted by pan64 View Post
noone can tell you what is the best process for you, because it depends on a lot of things (like amount of data to backup, the frequency of backups, ...)
About mysql: please check the official page to find suggested methods.
Good insight.

- Amount of data to backup (capacity of your data)
- Frequency of backup (Daily, Weekly [Differential, Full])
- Data retention (how long you want to keep your backup, 1 month then replace, 1 year then replace)
If it is accounting data consult your legal counsel what is the government law about keeping your the data

You might also need to consider, restoration process. There's no point of thinking how to back up if restoring data is not being considered.

Consider this also: Tape backup, USB backup, Cloud backup, Offsite backup (if in case the whole server room vanish like a water vapor)

Commands to backup that is available on most Distro: Rsync, Tar, Dd (data destroyer), Cp (of course) etc..

Good luck!!
 
Old 06-21-2016, 08:35 AM   #6
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,667
Blog Entries: 10

Rep: Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076
http://rsync.net/resources/howto/rsync.html
 
Old 07-20-2016, 06:01 AM   #7
changlee
LQ Newbie
 
Registered: May 2011
Location: Piraeus Greece
Posts: 6

Original Poster
Rep: Reputation: 0
I am asking about the Software. Not the hardware. Eg, I am backing up every month Each account files and mysql. I save them at SSD external drive and at a cloud service. Is that OK?

Thank you for your responses.
 
Old 07-20-2016, 11:11 AM   #8
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,325

Rep: Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881
Quote:
Originally Posted by changlee View Post
I am asking about the Software. Not the hardware. Eg, I am backing up every month Each account files and mysql. I save them at SSD external drive and at a cloud service. Is that OK?

Thank you for your responses.
AGAIN: No one can tell you what is 'best' for you. There are MANY programs to do full/incremental backups, and you've said nothing about your requirements (retention, versioning, restore time, online/nearline/offline storage, etc.)

Short answer: if you're comfortable with what you have, and can get to your backups when needed, you're done.
Long answer: if you don't THINK you're covered, you need to actually test your backups, and make SURE things work the way you want them to, and address problems as they come up.
 
1 members found this post helpful.
Old 07-20-2016, 11:50 AM   #9
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,667
Blog Entries: 10

Rep: Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076Reputation: 2076
Quote:
Originally Posted by changlee View Post
I save them at SSD external drive and at a cloud service. Is that OK?
It is if you encrypt locally,before sending to any "cloud service".
</opinion>
 
Old 07-20-2016, 04:32 PM   #10
Hasek39
Member
 
Registered: Jul 2015
Location: Moscow, Russia
Distribution: Slackware
Posts: 93

Rep: Reputation: Disabled
As for me I prefer classic way of using tar command with something like
Code:
tar -cvpf /backup_directory/backup_file.tar --directory=/ --exclude=directories/that/should/be/excluded .
it took a few hours on desktop but may be longer on a big server. To restore from backup you just need to extract it to the file tree.

If you need more information check man tar or read this entry.
 
Old 07-29-2016, 01:59 AM   #11
changlee
LQ Newbie
 
Registered: May 2011
Location: Piraeus Greece
Posts: 6

Original Poster
Rep: Reputation: 0
Thank you so much for your responses. I would like to know what do you prefer/use for your back up methods :-)
 
Old 07-29-2016, 02:38 AM   #12
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 8,505

Rep: Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434Reputation: 2434
I have two HDDs, one of them in my PC, the other one is a WD My Passport Wireless Portable External Hard Drive, and for example pictures are also saved on flickr.
synced by hand, on demand
 
Old 07-29-2016, 05:46 AM   #13
JJJCR
Senior Member
 
Registered: Apr 2010
Posts: 1,122

Rep: Reputation: 190Reputation: 190
Exclamation

Quote:
Originally Posted by changlee View Post
Thank you so much for your responses. I would like to know what do you prefer/use for your back up methods :-)
Backup to another server, back up to USB and bring offsite, if luxury allows I would prefer another backup to NAS. A total of 3 backups.
 
Old 08-03-2016, 04:45 AM   #14
changlee
LQ Newbie
 
Registered: May 2011
Location: Piraeus Greece
Posts: 6

Original Poster
Rep: Reputation: 0
What is NAS folk?
 
Old 08-03-2016, 08:01 AM   #15
jamison20000e
Senior Member
 
Registered: Nov 2005
Location: ...uncanny valley... infinity\1975; (randomly born:) Milwaukee, WI, US, Earth, end border$! ◣◢┌∩┐ Fe26-E,e...
Distribution: any GPL that works well on my cheapest; has been KDE or CLI but open... http://goo.gl/NqgqJx &c ;-)
Posts: 3,288
Blog Entries: 2

Rep: Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929
Likely network-attached storage (NAS)

I use email as well, there maybe better one for storage or just services designed for it like DropBox &c...

searching: list of backup methods
brings in some good thoughts.
 
  


Reply


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
how to install logitech quick cam express (plz suggest easiest method z i am a newbie kcbtux Linux - Newbie 4 09-14-2011 02:41 AM
[SOLVED] [Perl] OOP Accessor Method for Array Attributes and Append Method brianmcgee Programming 1 10-18-2010 12:05 PM
Go back method in Grub? David2010 Linux - Software 8 08-10-2010 04:07 PM
LXer: Id suggest Linux - but.. - Id suggest you get a clue, but.. LXer Syndicated Linux News 0 12-10-2007 02:50 PM
Call back method for shared library arunka Programming 2 02-25-2006 12:43 PM


All times are GMT -5. The time now is 11:57 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration