------=_NextPart_000_0078_01C7A6FC.46C7B110
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi guys,
Does InnoDB has, or is going to have a configuration like MSSQL, where i =
can define one file per database?
Jorge
------=_NextPart_000_0078_01C7A6FC.46C7B110--
Hi Jorge,
No, but if you add the innodb_file_per_table option to my.cnf, InnoDB =
stores
each table in its own .ibd file in the same MySQL database directory =
where
the .frm file is created. See Section 14.2.3.1, =93Using Per-Table
Tablespaces=94.
Regards
Geoffroy
-----Message d'origine-----
De=A0: Jorge Bastos [mailto:mysql.jorge@decimal.pt]=20
Envoyé : mardi 5 juin 2007 00:01
À : win32@lists.mysql.com
Objet=A0: InnoDB question
Hi guys,
Does InnoDB has, or is going to have a configuration like MSSQL, where i =
can
define one file per database?
Jorge
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
Hi Geoffroy,
That may be interesting also.
So with that optio, i'll have everything related to one specific database,
on it's directory along with the .frm files from the structure, correct?
I'm looking for this, so that i can "transport" the database as easy as with
MyIsam files.
Suposing i'm using one file per table on innodb, i can transport the
database just copying the database directory, or there's any information
that stay's out of the directory for this database?
Jorge
----- Original Message -----
From: "Geoffroy Cogniaux"
To: "'Jorge Bastos'"
Sent: Tuesday, June 05, 2007 10:25 AM
Subject: RE: InnoDB question
Hi Jorge,
No, but if you add the innodb_file_per_table option to my.cnf, InnoDB stores
each table in its own .ibd file in the same MySQL database directory where
the .frm file is created. See Section 14.2.3.1, "Using Per-Table
Tablespaces".
Regards
Geoffroy
-----Message d'origine-----
De : Jorge Bastos [mailto:mysql.jorge@decimal.pt]
Envoyé : mardi 5 juin 2007 00:01
À : win32@lists.mysql.com
Objet : InnoDB question
Hi guys,
Does InnoDB has, or is going to have a configuration like MSSQL, where i can
define one file per database?
Jorge
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
2007/6/5, Jorge Bastos
> Hi Geoffroy,
>
> That may be interesting also.
> So with that optio, i'll have everything related to one specific database,
> on it's directory along with the .frm files from the structure, correct?
To do so, I have to mix with innodb_data_file_path option
> I'm looking for this, so that i can "transport" the database as easy as with
> MyIsam files.
> Suposing i'm using one file per table on innodb, i can transport the
> database just copying the database directory, or there's any information
> that stay's out of the directory for this database?
All you need to know is described in section 14.2.9. Moving an InnoDB
Database to Another Machine and 14.2.8. Backing Up and Recovering an
InnoDB Database
Have a good read.
Geoffroy
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Cool,
Gonna read,
Thanka
----- Original Message -----
From: "Geoffroy Cogniaux"
To: "Jorge Bastos"
Cc: "Geoffroy Cogniaux"
Sent: Tuesday, June 05, 2007 12:17 PM
Subject: Re: InnoDB question
> 2007/6/5, Jorge Bastos
>> Hi Geoffroy,
>>
>> That may be interesting also.
>> So with that optio, i'll have everything related to one specific
>> database,
>> on it's directory along with the .frm files from the structure, correct?
> To do so, I have to mix with innodb_data_file_path option
>
>> I'm looking for this, so that i can "transport" the database as easy as
>> with
>> MyIsam files.
>> Suposing i'm using one file per table on innodb, i can transport the
>> database just copying the database directory, or there's any information
>> that stay's out of the directory for this database?
> All you need to know is described in section 14.2.9. Moving an InnoDB
> Database to Another Machine and 14.2.8. Backing Up and Recovering an
> InnoDB Database
>
> Have a good read.
>
> Geoffroy
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org