Re: Where does MySQL store db files?

2002-12-10 Thread Robert Citek
At 05:35 AM 12/10/2002 -0800, tmb wrote: 1 - On a Linux/Apache box, when you create a MySQL db with tables, etc, Where does MySQL store the files associated with the db? If the database is named foobar, then usually in /var/lib/mysql/foobar 2 - On subsiquent db's, does MySQL store those files

Re: Where does MySQL store db files?

2002-12-10 Thread Francisco
Hi, You can check that if the server is running by executing this: Show variables like datadir% from mysql. Bye, --- Robert Citek [EMAIL PROTECTED] wrote: At 05:35 AM 12/10/2002 -0800, tmb wrote: 1 - On a Linux/Apache box, when you create a MySQL db with tables, etc, Where does MySQL

RE: Where does MySQL store db files?

2002-12-10 Thread Adolfo Bello
1 - On a Linux/Apache box, when you create a MySQL db with tables, etc, Where does MySQL store the files associated with the db? Generally, /var/lib/mysql. Check your my.cnf 2 - On subsiquent db's, does MySQL store those files in the same directory or each db in a seperate folder?