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

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.

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

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

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

>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