List:General Discussion« Previous MessageNext Message »
From:Jay J Date:June 19 1999 5:39pm
Subject:Re: Storing HTML text
View as plain text  
.. Nevermind WinMySQL for your purposes .. just installed, and realized what
it was.

----- Original Message -----
From: Jay J <3pound@stripped>
To: <mysql@stripped>
Sent: Saturday, June 19, 1999 12:31 PM
Subject: Re: Storing HTML text


> Being perl-centric..  my instinct would be to use Perl w/ODBC and
DBD::MySQL
> for the whole thing.
>
> I realize there may be incompatibilites between 'column types', but why
not
> just recreate the structure (memos -> mediumtext, etc..), dump from Access
> to a .csv, then load it in with mysqlimport or LOAD DATA?
>
> BTW - there's a chance one of the many MySQL GUI's (many use GTK, or even
> WinMySQL http://www.geocities.com/SiliconValley/Circuit/4105/) might help
ya
> out..
>
> -Jay J
>
> ----- Original Message -----
> From: Paul DuBois <paul@stripped>
> To: Chris Lott <chrisl@stripped>
> Cc: <mysql@stripped>
> Sent: Saturday, June 19, 1999 12:04 PM
> Subject: Re: Storing HTML text
>
>
> > At 8:03 AM -0800 6/19/1999, Chris Lott wrote:
> > >> Since you are (apparently) going to be using a script to retrieve
your
> > >> data and generate the HTML pages, why don't you also use a script to
> > >> read your data and insert it in the first place?  There's no reason
> > >> you have to use LOAD DATA to put in your data.
> > >
> > >I'm going to use PHP to build the pages and retrieve the data. I can
use
> PHP
> > >to insert the data... but I am looking for a way to convert a large
> amount
> > >of legacy data that has been, up to now, stored in Microsoft Access
db's
> > >using a combination of fields including memo fields for the pages of
> text.
> > >My first thought was to dump them into some delimited format and import
> them
> > >via LOAD DATA, but this fails because of the variable length of the
memo
> > >fields...
> > >
> > >I will look into using PHP to read the files and insert the data... or
> > >perhaps find a Perl guru to help do something if that is the direction
I
> > >have to take.
> >
> > Yes, for a problem like that, you might find a standalone program
> > written using Perl and DBI a better solution than PHP.  PHP can be
> > used for standalone programs, but it's really more suitable for a Web
> > environment.
> >
> > Other readers of the list may have different views - I'd be interested
> > to hear other suggestions.
> >
> > --
> > Paul DuBois, paul@stripped
> > Northern League Chronicles: http://www.snake.net/nl/
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
> > posting. To request this thread, e-mail mysql-thread5485@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail mysql-unsubscribe@stripped instead.
> >
> >
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5487@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
Storing HTML textChris Lott19 Jun
  • Re: Storing HTML textPaul DuBois19 Jun
    • Re: Storing HTML textChris Lott19 Jun
      • Re: Storing HTML textPaul DuBois19 Jun
    • Re: Storing HTML textGarrick Staples19 Jun
    • Re: Storing HTML textJay J19 Jun
    • Re: Storing HTML textJay J19 Jun
  • Re: Storing HTML textRobert Hazeltine20 Jun
Re: Storing HTML textTomas Garcia Ferrari21 Jun
Re: Storing HTML textPinkeshP21 Jun
Re: Storing HTML textTomas Garcia Ferrari22 Jun