Who we are   Organizations   Get Involved!   Helpdesk   Weblog   About FLORA   Server project   F.A.Q.

Election 2006 (and beyond): Digital Copyright Canada

Re: problems uploading to mySQL - success!

From: "Peter Blanchard" <people_-at-_planetfriendly.net>
To: flora-admin-help_-at-_flora.org
Date: Mon, 14 Oct 2002 04:59:15 -0400
References: <20021013113923.GA7718@nirvana.urth>

Russell & Krishna, 

> You will want to try to 'past into box' option.  The 'upload' feature 
> isn't implimented well as far as I am concerned, and should insert 
> directly rather than creating a temporary file.   

> I will need to investigate if there is a workaround for this - possibly 
> as simple as changing the location of where the temporary files are 
> stored.

I'm now using myPhpAdmin's "Run SQL query/queries" 
option, and pasting into the box, as you suggested.  

It took a little more work to get the client database 
to generate the required SQL syntaxes -- but now 
that it's set up, it works fine. 

I haven't tried it with large volumes of data (only
about 50 records); but I don't foresee the need 
to do so in this application. I also haven't tried
it with blob/binary fields, only textual/numeric 
data, which is all there is in this database.  

I will remember not to try the "insert data from 
textfile" option again. 

Thanks again for your help! 

        - peter

P.S. You can sse the results at
http://www.planetfriendly.net/calendar/   
(not yet officially launched, but working 
and now with current data!)

Please read the FLORA.org Terms and Conditions before you submit information to FLORA.org
Join the Blue Ribbon Online Free Speech Campaign (USA) (Canada)	FLORA Community Web (FLORA.ORG) is sponsored by FLORA Community Consulting (FLORA.CA).