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
