471,114 Members | 1,359 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,114 software developers and data experts.

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 1676
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.