Export

Export

Post by Dr. De » Thu, 13 Jul 2006 13:02:08


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
 
 
 

Export

Post by Jare » Thu, 13 Jul 2006 13:36:29

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.

 
 
 

Export

Post by Dr. De » Fri, 14 Jul 2006 13:26:52


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
 
 
 

Export

Post by Plantk » Fri, 01 Feb 2008 18:09:31

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

Post by Kim » Fri, 01 Feb 2008 18:24:01


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

Export

Post by Captain Pa » Fri, 01 Feb 2008 18:53:33


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

Export

Post by Jerry Stuc » Fri, 01 Feb 2008 21:48:02


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
==================