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: Russell McOrmond <russell_-at-_flora.ca>
To: flora-admin-help_-at-_flora.org
Date: Tue, 15 Oct 2002 12:44:38 -0400 (EDT)

On Mon, 14 Oct 2002, Peter Blanchard wrote:

> 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. 

  Look at FreshMeat and other places for CVS to SQL conversion utilities.  
If my own project I would likely write up something quick in PERL, but I 
assume there are hundreds out there already.

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

  This isn't a problem with uploading (IE: the menu item under the larger 
box), but a problem with the CVS import.  You can use the "Or Location of 
the textfile" for larger files.  I do believe that PHP has a file size 
limit which we can extend if there are problems.

  The 'Insert data from a textfile into table' option has been removed
from phpMyAdmin on that server.  Took me a while to find that option ;-)


  For a beginning idea of the complexities of the way phpMyAdmin
implimented this feature, see:  
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

  The "where does the file get loaded, and what access permissions should
it have" are non-trivial issues to deal with.  Had phpMyAdmin included the
very small CVS-to-SQL converter within it (Like the built in SQL-to-CVS
for data dumps), then this problem would not happen at all.

> Thanks again for your help! 
> 
>         - peter
---
 Russell McOrmond, Internet Consultant: <http://www.flora.ca/>
 See http://weblog.flora.ca/ for announcements, activities, and opinions
 Speaking next in Toronto: Rabble Rumble on Digital Copyright Reform
 http://www.digital-copyright.ca/discuss/all?subject=Rabble

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).