Thanks Luciano. It works.
Iago. -----Mensaje original----- De: Luciano Barcaro [mailto:[EMAIL PROTECTED]] Enviado el: martes 28 de mayo de 2002 19:21 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Error 1114 when import mysqldump in InnoDB table Hi, the internal space for innodb is full... create new extends (add another ibdata file and restart the mysql) to see how much space is free, execute the command: show table status like 'yourtableinnodb' Iago Sineiro wrote: >Hi all. > >I import a mysqldump from MyISAM database in a new innodb database. It gives >me an error saying that the table is full > >ERROR 1114 at line 3035: The table 'LALBARANPR' is full > >These are the values for the innodb variables in the my.cnf file: > >innodb_data_file_path = ibdata1:2000M;ibdata2:2000M >innodb_data_home_dir = /mysql/ >innodb_log_group_home_dir = /mysql/ >innodb_log_arch_dir = /mysql/ >set-variable = innodb_mirrored_log_groups=1 >set-variable = innodb_log_files_in_group=3 >set-variable = innodb_log_file_size=5M >set-variable = innodb_log_buffer_size=8M >innodb_flush_log_at_trx_commit=1 >innodb_log_archive=0 >set-variable = innodb_buffer_pool_size=16M >set-variable = innodb_additional_mem_pool_size=2M >set-variable = innodb_file_io_threads=4 >set-variable = innodb_lock_wait_timeout=50 > >What could I do? > >Thanks in advance. > >Iago. > > > >--------------------------------------------------------------------- >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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- ------------------------------------------------------ \|/ ______ \|/ `@" / o . \ "@' Microsoft? Por acaso é alguma nova /___| \____/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\ http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ ------------------------------------------------------ --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
