It seems like you have hit a file size limit. Soalris has a 2 Gig ( or is it 4Gig) file size limit which is restricting your database. You could get past this by breaking up your data into different segments, eg. group the data by month and store it in monthly tables, reducing the size of the datafile, and then use a merge table to group it all back together into a "virtual" table.
cheers richard >>> samit darne <[EMAIL PROTECTED]> 01/11/02 09:25PM >>> Hello, I am new to MYSQL platform: Sun Solaris 2.6 mysql version: 3.22.32 I upgrade the hard drive from 4G to 18G as database was increasing and causing problem now space problem is solved and got in to another problem. Database is not getting updated through C programs and perl scripts( that takes the raw data and update in database) which were working fine before the Hard drive upgrade. While C program is running looking at processlist I actually see data being inserted for a particular day in a particular table. After the program finishes I do a query for that particular day on a particular table I don't see any result. I get Empty Set. When I manually insert an entry and do query I do get result for that entry. I don't know what's going on has anyone ran in to this problem? Thanks __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ ---- -- Content-Type: text/plain; Content-Disposition: attachment; filename="disclaimer.txt" . ---- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . . --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php