Re: InnoDB: Error: tablespace size stored in header is 640000 pages, but the sum of data file sizes is 1056000 pages

2005-08-26 Thread Ady Wicaksono
Reply by me. How stupid i'm :( I've finished this warning error problem by adding 4 files --> 3 file each 3 Gbyte and 1 file 500Mbyte Thx mr. heiiki :D Sorry Ady Wicaksono wrote: |Dear All, As subject, Actually i've been ever meet this case when i see : InnoDB: Error: tablespace size

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

2005-01-06 Thread Ian Grant
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

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

2005-01-06 Thread Heikki Tuuri
Ian, - Original Message - From: "Ian Grant" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, January 05, 2005 4:47 PM Subject: Re: InnoDB: Error: tablespace size stored in header is 17024 pages, Dear Heikki Many thanks for your reply. On Mon, 3 J

Re: InnoDB: Error: tablespace size stored in header is 17024 pages, but

2005-01-05 Thread Ian Grant
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

Re: InnoDB: Error: tablespace size stored in header is 17024 pages, but

2005-01-03 Thread Heikki Tuuri
Ian, 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. What does the old .err log contain? Any message about disk space running out? The error below probably has not corrupted your tablespace. Best to run CHECK TAB

Re: InnoDB: Error: tablespace size stored in header

2002-11-13 Thread Heikki Tuuri
Shakeel, - Original Message - From: "Shakeel Sorathia" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 9:39 PM Subject: InnoDB: Error: tablespace size stored in header > Hi, we're using Innodb here and I just upped the number of datafiles > that