LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 10-23-2003, 03:31 PM   #1
WeNdeL
Member
 
Registered: Oct 2002
Location: At my desk...
Distribution: RedHat, Fedora, Ubuntu
Posts: 344

Rep: Reputation: 30
Backing up large MySQL DB's


I have a 13+ GB MySQL databases to back up and was wondering how some of you approach this task.

I was planning on shutting down MySQL, so that all pending transactions get flushed, and then simply copying the physical files to my backup destination.

What is your take on this?
 
Old 10-23-2003, 03:46 PM   #2
hw-tph
Senior Member
 
Registered: Sep 2003
Location: Sweden
Distribution: Debian
Posts: 3,032

Rep: Reputation: 57
I simply use mysqldump. Run a search on these forums, the question has been posted many times. I have posted a script to dump MySQL databases nightly as well.

Håkan
 
Old 10-24-2003, 01:53 PM   #3
WeNdeL
Member
 
Registered: Oct 2002
Location: At my desk...
Distribution: RedHat, Fedora, Ubuntu
Posts: 344

Original Poster
Rep: Reputation: 30
lol... dump a db THAT big?

I am thinking that dumping a 13+ GB db would result in an enormous file...

Thanks for your help but I am looking for alternative methods to using mysqldump...
 
Old 10-24-2003, 05:10 PM   #4
hw-tph
Senior Member
 
Registered: Sep 2003
Location: Sweden
Distribution: Debian
Posts: 3,032

Rep: Reputation: 57
mysqldump creates SQL files - plain ascii text. They can be compressed to a ratio of 1:10 using bzip2.

Håkan
 
Old 10-29-2003, 11:51 AM   #5
WeNdeL
Member
 
Registered: Oct 2002
Location: At my desk...
Distribution: RedHat, Fedora, Ubuntu
Posts: 344

Original Poster
Rep: Reputation: 30
Ya... I can redirect the output of mysqldump to gzip and all but I am just wondering what OTHER ways people were backing up large databases.

Thanks again though...
 
Old 11-29-2003, 10:34 AM   #6
mikeshn
Member
 
Registered: Feb 2002
Distribution: Fedora Core 2
Posts: 586

Rep: Reputation: 30
I've used "mysqldump" for backup the database. I'm just curios if mysqldump is only one way to do it. Is it possible to copy just some files?
 
  


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
Backing up MySQL without the dumping jme Linux - Software 8 05-27-2006 01:01 AM
Backing up mysql without it actually being on c00l Linux - General 1 03-12-2005 02:03 PM
Backing up MySql bifur Linux - Software 8 01-05-2005 08:30 PM
How to copy mysql db's from hardisk to new server? nbier Linux - Software 4 09-01-2004 04:24 PM
Lost all my MySQL DB's, help amp2000 Linux - General 7 04-17-2003 02:25 AM


All times are GMT -5. The time now is 09:50 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration