List:General Discussion« Previous MessageNext Message »
From:Francisco Date:December 10 2002 8:51pm
Subject:Re: Where does MySQL store db files?
View as plain text  
Hi,

You can check that if the server is running by
executing this:

Show variables like "datadir%"

from mysql.


Bye,
--- Robert Citek <rwcitek@stripped> 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 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
> >in the same directory or each db in a seperate
> folder?
> 
> New folder, for example /var/lib/mysql/new_db
> 
> Regards,
> - Robert
> 
> 
>
---------------------------------------------------------------------
> 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
> <mysql-thread127108@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-frsgti=yahoo.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Thread
access->mysqlSandeep Murphy4 Dec
  • Re: access->mysqlSteve Yates4 Dec
  • Re: access->mysqlCrercio O. Silva5 Dec
RE: access->mysqlSteve Bradwell4 Dec
RE: access->mysqlDavid Brodbeck4 Dec
RE: access->mysqlIan Zabel4 Dec
  • Re: access->mysqlCarlin Anderson5 Dec
RE: access->mysqlChris Couture5 Dec
RE: access->mysqlSandeep Murphy5 Dec
  • How is DBTools Software?Will Standley7 Dec
    • Re: How is DBTools Software?Michael She7 Dec
      • RE: How is DBTools Software?Chris Mason8 Dec
        • Re: How is DBTools Software?Insanely Great8 Dec
        • RE: How is DBTools Software?Michael She8 Dec
  • Compiling a list of MySQL tools - Please contribute.Will Standley8 Dec
    • Re: Compiling a list of MySQL tools - Please contribute.Paul DuBois8 Dec
  • Can u us a "source code" file to setup a db in MySQL ?TopMailBox9 Dec
    • Re: Can u us a "source code" file to setup a db in MySQL ?Gerald R. Jensen9 Dec
      • How to get MySQL to list current db's ?Will Standley10 Dec
        • Re: How to get MySQL to list current db's ?Sherwin T. Ang10 Dec
        • Re: How to get MySQL to list current db's ?Daniel Kiss10 Dec
        • Re: How to get MySQL to list current db's ?Michael She10 Dec
          • Where does MySQL store db files?tmb10 Dec
            • How to see # of rec's in all tablestmb10 Dec
              • Re: How to see # of rec's in all tablesBenjamin Pflugmann11 Dec
              • re: How to see # of rec's in all tablesVictoria Reznichenko11 Dec
            • Re: Where does MySQL store db files?Robert Citek10 Dec
              • Re: Where does MySQL store db files?Francisco10 Dec
            • RE: Where does MySQL store db files?Adolfo Bello10 Dec
        • RE: How to get MySQL to list current db's ?Brian P. Austin10 Dec
  • Re: access->mysqlGrant Cooper13 Dec