Dear Will, > When I create a new db using MySQL... > What files does MySQL create?
CREATE DATABASE mynewone will create a directory called "mynewone" in the MySQL datadir. You can check where this is by issuing "SHOW VARIABLES LIKE 'datadir'" on the SQL command line. HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Will Standley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 6:01 AM Subject: What are basic db files MySQL creates? > Question: > > When I create a new db using MySQL... > > What files does MySQL create? > > I'm asking because a MySQL sample db was created on the machine I am using > and they don't seem to be where I think they should be... and I want to > search for them... > > (I looked in root/var/lib/mysql/ and didn't see them... or at lease I did > not recognize them.) > > Thanks, > > Will > > > --------------------------------------------------------------------- > 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
