Developer Forum

I need to export a "MYSQL" database to either a "dbf" format or a Microsoft
Access readable format. I have a command line base set of instructions,
but it says to export the ".sql" file, which does not exist, as a "comma
delinated" file. So, how do you do it?

I have looked at "gui's" and know they probably work, but so far have not
been able to get one to work. Rather than being a simple, "what .sql
database do you want to export to what format?' I have to be an expert in
Linux/unix operating systems to even get the thing set up. Yes, they were
free, but the important thing is workability.

Thanks

Deb

I love all the bugs in mysql, why arent you converting access to mysql.

this product works well but you will find all tables get converted into
individual MDB file
http://www.yqcomputer.com/

this product says it will do 5 records for each table (wouldn't be to much
to write export routine for each table)
http://www.yqcomputer.com/

which ever one of these you choose you may loose couple of hours
'converting' but otherwise buy one.

The reason is that the guy who needs the file is running Access and does not
want to change. Egro, I need to get it into a form he can read.

Deb

Hi all,
How do I export query results? I'm using phpmyadmin, which only lets
me export the whole database, or 1 page of the results. I get 10211
rows from this query, but everytime i LIMIT to 10000 rows the browser
doesn't finish loading the whole table.

Export to a file instead, that will be much faster and less likely to
fail.

PMA allows you to export a table by itself, not just the whole
database or one page of results.

What error message do you get? Is something timing out? Or are you
running out of memory on your script?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
XXXX@XXXXX.COM
==================