>-Original Message-
>From: mos [mailto:mo...@fastmail.fm]
>Sent: Sunday, February 13, 2011 4:50 PM
>To: mysql@lists.mysql.com
>Subject: How to export data with column names?
>
>I want to use
>
>select * into outfile "myfile.txt" from table1;
>
>a
outfile.txt
~Chamila Gayan
On Mon, Feb 14, 2011 at 11:15 AM, mos wrote:
> I want to use
>
> select * into outfile "myfile.txt" from table1;
>
> and have it export the data as tab delimited but with the column names. I
> need the column names because the import utilit
I want to use
select * into outfile "myfile.txt" from table1;
and have it export the data as tab delimited but with the column names. I
need the column names because the import utility will use that to create
the table in another (non-MySQL) database.
As it stands, I can't
I want to use
select * into outfile "myfile.txt" from table1;
and have it export the data as tab delimited but with the column names. I
need the column names because the import utility will use that to create
the table in another (non-MySQL) database.
As it stands, I can't
>-Original Message-
>From: Michael Dykman [mailto:mdyk...@gmail.com]
>Sent: Sunday, January 09, 2011 3:02 PM
>To: LAMP; mysql@lists.mysql.com
>Subject: Re: export result from select statement
>
>I second Jerry's recommendation. It always works like a charm for
>-Original Message-
>From: LAMP [mailto:l...@afan.net]
>Sent: Sunday, January 09, 2011 9:46 PM
>To: mysql@lists.mysql.com
>Subject: Re: export result from select statement
>
>maybe it's "clear" to other but it's pretty unclear.
>#mysql -userna
gt;> E-mail: je...@gii.co.jp
>> Web site: www.the-infoshop.com
>>
>>
>>
>>> -Original Message-
>>> From: LAMP [mailto:l...@afan.net]
>>> Sent: Saturday, January 08, 2011 6:05 PM
>>> To: mysql@lists.mysql.com
>>> Subject: export
the-infoshop.com
-Original Message-
From: LAMP [mailto:l...@afan.net]
Sent: Saturday, January 08, 2011 6:05 PM
To: mysql@lists.mysql.com
Subject: export result from select statement
Hi guys,
I wonder how to store to csv or txt file result from SELECT query?
not a whole table nor database
query? not a
whole table nor database. Just results from SELECT query.
Usually I use MySQL Query Browser and Export feature, but in this case I
don't have access with MySQL Query Browser. Though, I have a command line
access.
I found on one place something like
#SELECT 2+2 into outfile '/p
foshop.com
>
>>-Original Message-
>>From: LAMP [mailto:l...@afan.net]
>>Sent: Saturday, January 08, 2011 6:05 PM
>>To: mysql@lists.mysql.com
>>Subject: export result from select statement
>>
>>Hi guys,
>>I wonder how to store to csv or txt file resu
.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
>-Original Message-
>From: LAMP [mailto:l...@afan.net]
>Sent: Saturday, January 08, 2011 6:05 PM
>To: mysql@lists.mysql.com
>Subject: export result from select statement
>
>Hi guys,
>I won
m SELECT query.
> Usually I use MySQL Query Browser and Export feature, but in this case I
> don't have access with MySQL Query Browser. Though, I have a command line
> access.
> I found on one place something like
> #SELECT 2+2 into outfile '/path/to/specific/directory/test.csv&#x
Hi guys,
I wonder how to store to csv or txt file result from SELECT query?
not a whole table nor database. Just results from SELECT query.
Usually I use MySQL Query Browser and Export feature, but in this
case I don't have access with MySQL Query Browser. Though, I have a
command
On Thu, Nov 18, 2010 at 2:54 PM, Sydney Puente wrot
> a mysqldump might do that job too, but the output from mysqldump
> --compatible
> was rejected by oracle.
>
Hmm. Interesting, you might want to file an issue about that - now that
MySQL is oracle-owned, you'd expect at least that to work, wou
rejected by oracle.
-Syd
- Original Message
From: Kevin (Gmail)
To: Johan De Meersman ; Shawn Green (MySQL)
Cc: Sydney Puente ; mysql@lists.mysql.com
Sent: Wed, 17 November, 2010 18:17:38
Subject: Re: export db to oracle
Hello,
It should be possible to connect Oracle to the MySQL
You can try using Oracle SQL Developer Tool which got the data import
function from MySql.
On 11/17/2010 4:14 AM, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have
or ETL and data integration and it is
very manageable.
You can trap errors using cursors if the data has anomalies.
Kevin O'Neill
- Original Message -
From: "Johan De Meersman"
To: "Shawn Green (MySQL)"
Cc: "Sydney Puente" ;
Sent: Wednesday, Novemb
On Wed, Nov 17, 2010 at 2:26 PM, who.cat wrote:
> Maybe you can dump as a csv format,then create table all tables in oracle
> .After that you can write a script program format the csv to oracle which
> can be recognized.
>
MySQL's select into outfile may well be good enough to manage to output
o
On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
> On 11/16/2010 15:14, Sydney Puente wrote:
>
>> Hello,
>>
>> How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I
>> need
>> to pass t
On 11/16/2010 15:14, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas? It is on Redhat if that makes a difference
5.1.49 server. On the 4.x server I ran:
# mysqldump -A -uroot -p | gzip -4 > ./4.x_mysqldump.sql.gz
Once done and I have MySQL 5.x running on the same box, I type:
# gzip -dc 4.x_mysqldump.sql.gz | mysql -uroot -p
Question: So with these 2 commands I export all the databases and user's and
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar wrote:
> use can use mysqldump with option *-no-data
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green wrote:
> Vikram A wrote:
>
>> Hi,
>>
>>
Vikram A wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
There are several ways to get "structure" information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE.
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, "Carsten Pedersen" wrote:
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is
You can also use HeidiSQL, another free tool to visually manage and export
structure/data etc (and a whole host of other stuff) I use it to manage
windows and linux hosted databases.
George
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: 08 April
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is t
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Th
Hi,
I would like to export my table structure from MYSQL from a particular db. Is
there any tool for doing this?
Please guide me.
Thank you
VIKRAM A
>It seems that one of the tables we need to export and import
>contains rows which is used for dropdown menus.
>
>
>
>This has the following effect:
>
>
>
>. Each item in the "text" field is added in the field by
machiel.richards wrote:
Good day guys
[snip]
. Each item in the "text" field is added in the field by entering
the country name then pressing enter and then entering the next, etc
. When exporting the data to a file (even when enclosing each field
within quotes) it still wr
the tables we need to export and import
contains rows which is used for dropdown menus.
This has the following effect:
. Each item in the "text" field is added in the field by entering
the country name then pressing enter and then entering the
Thank you for the link but seeing that I am still new with MySQL , this does
not mean anything to me.
From: prabhat kumar [mailto:aim.prab...@gmail.com]
Sent: 08 January 2010 4:22 PM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: FW: MySQL export and import into Oracle
http
ds termininated by ',' ;
- Partha
www.mafiree.com
- Original Message
From: Rodrigo A. de Brito Bastos
To: mysql@lists.mysql.com
Sent: Fri, 8 January, 2010 6:00:19 PM
Subject: Export into txt file (comma delimited)
Hey guys!
Is there a way to export a table into a txt
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if
On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards wrote:
> Hi guys,
>
>
>
> Can you please assist me in rewriting this query in order to run this
> against a mysql database?
>
>
>
> It seems that the decode function do
- Rodrigo A. de Brito Bastos wrote
>Hey guys!
>
>Is there a way to export a table into a txt file but delimited *with comma*?
>
Hello!
you can use this syntax:
select * from ae_a222
where ano=2009 and dia_juliano between '1' and '365'
into outfile"C:\\
Hey guys!
Is there a way to export a table into a txt file but delimited *with comma*?
I'm using this expression:
select * from ae_a222
where ano=2009 and dia_juliano between '1' and '365'
into outfile"C:\\Documents and Settings\\rbastos\\Meus
documentos\\teste.txt
Hi guys,
Can you please assist me in rewriting this query in order to run this
against a mysql database?
It seems that the decode function does not exist in mysql.
select
decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,
count(*) tot
from profiles
where email i
users entered a blank space
> which is then counted as a character and is thus not null.
>
> This is causing all kinds of havoc for them as Oracle apparently still
> sees this as nulls.
I'm not sure what export method you're using, but you should be able to
fix t
Hi Machiel, all!
machiel.richards wrote:
> Hi All
>
> [[...]]
>
> What the Oracle guys found was that some of the fields were blank even
> though the fields were configured as not nullable.
>
> I found that where this is the case, the users entered a blank space
> which is
.
Regards
-Original Message-
From: Nicola Salvemini [mailto:nicolasalvem...@yahoo.it]
Sent: 07 January 2010 3:45 PM
To: sureshkumar...@gmail.com; Mikhail Berman; machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: table export in cron
- machiel.richards wrote
- machiel.richards wrote
>
> How can we do this when running in a cron script?
>
Hi!
You can use following command in a shell script running from cron:
echo "select * from into outfile '/path/to/output/file' fields
terminated by '|';" | mysql --user= --password=
;
Bye!
> Date: Wed, 06 Jan 2010 10:42:14
> To: machiel.richards
> Cc:
> Subject: Re: table export in cron
>
> Hi Machiel,
>
> As an alternative, you might consider use of mysqdump command,
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
> script running
export in cron
Hi Machiel,
As an alternative, you might consider use of mysqdump command,
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
script running from cron
The script might look like this:
=
!#/bin/ksh
mysqldump --password=yourpassword [more switches needed here
gt;switch.
Hoping this helps,
Mikhail Berman
machiel.richards wrote:
Hi all
I have a question regarding exporting of tables to a file
from mysql.
We need to export tables from mysql to a delimeted file
which will then be imported into another databas
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e "select * from into outfile '/path/to/output/file'
fields terminated by '|'" ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Hi all
I have a question regarding exporting of tables to a file
from mysql.
We need to export tables from mysql to a delimeted file
which will then be imported into another database (oracle).
We can do this manually from within mysql
r should I export the dbs and than import
tham?
Best regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reini...@filmakademie.de
Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de
Eintragung A
At 01:17 PM 12/13/2009, bharani kumar wrote:
hi friend
Am working in php and mysql, i want to write the join query from the 4
table,
Am very confused how to do ,
I'm not sure why you would want to join all of the tables together and then
export them. It will mean you will have rows rep
MENT=16 ;
I want to render record using join function ,
this record need export as csv
Thanks
On Monday 31 March 2008 16:24:59 Marcos Vinícius Vieira dos Santos wrote:
> I have to export my databases and I get large files for my dump.
>
> How can I export compressed databases in MySQL?
>
> I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pa
Hello everyone,
I have to export my databases and I get large files for my dump.
How can I export compressed databases in MySQL?
I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pass'
'database_name' > $path/file_name.sql;
Thanks,
Marcos
Thanks,
Exactly what I was looking for. It helps to know what you are looking for
when browsing the help file.
Jesse
- Original Message -
From: "Chris White" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, February 15,
Jesse wrote:
Is there a way to export results of a query to a file? In other
words, if I do a "select * from somefile", is there a phrase like
"send output to somefile.txt", or something? I've searched the help
file, and I guess I don't know what I'm lo
Is there a way to export results of a query to a file? In other words, if I
do a "select * from somefile", is there a phrase like "send output to
somefile.txt", or something? I've searched the help file, and I guess I
don't know what I'm looking for,
Oh it's easy. Select database, export, select table, select csv, check
save as file, go. I'm using an older version but I'd bet it hasn't
changed much. You'll figure it out.
D. Eric Chadbourne
My play sit
ysql.com
Subject: Re: MySQL export to csv
Dwight E Chadbourne wrote:
> If there's only a couple of tables you could just export to CSV per
> table (phpmyadmin makes this easy). Simple for the Access user to
import.
Great. In fact there is only one table but I cannot see where i
Dwight E Chadbourne wrote:
If there's only a couple of tables you could just export to CSV per table
(phpmyadmin makes this easy). Simple for the Access user to import.
Great. In fact there is only one table but I cannot see where in
phpmyadmin the export is done..?
--
Regards
If there's only a couple of tables you could just export to CSV per table
(phpmyadmin makes this easy). Simple for the Access user to import.
Select... into outfile... is fine. See:
http://dev.mysql.com/doc/refman/5.1/en/select
Can anyone tell me how to export a mysql db to a csv file suitable for
my client to import into his windows access program.
--
Regards,
Alf Stocktonwww.stockton.co.za
The abuse of greatness is when it disjoins remorse from power.
-- William Shakespeare, "J
y.
Also when I export this data from the DB, if I use PHPMyAdmin to
export the table I end up with a record that looks like this:
INSERT INTO `news` (`newsId`, `title`, `subTitle`, `contact`,
`newsTs`, `description`, `imageId`) VALUES (5, 'Ðа берегу
пуÑтынных волн',
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] > [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
h
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] > [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
h
mysqldump -A -u {username} -p > {thefilenameyouwanttoputitin}
On Mar 19, 2006, at 8:47 PM, tony vong wrote:
What is the sql command to export the whole database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protect
What is the sql command to export the whole database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Bruce Carey wrote:
> - my problem is that when a text field, with html in it, it makes it
> into several hundred recs
Well, that's strange -- I use mysqldump to dump/xfer/load records
with fields containing HTML regularly, using the mysqldump defaults,
and have no problems.
Have you tried the de
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different line/r
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different lin/re
Bruce Carey wrote:
> I posted this earlier, could someone take a look at it?
In the time since you first posted, you could have at least glanced
at the Fine Manual :-) which shows that:
>> mysqldump --opt --fields-terminated-by='\t'
>> --fields-optionally-enclosed-by='#*#*#'
Any of the field-
I posted this earlier, could someone take a look at it?
TIA,
Bruce.
On Mon, 19 Dec 2005 02:15:54 -0500
"Bruce Carey" <[EMAIL PROTECTED]> wrote:
Hi List,
I have recently had a crash coursh in the fineer points
of db recovery due to a mis-managed server.
Could someone help me out with advi
On Monday 19 December 2005 08:15, Bruce Carey wrote:
> Hi List,
>
> I have recently had a crash coursh in the fineer points of
> db recovery due to a mis-managed server.
>
> Could someone help me out with advice on the proper syntax
> for doing mysqldump? I have a rather large db (4.2GB), and
> reg
Hi List,
I have recently had a crash coursh in the fineer points of
db recovery due to a mis-managed server.
Could someone help me out with advice on the proper syntax
for doing mysqldump? I have a rather large db (4.2GB), and
regular dump files get easily corrupted, so I found out,
plus LO
phpMyAdmin has the ability to export to XML format. If you take a look at
its code, you may see what command is used to dump to XML. Specifically, the
code for XML export is in /libraries/export/xml.php. May put you in the
right direction.
Ben
On 11/28/05, prathima rao <[EMAIL PROTECTED]>
hi all,
has anyone tried to export a data from a table to *.xml format
i want a front end programme to do this automatically
for example
i have a database test in which table testing exists
i want the data from that table to be exported in xml format at a click of a
button
regards
rao
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special characters to stay
the same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat
ife.com | selfgnosis.com
On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or
05, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via ph
ecial characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via phpMyAdmin export:
Habitat is a “what you see is what you get� or
“WY
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via phpMyAdmin export:
Habitat is a √¢‚Ǩ≈
documents, for which I have created a
> database and several forms to store this information. The problem is
> that it is very time consuming to insert manually each one of this
> documents.
>
> I think the solution is to create a OpenOffice Template for the
> document, with specific tags,
I was just wondering - does anyone have or know of a sql or php script
for exporting a table's data as a whole bunch of INSERT statements?
phpMyAdmin will generate that script for you.
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Dat
perfect! thanks Manoj
> -Original Message-
> From: ManojW [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 2 August 2005 10:01 AM
> To: Rob Agar; mysql@lists.mysql.com
> Subject: Re: export data as sql inserts
>
>
> mysqldump is your friend.
>
> Man
mysqldump is your friend.
Manoj
- Original Message -
From: "Rob Agar" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 02, 2005 8:53 AM
Subject: export data as sql inserts
> hi list
>
> I was just wondering - does anyone have or know of a sql or php script
hi list
I was just wondering - does anyone have or know of a sql or php script
for exporting a table's data as a whole bunch of INSERT statements?
cheers
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
problem is that it is very time consuming to insert manually
each one of this documents.
I think the solution is to create a OpenOffice Template for the document, with
specific tags, to recover and export the file "contents.xml" (which is part of
the *.sxw zip file) 'automa
Which version of mysql are you exporting from and inserting into?
[EMAIL PROTECTED] wrote:
Hi all,
I am trying to create a table on the remote server from a table I created on my local sever but it never seems to
work
CREATE TABLE `sheet1` (
`id` int(10) NOT NULL auto_increment,
`title` v
Hi all,
Juan Pedro Reyes Molina wrote:
I have been able to create your table in my mysql 4.1.12
I think your remote server is in mysql 4.0 series
I had the same problem some days ago.
I can almost garantee that the local server is running MySQL 4.1.x, and
I can garantee (99.99% sure)
I have been able to create your table in my mysql 4.1.12
I think your remote server is in mysql 4.0 series
[EMAIL PROTECTED] wrote:
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, July 19, 2005 10:08 PM
Subject: table export problem
Hi all
Hi all,
I am trying to create a table on the remote server from a table I created on my
local sever but it never seems to
work
CREATE TABLE `sheet1` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`fname` varchar(255) NOT NULL default '',
`sname` varcha
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, July 19, 2005 10:08 PM
Subject: table export problem
Hi all,
I am trying to create a table on the remote server from a table I created on my
local sever but it never seems to
work
CREATE TABLE
If you are on Windows then you can directly import
data using SQLyog's ODBC Import Tool.
www.webyog.com
Regards,
Karam
--- "S.D.Price" <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database
> created in Access to
> MySQL using PHPMyA
I've just seen the MySQL Migration Toolkit and looks very nice. Beautiful tool.
On 5/17/05, S.D.Price <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database created in Access to
> MySQL using PHPMyAdmin - I can't seem to import the data a
, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -Original Message-
> From: EP [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 18, 2005 2:02 AM
> To: Josh Trutwin; mysql@lists.mysql.com
> Subject: Re: Export from Access
>
> I recently exported a lar
I recently exported a large Access database to MySQL using MyODBC.
It took me a while to figure out that MyODBC was the thing to try, but once I
did tried it, it only took me a few minutes to do the export. I highly
recommend that approach (MyODBC).
-Eric
> Original Mess
You can try a freeware utility you can find at:
http://www.bullzip.com//products.php (I have tried it and works quite well)
Additionally you could use DBDesigner (www.fabforce.com) and make a reverse
engineer of you database and export it to a Sql file.
Hope this help you.
Best regards,
Alvaro
On Tue, 17 May 2005 17:17:31 +0100
"S.D.Price" <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database created in Access
> to MySQL using PHPMyAdmin - I can't seem to import the data as csv
> or txt.
Acess should allow exportin
Hi,
can anyone explain how I would export a database created in Access to
MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt.
Thanks
Steven
'|'
> from myTable
>
> Why is this statement rejected? Why is it not
> documented anywhere in the manual except for a
> passing
> reference?
>
> And if there's no such a statement, how come there
> are
> many references to it on the web that date back
rsions older than 4.1.9?
Finally, if this statement has been depricated/removed
from 4.1.9, is there any way to export a table to a
CSV file?
Thanks,
Homam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 306 matches
Mail list logo
