468,773 Members | 2,285 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,773 developers. It's quick & easy.

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

GS
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.

May 8 '06 #1
2 1580
On 07 May 2006 in mailing.database.mysql, GS wrote:
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
May 8 '06 #2
>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
May 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jean Hagen | last post: by
6 posts views Thread by Hemant Shah | last post: by
6 posts views Thread by himilecyclist | last post: by
5 posts views Thread by abelbfilho | last post: by
dlite922
3 posts views Thread by dlite922 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.