Hello,
> Because most web providers will not allow
> direct TCP/IP access to
> MySQL servers, I am considering the following
> strategy:
>
> a) Save the proprietary database to a file
> containing a series of SQL
> CREATE TABLE and INSERT INTO calls.
>
> b) Upload the SQL file to the server via FTP.
>
> c) Launch a PHP script on the web server from
> my program that executes
> the SQL file to insert the data into the MySQL
> database.
Have you tried phpMyAdmin? It's a web-based
administration tool written in PHP to handle mysql
databases.
Check http://www.phpwizard.net/projects/phpMyAdmin/
> Another issue I am running into is the
> difference between the
> proprietary database and MySQL in how quotes
> are escaped. The
> proprietary database wants two sequential quote
> characters, MySQL uses
> a backslash before the quote character.
You can do this with a simple search & replace. Does
the other database provides any means to do it in the
query itself? i.e., in mysql you can query like this:
SELECT replace(some_field, ',', '.') FROM some_table
This query substitutes commas (,) for periods (.) for
some_field.
If you'd like to loose your sanity, you could start
having lots of fun with strings, like this:
SELECT concat('INSERT INTO TABLE_X (field_1) VALUES
(''', replace(some_field, ',', '.'), ''');');
and you can send the result to a text file. this way
you are building a script using a query.
Hope this helps!
>
> Has anyone else gone down this road before? Any
> comments on this
> strategy? Are there any tools or routines
> available to help facilitate
> this process?
>
> --
> Bruce Vander Werf
> [EMAIL PROTECTED]
>
> -
> Please check
> "http://www.mysql.com/Manual_chapter/manual_toc.html";
> before
> posting. To request this thread, e-mail
> [EMAIL PROTECTED]
>
> To unsubscribe, send a message to the address
> shown in the
> List-Unsubscribe header of this message. If you
> cannot see it,
> e-mail [EMAIL PROTECTED]
> instead.
>
>
~avalon~
-
Email Enviado utilizando o serviço MegaMail
-
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