Raj,
Normally, if you have problem with your configurations, I suggest recreate
your databases :
1) backup all your database using mysqldump
*$ mysqldump --opt --user=root --password= --databases db1 db2 db3
db4 > /your/directory/of backups/backup.databases.dmp*
**
**
2) delete your databa
Optimize table does not reclaim space for InnoDB tables in the shared
tablespace, FYI - only for those that live independently when using
the 'innodb_file_per_table' option.
On 12/20/06, Raj Shekhar <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> In my configuration file there was a line
[EMAIL PROTECTED] wrote:
> In my configuration file there was a line that said:
> innodb_data_file_path = ibdata1:10M:autoextend:max:1900M
>
> This refers to the data file that contains all of my databases. The
> number
> 1900M is close to the 2G filesize limit on my linux server. With all of
>
/www.innodb.com/order.php
- Original Message -
From: ""Patrick Herber"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 15, 2006 4:16 PM
Subject: RE: ERROR 1114 (HY000): The table is full converting a big table
from MyISAM to InnoDB o
o use
innodb_data_file_path?
Thanks a lot and regards,
Patrick
> -Original Message-
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 15 January 2006 15:09
> To: Patrick Herber
> Cc: mysql@lists.mysql.com
> Subject: Re: ERROR 1114 (HY000): The table is f
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since
Never Mind:
I set in /etc/my.cnf
max_heap_table_size = 256M
and, all is good.
Van
--
=
http://www.dedserius.com/-Linux rocks!!!
=
Van wrote:
>
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
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 innod
Found it, it was INNODB running out of space. (Can we get better error
messages here?)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 3:24 PM
To: [EMAIL PROTEC
Hi!
You have hit the problem of easy installation of MySQL-4.0 :)
>From the manual at http://www.innodb.com/ibman.html :
.
2 InnoDB startup options
To use InnoDB tables in MySQL-Max-3.23 you MUST specify configuration
parameters in the [mysqld] section of the configuration file my.cnf, or o
Hi,
This is covered in the manual in section "Table is full".
http://www.mysql.com/doc/F/u/Full_table.html
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.m
On Sun, 20 May 2001, Carlos Godoy wrote:
> Hello, wich is the meaning of this message.
> I don't have a table named 'SQL521ed_0':
> Message: General error: The table 'SQL521ed_0' is full
> SQLState: S1000
> ErrorCode: 1114
>From the very fine manual about the SET syntax:
`SQL_BIG_TABLES = 0 |
> set SQL_BIG_TABLES = 1;
You also will have to keep in mind that now that a filesystem is being
used for the MySQL work you'll need the room to do it. In some cases the
default MySQL install uses '/var/tmp' for it's chalkboard which in some OS
installations, referring to UNIX of course
On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote:
> Hi,
> I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full
> I can execute other queries without problems but when I want to execute the query :
>
> SELECT DISTINCT person.*
> FROM person, trai
15 matches
Mail list logo