RE: Where are db files ??
1. MySQL storeed data in where you put Mysql server/data/. Format data file.myi, file.myd, file.frm 2. yes rgds, d34dflowers --- Chris Couture [EMAIL PROTECTED] wrote: 1 - Where does mySQL normally store it's data base files? * From what I have seen, it depends on how you install it. You can check in the my.ini file and that will let you know where it is. 2 - Can you change the default directory for a data base? * Yes, you can change this in the my.ini file. 3 - How do you get Linux to search the entire disk for a file? * Do you have any type of shell over linux? They usually offer some sort of search. You might want to look at installing webmin, it makes it easy to control a lot of things on your linux bot via a web based control center. -Original Message- From: tmb [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 7:39 PM To: [EMAIL PROTECTED] Subject: Where are db files ?? HELP ! I'm a newbie to both Linux mySQL. I have a simple mySQL sample data base running on a Red Hat 7.3 machine. It was already setup when I got it. Now I want to find the data base files that mySQL creates so I can back them up... and for my education. I can't seem to get Linux to search the entire hard disk... and I'm really not sure of the data base file names... it comes up in a demo web page. 1 - Where does mySQL normally store it's data base files? 2 - Can you change the default directory for a data base? 3 - How do you get Linux to search the entire disk for a file? Thanks for any help... tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where are db files ??
On Fri, 2002-10-04 at 20:38, tmb wrote: HELP ! I'm a newbie to both Linux mySQL. I have a simple mySQL sample data base running on a Red Hat 7.3 machine. It was already setup when I got it. Now I want to find the data base files that mySQL creates so I can back them up... and for my education. I can't seem to get Linux to search the entire hard disk... and I'm really not sure of the data base file names... it comes up in a demo web page. 1 - Where does mySQL normally store it's data base files? 2 - Can you change the default directory for a data base? 3 - How do you get Linux to search the entire disk for a file? Thanks for any help... tmb look in /var/lib/mysql that's where they are placed usually by rpm. you have to be root to to this I think though. John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Where are db files ??
1 - Where does mySQL normally store it's data base files? * From what I have seen, it depends on how you install it. You can check in the my.ini file and that will let you know where it is. 2 - Can you change the default directory for a data base? * Yes, you can change this in the my.ini file. 3 - How do you get Linux to search the entire disk for a file? * Do you have any type of shell over linux? They usually offer some sort of search. You might want to look at installing webmin, it makes it easy to control a lot of things on your linux bot via a web based control center. -Original Message- From: tmb [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 7:39 PM To: [EMAIL PROTECTED] Subject: Where are db files ?? HELP ! I'm a newbie to both Linux mySQL. I have a simple mySQL sample data base running on a Red Hat 7.3 machine. It was already setup when I got it. Now I want to find the data base files that mySQL creates so I can back them up... and for my education. I can't seem to get Linux to search the entire hard disk... and I'm really not sure of the data base file names... it comes up in a demo web page. 1 - Where does mySQL normally store it's data base files? 2 - Can you change the default directory for a data base? 3 - How do you get Linux to search the entire disk for a file? Thanks for any help... tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Where are db files ??
At 23:46 2002-10-04, Chris Couture wrote: 1 - Where does mySQL normally store it's data base files? * From what I have seen, it depends on how you install it. You can check in the my.ini file and that will let you know where it is. On Linux (which I believe is the one in question) it normally goes in /var/lib/mysql/, but... 2 - Can you change the default directory for a data base? * Yes, you can change this in the my.ini file. Yes 3 - How do you get Linux to search the entire disk for a file? * Do you have any type of shell over linux? They usually offer some sort of search. You might want to look at installing webmin, it makes it easy to control a lot of things on your linux bot via a web based control center. type man find (without the quotes!) and it will tell You more than You wish to know about finding files on Your system. The quick and dirty on finding a file named kkk.ttt is: prompt# find / -name kkk.ttt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php