ThinkDing  

Go Back   ThinkDing > Member Forums > General Chit Chat
Acceptance Mark
User Name
Password


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-21-2005, 10:57 AM
SoapinTrucker's Avatar
SoapinTrucker SoapinTrucker is offline
Member
 
Join Date: Jul 2005
Location: Fresno, California
Posts: 38
Arrow FILE SIZE UPDATE AND INFO

UPDATE ON FILE UPLOAD SIZE IN PHPMYADMIN

Ok folks, I have reached the maximum file size for POWWEB allowable uploads of text files in phpmyadmin. To put it another way, based on what phpmyadmin tells me I can upload with regard to a CSV file size in any one table, the max size is 15,360KB.

I tried a few hours ago to upload a file size of 15,720KB (the size my PC said it was), a file that had 43,000+ links in it, but it did not take it. That bad part is, I waited 11 minutes of it actually uploading to find out that it was too big

Anyway, so now, I dumped some links, and came up with a CSV file that has 42,000 links in it, and it took it. My PC says this file is 15,257KB, and phpmyadmin took it.

phpmyadmin shows these totals for data/index sizes:

Data 15,415 KB
Index 11,320 KB
Total 26,735 KB

Again, this is 42,000 links!

The thing is, I am sharing this info so folks can get a rough estimate of how many links can be saved into one CSV file, as built/collected using POWERMARKS. Your actual mileage may vary

I have to assume (actually, I KNOW), some of my links have no keywords and/or description, and some have way to many keywords, or very long descriptions.

So, with 42,000 links, I can also assume, that the numbers above will almost accurately reflect what most people will be able to expect from collecting links with POWERMARKS, as the *average* is based on so many links, from so many different websites, some cooking, some automotive, some educational, etc. etc. (a very dilluted and varied cross section of the content from the net).

The point is, every link entry can have keywords, and a description, as collected from the website's meta tags. Some webmasters as we all know, go overboard with keywords, and even descriptions, and so any one entry could be stuffed to the hilt with excess "data", and take up more room in your table. BUT, other links have no "data" at all, other than the link itself, and the title.

So if you were to average it all out, mathimatically, I believe 42,000 links is enough dillution to reflect what almost everyone can expect, which is 42,000 links or so in a 15.3MB file.

My next attempt, is to keep adding links to powermarks, and then split the file in two, and upload them both, and see if I can get beyond 42,000 links in a mysql database.

I hope this rambling is helpful to someone, and makes sense

Mike

p.s.- if anyone knows a way I can APPEND a CSV file to my mysql db, using phpmyadmin, please let me know ok? Thank you!

Last edited by SoapinTrucker : 11-21-2005 at 11:02 AM.
Reply With Quote
  #2  
Old 11-23-2005, 11:33 PM
Winston Winston is offline
Administrator
 
Join Date: Jul 2005
Posts: 46
Default

Hi, if you have access to shell try...
Code:
# make a backup (http://dev.mysql.com/doc/mysql/en/mysqldump.html) # capitalizations represent your database information shell> mysqldump -h HOST -u USER -p --opt DATABASE TABLE > search.sql # import a backup (http://dev.mysql.com/doc/mysql/en/mysql.html) # capitalizations represent your database information shell> mysql -h HOST -u USER -p DATABASE < search.sql
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump



All times are GMT. The time now is 03:59 PM.


Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.