Export

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

"Dr. Deb" <dgfreeman@mon-cre.net> wrote in message
news:cKGdnQ-k5J9l7CnZnZ2dnUVZ_q-dnZ2d@trueband.net...
>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

If I remember correctly, a .sql file is created when you use one of the
tools to backup the database, which writes a text file with everything
needed to recreate the database.

Jim Langston wrote:
> "Dr. Deb" <dgfreeman@mon-cre.net> wrote in message
> news:cKGdnQ-k5J9l7CnZnZ2dnUVZ_q-dnZ2d@trueband.net...
>> 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
>
> If I remember correctly, a .sql file is created when you use one of the
> tools to backup the database, which writes a text file with everything
> needed to recreate the database.
>
>

phpMyAdmin has an option to export to CSV (comma separated values) which
should do the trick.

Matt

--
"I'm an idealist. I don't know where I'm going, but I'm on my way." -
Carl Sandburg

http://clicktowalk.com

Page design © Matthew McCabe <http://mattmadethis.com> -
http://mattmadethis.com

Site hosted by Xeriom Networks <http://xeriom.net/in/1019> -
http://xeriom.net/in/1019