Re: Creating Mysql DB with PHP

"MS" <nospamplaesegr8t_ukuk@xxxxxxxxxxx> wrote in message
news:d81hfj$2hm$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> It occurs to me that you could include the database files with the
> package,
>> and have the configuration script copy them into the correct directory.
> This
>> is much faster than running it as queries, and you won't face the
> drawbacks
>> with copying the database a row at a time (or running it from a dump)
>>
>
> I would try this... But can you tell me where the database files are ?
>
> Alex.
>

Typically, they would be under the "data" directory under MySQL.

For example - I have a windows system running MySQL - the program is in
C:\Program Files\MySQL\MySQL Server 4.1\

Let's say I wanted a database called "myDB"

The data would be found in C:\Program Files\MySQL\MySQL Server
4.1\data\myDB\ - Typically, there would be 3 files for each table on the
database: with the extensions .frm, .MYI, and .MYD - (NOTE: Some of my
databases only have a .frm, and a single db.opt file)

Basically, just copy the contents of that database file to the new database
file. It would be preferable to have the system create the database folder
(so don't just copy the folder - copy it's contents), as mentioned before
using mysql_create_db().


.

Relevant Pages

  • Re: Problem of processors spikeing alot
    ... Look at switching to Enterprise Edition and getting and using more memory. ... Nevertheless, taking a really close look at the database design, index usage ... separated from the database files. ... daryla wrote:> Setup: Windows server 2003 ...
    (microsoft.public.sqlserver.server)
  • Re: ACT .dbf files not syncronized
    ... It sounds like sync is choking on database files. ... If all users should be sharing one database that database should be on the server and each user's ACT should look there for the database. ...
    (microsoft.public.windows.server.sbs)
  • Re: Recovering Information Store after complete system crash
    ... "Copy Exchange database files from the current path location to the ... path location for a different logical database, storage group, or ... associated with the logical database "Mailbox Store (Server A)" in ...
    (microsoft.public.exchange.admin)
  • Re: SQL Desktop Edition
    ... You need to make the database files available in SLQ server. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • RE: can I export a database from query analyzer??
    ... Backup the database and then restore it on the other server. ... Refer to SQL Server Books Online for syntax and examples ... If you have a copy of the database files then you can use sp_attach_db to attach the database files on another server. ...
    (microsoft.public.sqlserver.clustering)