Export the database and then autoload it into MYSQL
On 2001.05.28 21:00:46 -0400 Cal Evans wrote:
> No, MySQL will not read dBase files.
>
> I can think of 3 ways to do it off the top of my head.
>
> 1: Use Visual FoxPro. It will read dBase files and you can use the DBC to
> open a connection to a MySQL database through an ODBC connection. (Been
> there, done that)
>
> 2: Use a dialect of *Base to create an insert.sql file that has 1 insert
> for
> each record in your dBase table. Then just use :
>
> mysql < import.sql
>
> to get it into your database. (I'm over simplifying but not much)
>
> 3: Use PHP. It can (supposedly) read dbase files and MySQL files. Suck
> it
> out of one and push it into another. (Never done this but it sounds like
> it
> could work if everything is configured properly.
>
> If I were you, I'd use #2, it's the easiest.
>
> Cal
> http://www.calevans.com
>
>
> -----Original Message-----
> From: Pat Suwalski [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 28, 2001 7:25 PM
> To: [EMAIL PROTECTED]
> Subject: Help! How to use dBase with mySQL?
>
>
> I'm doing a school project for which I'm to write a PHP script with MySQL
> that searches a dBase database.
>
> I've got my code planned out, but the problem right now seems to be that
> mySQL can't directly read dBase databases.
>
> It's a fairly large database (9 megs), and so I ask: do I need to convert
> it
> somehow or can I just read it directly?
>
> Thanks for any assistance you could spare.
> --Pat
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
--
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com
1-718-382-5752
---------------------------------------------------------------------
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
