On Thu, 6 Jan 2005 11:30:33 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> > innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend
>
> You have to add new data files to the end of the line, not to the
> start. Please follow the instructions at
> http://dev.mysql.com/doc/mysql/en/Adding_an
On Wed, 5 Jan 2005 08:19:07 -0800 (PST)
Kentucky Families <[EMAIL PROTECTED]> wrote:
> This is a huge database so the option of using LIKE to bring up
> everything beginning with the search term will result in too many
> hits. I need a way to isolate these entries and search them on whole
> words.
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> are you sure that you copied the complete ibdata1 file to the new
> place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti <[EMAIL PROTECTED]> wrote:
> Kentucky Families wrote:
>
> > ... If I use a VARCHAR or TINYEXT field to enter these values and
> >I want to be able to retrieve all records where the surname field
> >contains the whole word Stotts, how would I ente
Dear MySQL people
I have a question regarding the error:
InnoDB: Error: tablespace size stored in header is 17024 pages, but
InnoDB: the sum of data file sizes is only 16576 pages
which appeared when I upgraded from 4.0.7 to 4.1.7.
Somehow I am 448 pages (7M) short of table space.
Can I fix th