Hi, sam
You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:
LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
sam rumaizan
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Using a data modelling tool (like Dezign from
> Datanamic) or a scripting
> tool (like DbScripter), all you need do, I think, is
> load the Acces
Using a data modelling tool (like Dezign from Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is load the Access
database into the tool, configure the tool to create an export script
for MySQL (say, using InnoDB to enable FKs), touch up as desired, and
generate the s
Its my understanding you need InnoDB table types, but I do not know of the
single foreign key per table. I have a DB with multiple foreign keys per table
and its seems to work fine.
Bob
-Original Message-
From: Paun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 5:19 PM
To:
One reason may be due to your ON condition.
ON table2.ID=table2.ID_table1
You reference table 2 twice and I doubt that on the table2 table id equals
id_table1 very often. Because table2 is LEFT JOINed to table1, you will
only be able to update the rows that match your ON condition. Again, that
OK, now I really feel stupid. It helps to change the ownership of the
files to mysql:mysqlduh.
Curtis
Curtis Maurand wrote:
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created
ones, the database is recognized, but i get errors say
Hi,
An SQL-statement that is conceptually equal to the following caused some
astonishment.
UPDATE table1
LEFT JOIN table2 ON table2.ID=table2.ID_table1
SET table2.value=table2.value-IF(table1.condition=7,1,0),
table1.condition=8
WHERE table1.ID=$id
My problem is the IF condition, which alway e
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created ones,
the database is recognized, but i get errors saying that the columns in
the tables are not recognized.
I'd really like to get this data ba
I've used the 'load data infile' command to import data from a file and it
worked well for my purposes. See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html for the full syntax.
Rhino
- Original Message -
From: "Manuel J. Contreras Maya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I managed to do it using
mysql> load data infile '/home/manuel/databases/import.txt'
-> into table countries
-> fields terminated by ';';
Query OK, 240 rows affected (0.01 sec)
Records: 240 Deleted: 0 Skipped: 0 Warnings: 18
(I will check the warnings...)
I guess my system do not have mysq
There's a tool called "mysqlimport". I recommend using that. Or, if you
have to extract data from a larger set, you could write a program. But,
mysqlimport is the easiest way. If you're on a UNIX machine, run 'man
mysqlimport' for more information.
Good luck,
Brian
-Original Message-
Fr
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Thanks, it is working for the mentioned format.
> Is there any method for importing directly the spooled file from oracle without
> changing the file format into the required format like using tab and newline.
I don't know Oracle,
[mailto:[EMAIL PROTECTED]
Sent: Thu 9/30/2004 2:01 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: importing data into mysql from oracle using a text file
Hi,
I did imported your data im
Hi,
I did imported your data im my server but I had to do some changes to sample.txt.
I have replaced in a text editor "\t" with empty string. is a real tab
while \t is just a text. Additional change was to replace "\n" (which is text but not
newline with empty string). The I did the following (b
Title: Re: importing data into mysql from oracle using a text file
The sample lines are like this in
alarm.txt
ARRIVED DETECTED
NAME
TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
Can you post one or 2 sample lines from alarm.txt ?
Regards,
Andrey
P.S.
(i am not on [EMAIL PROTECTED] so add me to the CC:)
[EMAIL PROTECTED] wrote:
Hi,
I tried with the spool option to get the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select
After a day of looking, I answered my own questions, and I'll post those
answers here in case anyone else was interested in the answer.
First, "LOAD DATA" + "ALTER TABLE ADD INDEX"... seems to be slower than
a "mysqldump" + "ANALYZE TABLE". Of course, you don't always have a
mysql dump file.
A
This is just my experience.
But if you are doing this sort of work, it may well pay to construct
your own import program. There are many ways of doing this, like
parsing an email message, or using a XML/SOAP server. This will
probably pay on the long run, as you can introduce filters, data che
If I understand correctly, your text file does not have an ID for each
row, but the table does have an ID column. Good. Your table should
have the record ID column defined as AUTO_INCREMENT. Something like
CREATE TABLE table_name (
ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
other column
[snip]
How can i import table structure and data which is there in a text file
to database say test_database using phpmyadmin. I m asking using
phpMyadmin as i don have shell access and hence can't use mysql
commands.
[/snip]
What format is the table structure in?
As for the data it should be fai
* Trevor
> after a bit of help on how to import data from a pastel
> accounting database into mysql, i also need to remove some lines
> out of the pastel txt file before importing into mysql
You are defining your new problem to be something to be sorted out before
mysql is involved, in which case
Sorry hit the wrong reply button ;-)
> Hi Rajendra,
>
> In case you are new to mysql the easiest way would be to do it on the
> command line base :
>
> 1) shutdown the server
> 2) go to your data directory f.e /var/lib/mysql/dbname1
> 3) copy the table files to the folder of dbname2
>
> f.e c
Hello Sir,
thanks for the reply. i have one more doubt.
i want to import 2 tables from one database to
another database like the tables structure and as well
as its records.
have a nice day,
Naren.
--- Egor Egorov <[EMAIL PROTECTED]> wrote: >
Rajendra Kumar <[EMAIL PROTECTED]> wrote:
> >
Rajendra Kumar <[EMAIL PROTECTED]> wrote:
>
> i know little bit about mysql. i use mysql to use
> the webportal system of phpnuke. can anyone help me
> to import data in mysql. for exams i have a file
> nuke.sql which contains like tables design and there
> records.
>
> how to call this file w
> Hi all,
Hi,
> I have a database in Pervasive and I want to import it to MySQL.
> I tried to convert the Pervasive data to a text file and then import it
> into MySQL but it failed.
> Is there any tool to do this directly?
> Does MySQLCC provide any export option through which I can get the dat
lin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:03 PM
Subject: Re: importing data
> Please see section 6.17 of http://www.mysql.com/doc/index
Dear Kevin,
> Is there an easy way or perhaps a utility to import a tab delimeted
text
> file of data into a mysql table
Try PhpMyAdmin (www.phpmyadmin.com). Great browser based utility. You
need to have PHP installed in order to use it.
You may as well use the LOAD DATA INFILE command. Check
h
Please see section 6.17 of http://www.mysql.com/doc/index.html.
Bing
Bing Du <[EMAIL PROTECTED], 979-845-9577>
Texas A&M University, CIS, Operating Systems, Unix
>>> Kevin Fonner <[EMAIL PROTECTED]> 08/07/01 10:08AM >>>
Is there an easy way or perhaps a utility to import a tab delimeted
text
f
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
http://www.mysql.com/doc/L/o/Loading_tables.html
On Tue, 7 Aug 2001, Kevin Fonner wrote:
> Is there an easy way or perhaps a utility to import a tab delimeted text
> file of data into a mysql table
>
> T
Look up
IMPORT DATA INFILE
in the manual
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -Original Message-
> From: Kevin Fonner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 5:09 PM
> To: [EMAIL PROTECT
Hi,
> I have to import Datas From FileMaker Pro to MySQL .
>
> Unfortunately, the FileMaker web site is speaking about plugins to export
> databases, but the access page gives error 500 (!).
Plug-ins? You don't need any plug-ins to export data to MySQL. The only
plug-in for Filemaker I've ever
On Thu, 4 Jan 2001, TEXLID_SUPPORT wrote:
> Could anyone please let me know how I can transfer data from excel to
> a mysql database? If it is possible. The data is stored in an excel
> file on my PC. And I want to transfer the contents (about 500 records
> with 20 fields) of this excel file to
33 matches
Mail list logo