Re: InnoDB question

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" <geoffroy.cogniaux@outreweb.fr> To: "'Jorge Bastos'" <mysql.jorge@decimal.pt>; <win32@lists.mysql.com> 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,

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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=lists@pantek.com