Connecting Tech Pros Worldwide Help | Site Map

extend of limitation for table

Familiar Sight
 
Join Date: Oct 2008
Posts: 128
#1: Sep 30 '09
is there any extend of limitation for table in my sql i have a table of resullt containing 80000 data in excell format it increases every year .i cant import it in mysql.i hav to work on it .kindly explain what to do????
ssnaik84's Avatar
Member
 
Join Date: Aug 2009
Location: Bengaluru, India
Posts: 119
#2: Sep 30 '09

re: extend of limitation for table


MySQL has no vertical limit.. check this
Familiar Sight
 
Join Date: Oct 2008
Posts: 128
#3: Oct 1 '09

re: extend of limitation for table


Quote:

Originally Posted by ssnaik84 View Post

MySQL has no vertical limit.. check this

as my sql limit is (Max: 2,048KB) at local host

and my file size is 11.1 mb

kindly suggest how to import this file on local host
and then on server
as i work temperorily at local host then upload data and file to server
as i m new to mysql
Familiar Sight
 
Join Date: Oct 2008
Posts: 128
#4: Oct 1 '09

re: extend of limitation for table


Quote:

Originally Posted by kkshansid View Post

as my sql limit is (Max: 2,048KB) at local host

and my file size is 11.1 mb

kindly suggest how to import this file on local host
and then on server
as i work temperorily at local host then upload data and file to server
as i m new to mysql

upload_max_filesize = 20M change in php.ini file
i want to know limit of this size
i think its max value is 8mb
what if i want about 50 mb?????
Reply