dbTalk Databases Forums  

Which is the right Directory to backup MySQL database on Linux Opearing system?

mailing.database.mysql mailing.database.mysql


Discuss Which is the right Directory to backup MySQL database on Linux Opearing system? in the mailing.database.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GS
 
Posts: n/a

Default Which is the right Directory to backup MySQL database on Linux Opearing system? - 05-07-2006 , 07:10 PM






Implemented web application using MySQL to maintain inventory of the
office PC's/laptops/Routers/hubs and other stuff, here we are using
MySQL as back-end Database on Linux Operating system. I need to backp
all these Inventory database into CD/Tape/Floppy, which is the right
directory (MySQL database) to backup (incase if the current MySQL
server crashes, then I should be able keep copy of my inventory),
please let me know, appreciated. We are using 4.0.25 MySQL version.

GS.


Reply With Quote
  #2  
Old   
Joe Makowiec
 
Posts: n/a

Default Re: Which is the right Directory to backup MySQL database on Linux Opearing system? - 05-07-2006 , 07:46 PM






On 07 May 2006 in mailing.database.mysql, GS wrote:

Quote:
Implemented web application using MySQL to maintain inventory of the
office PC's/laptops/Routers/hubs and other stuff, here we are using
MySQL as back-end Database on Linux Operating system. I need to backp
all these Inventory database into CD/Tape/Floppy, which is the right
directory (MySQL database) to backup (incase if the current MySQL
server crashes, then I should be able keep copy of my inventory),
please let me know, appreciated. We are using 4.0.25 MySQL version.
Your data directory is specified in your mysql configuration file; on my
FC4 system, it's my.ini Once you have the directory, you should be able
to back up. You probably want to flush and lock tables, or even shut
down MySQL, when you back up.

http://dev.mysql.com/doc/refman/5.0/en/backup.html

--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe


Reply With Quote
  #3  
Old   
AT
 
Posts: n/a

Default Re: Which is the right Directory to backup MySQL database on Linux Opearing system? - 05-07-2006 , 08:35 PM



Quote:
Implemented web application using MySQL to maintain inventory of the
office PC's/laptops/Routers/hubs and other stuff, here we are using
MySQL as back-end Database on Linux Operating system. I need to backp
all these Inventory database into CD/Tape/Floppy, which is the right
directory (MySQL database) to backup (incase if the current MySQL
server crashes, then I should be able keep copy of my inventory),
please let me know, appreciated. We are using 4.0.25 MySQL version.
mysqldump dumps databases, not directories.

This is the tool you should be using to dump databases. (Then copy
the resulting file(s) to CD/Tape/Floppy). Copying a directory may
not work if the new MySQL is of a different version or on a different
architecture.

Gordon L. Burditt


Reply With Quote
Reply




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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.