[rt-users] Rt3.0.10: InnoDB problem from a database novice

[Danial Klimkin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings!

Rob W.W. Hooft wrote:
> This morning I decided to give it a try and upgrade the database to
> InnoDB tables. I dumped the database to a 1.4GB sql file, changed
> mysql's configuration, and tried to reimport the (slightly modified) sql
> file. Unfortunately the process stopped after a minute or so with the
> message 'Table "Attachments" is full', and sure enough the location
> where this happens is an INSERT command in the SQL file.

It seems you forgot to specify autoextend flag in innodb_data_file_path
variable. I also recommend to set larger initial ibdata file size, looks
like 2000M will fit you.

See [http://dev.mysql.com/doc/mysql/en/innodb-configuration.html] for
details.

AFAIR it is mentioned somewhere in RT Readme too.


SY, Danial.
- --

Danial Klimkin,
Falk eSolutions AG Russia
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDJr082ce6OqXQ52QRAvtBAKCfSEViW9+U7AOTCSfNPV4Th8rVmQCcCKBl
u5eWbdHiTo8sgaA7Dci5tP0=
=aOLJ
-----END PGP SIGNATURE-----