If you are getting table full error,may be your table size is exceeding the maximum default size allowed. check the table size and default size.
You can change the maximum size of the table using Alter table command. Somthing like following,but it is better so back up the database before doing this,otherwise if the new size(MAX_ROWS*AVG_ROW_LENGHT) is smaller ,your data will be lost. examle: ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; ALso check the table status Show table status "tablename"; kam... --- [EMAIL PROTECTED] wrote: > > > > > Hi, > > I am trying to insert the records in the database. > After the insertion of > 3millions records, it fails to insert the records > further. Can someone help > me in this problem. How do I go and increase the > capacity of the database. > Moreover if someone can provide me the maximum size > of the database which > is possible. > > Regards, > Anup Mahansaria > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > ===== "Don't worry about the world coming to an end today. It's already tomorrow in Australia." ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º° Do You Yahoo ! ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º° __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
