A very first thought I got is disable the constraint before import and
re-enable after that.
One way could be to set the foreign key checks to false or alter the
constraint and remove the 'cascade delete' part.
It's just a quick brain storm, please verify the goodness of it, I still
need to get my
Hello,
we have two tables associated with a foreign key constraint.
Table A with the primary key and table B with an "on delete cascade" constraint.
We want to delete datasets in Table B if the related dataset in Table A is
deleted - that works.
Now the Problem:
There is a weekly import defined
On Mon, 2006-08-28 at 13:47 +0200, Thomas Spahni wrote:
> On Sun, 27 Aug 2006, Jim Seymour wrote:
>
> > Hi,
> >
> > I download a csv file from Yahoo in this format:
> >
> > ABIAX
> >20.63
> >2006-08-3
> > ACEIX
> > 8.78
> >2
On Sun, 27 Aug 2006, Jim Seymour wrote:
> Hi,
>
> I download a csv file from Yahoo in this format:
>
> ABIAX
>20.63
>2006-08-3
> ACEIX
> 8.78
>2006-08-3
> CIGAX
>10.08
>2006-08-3
> FSCTX
>
Hi,
I download a csv file from Yahoo in this format:
ABIAX
20.63
2006-08-3
ACEIX
8.78
2006-08-3
CIGAX
10.08
2006-08-3
FSCTX
22.25
2006-08-3
GGOAX
I used mysqldump with the -t option to only dump the raw data. I'm in the
process of importing the dump to a new database with seed data loaded. I'm
attempting to override the existing dataset but continue to get the
following message when the import encounters a duplicate entry: Duplicate
entry
It works!
Here is what I used:
LOAD DATA INFILE
'Batch.txt'
INTO TABLE
Batch
FIELDS TERMINATED BY
'{'
LINES TERMINATED BY
'\r\n';
And the result:
mysql> select * from batch where orderid=240414989;
+---+---++--+
| QAID | OrderID |
Does SQLyog log any errors for you? Are your lines terminated by \n or
\r\n? Have you tried performing this import with the LOAD DATA INFILE
command? There you could at least see if warnings or errors were
encountered.
Scott Hamm wrote:
I got my csv delimited using "{" as follows:
87547{2404149
I got my csv delimited using "{" as follows:
87547{240414986{0{
87547{240414987{0{
87547{240414988{0{
87547{240414989{0{
87547{240414990{1{GALLEGOS---MISKEYED MONTH IN BIRTHDATE
I tried to import using SQLyog as following:
Lines Terminated By: \n
Fields set to Variable length, Fields Terminated b
It sounds like the file is actually a MySQL database. Possibly an innodb file?
You will need to create the requisite table definition so MySQL knows how to
read it, then you might be able to read it.
j- k-
On Thursday 04 March 2004 12:08 am, Egor Egorov wrote:
> Manda Sairam <[EMAIL PR
Manda Sairam <[EMAIL PROTECTED]> wrote:
>
> Hello Sir,
> I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I
> tried opening the file using load data file command but failed with errors .Actually
> the problem is i donot know about the columns or the details abou
Hello Sir,
I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I
tried opening the file using load data file command but failed with errors .Actually
the problem is i donot know about the columns or the details about the db file.How can
i import such a file.
regard
Dear Friends,
I want to import the data from dbf file.
Please tell me how to do this. I am using MySQL++ for accessing the
MySQL. and writing the application in C++.
Waiting your reply.
With best regards,
Suresh S Satpute
--
MySQL General Mailing List
For list archives: http://list
I'm currently trying to move a database (~1.6GB) from a Linux system to a
Sun (Solaris 8). The Linux machine is running:
mysqld Ver 3.23.35 for pc-linux-gnu on i686
The Sun is running:
mysqld Ver 3.23.47 for sun-solaris2.8 on sparc
I did a dump on the Linux box like this:
mysqldump -p --qui
Sean,
Monday, February 11, 2002, 10:01:55 PM, you wrote:
SH> I'm currently trying to move a database (~1.6GB) from a Linux system to a
SH> Sun (Solaris 8). The Linux machine is running:
SH> mysqld Ver 3.23.35 for pc-linux-gnu on i686
SH> The Sun is running:
SH> mysqld Ver 3.23.47 for sun-so
Hello List!
I am having an extremely unusual problem with MySQL3.22.27 running on a
Sun UltraII Solaris 7 (latest patches applied). This implementation of
MySQL 3.22.27 has been rock solid for better than 2 years now.
We have a primary/failover system here, and the primary 'sync
16 matches
Mail list logo
