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
