We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and
To: mysql@lists.mysql.com
Sent: Thursday, 4 August, 2011 4:17:50 PM
Subject: strange warnings after upgrade...
We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression
Hi Brian, all!
brian wrote:
On 10-06-14 09:13 PM, brian wrote:
[[...]]
This not only gives an empty set, but also throws 171 warnings (more on
that below). I've remove both the WHERE and GROUP BY clauses with no
success. I've been staring at this for an hour now and can't see what
members AS `Member` ON `Member`.`country_id` = 'Country.id'
WHERE 1 = 1 GROUP BY `Country`.`id`;
This not only gives an empty set, but also throws 171 warnings (more on
that below). I've remove both the WHERE and GROUP BY clauses with no
success. I've been staring at this for an hour now
`countries` AS `Country`
INNER JOIN members AS `Member` ON `Member`.`country_id` = 'Country.id'
WHERE 1 = 1 GROUP BY `Country`.`id`;
This not only gives an empty set, but also throws 171 warnings (more on
that below). I've remove both the WHERE and GROUP BY clauses with no
success. I've been staring
'; database exists
This is the answer.
2009/8/24 Victor Subervi victorsube...@gmail.com
Hi,
I have the following python code:
cursor.execute('create database if not exists spreadsheets;')
cursor.execute('use spreadsheets;')
but it generates this warning:
Warning (from warnings module):
File
Hi,
I have the following python code:
cursor.execute('create database if not exists spreadsheets;')
cursor.execute('use spreadsheets;')
but it generates this warning:
Warning (from warnings module):
File C:\Python25\mysqlConverter.py, line 140
cursor.execute('use spreadsheets
this warning:
Warning (from warnings module):
File C:\Python25\mysqlConverter.py, line 140
cursor.execute('use spreadsheets;')
Warning: Can't create database 'spreadsheets'; database exists
What do?
TIA,
Victor
' or 'drop' table
statement
is preceded with a 'show warnings' statement. Since this file is
used to
initialize a new database in mysql server, is there any reason to have
warnings enabled like this? It seems the warning would be generated
100%
of the time since the database did not exist before
I hope you mean that the SHOW WARNINGS statements follow the DDL statements.
If the DROP statements have the IF EXISTS modifier, then there should not be
any warnings shown in the output. If there are, something (less severe than
an outright error) is wrong with the CREATE statement. It might
Hello,
I am returning to mysql after long break, so not experienced with
details. I inherited a text file with the mysql DDL statements which
create database and tables, etc. Each 'create' or 'drop' table statement
is preceded with a 'show warnings' statement. Since this file is used
It is a little bit of paranoia which is not unhealthy. You might be
running those scripts on a dev server or a shared host where the
default warnings setting is not the default nor is it necessarily
under your control. You are right, warnings *should* be enabled by
default, but when you want
On Tue, 16 Jun 2009, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value 18446744073709551615
adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned
On Wed, 17 Jun 2009, Johan De Meersman wrote:
Aren't those options defined in megabytes ?
On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni t...@lawbiz.ch wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value 18446744073709551615
adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615
adjusted
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file with special characters.
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyISAM CHARSET
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file
PROTECTED]
To: 'C.R.Vegelin' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
: RE: data truncation warnings by special characters
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange Data truncated for column
statement; = no truncation warnings
c) ALTER TABLE tmp CONVERT TO CHARACTER SET UTF8;
Thanks again and a nice weekend.
Cor
- Original Message -
From: Chris W [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
Sent: Friday, April 18, 2008 8:38 PM
Subject: Re: data truncation
hello,
from the page
http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html
I understand that if I want to look at all the warnings with the command :
show warnings;
then I have first to set a limit bigger than any numbers of warnings that
could happen, say :
(I know that it might
Hi All,
When i load data using LOAD DATA LOCAL INFILE, it shows
Query OK, 56678 rows affected, 789 warnings (4.47 sec)
Records: 56678 Deleted: 0 Skipped: 0 Warnings: 789
When i do.
show warnings
It display only 64 rows, can i see all the 789 warning messages as show
above. Please let me
Ananda Kumar schrieb:
When i do.
show warnings
It display only 64 rows, can i see all the 789 warning messages as show
above.
http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html
The maximum number of error, warning, and note messages to store is
controlled by the max_error_count
messages into a file.
regards
anandkl
On 5/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote:
Ananda Kumar schrieb:
When i do.
show warnings
It display only 64 rows, can i see all the 789 warning messages as show
above.
http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html
-Original Message-
From: Colin Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 17, 2007 9:08 PM
To: Kristen G. Thorson
Cc: mysql@lists.mysql.com
Subject: Re: Log Warnings Level
Kristen G. Thorson wrote:
Hi!
But all I really get from this reading is 0 turns it off
Kristen G. Thorson wrote:
But all I really get from this reading is 0 turns it off, 1 prints
some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information
in my
search. Am I missing something, or is this all
Kristen G. Thorson wrote:
Hi!
But all I really get from this reading is 0 turns it off, 1 prints some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information in my
search. Am I missing something, or is this all
The manual indicates that you can specify a specific level to control
what types of warnings are logged:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
(See section on log-warnings.)
But all I really get from this reading is 0 turns it off, 1 prints some
warnings, and 2 prints level
-log on linux and I cannot
reproduce your warning -- I put the create temporary table statements
into a file, and ran it on the OS commandline (using mysql file) as
well as on the MySQL commandline (using source file;). In both cases,
the script ran just fine, no errors or warnings.
-Sheeri
On 6
I'm trying to restore a MySQL database in v5.0 (that minor number is in
the teens, I don't have it at hand). I get a bunch of warnings like:
Warning: Do not know how to handle this statement at line 28:
CREATE TEMPORARY TABLE `CHARACTER_SETS` (
`CHARACTER_SET_NAME` varchar(64) NOT NULL default
Warnings and Errors from queries
Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do I need to write separate script to do this ?
Regards,
Ryan.
On 3/10/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 8:14 PM
To: Dan Nelson
Cc: mysql@lists.mysql.com
Subject: Re: How to Log Warnings and Errors from queries
Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do I need
understand that the option log-errors and log-warnings only logs
server related internal errors. How do I enable logging errors from
queries executed, so that I can fix the problematic query statement
accordingly?
The statement SHOW WARNINGS and SHOW ERRORS does not work on my
server with mysqld
that the option log-errors and log-warnings only logs
server related internal errors. How do I enable logging errors from
queries executed, so that I can fix the problematic query statement
accordingly?
The statement SHOW WARNINGS and SHOW ERRORS does not work on my
server
()) );
where you create that function log_error to write to a file.
Jenifer
- Original Message -
From: Kishore Jalleda [EMAIL PROTECTED]
To: ryan lwf [EMAIL PROTECTED]
Cc: Dan Nelson [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, March 10, 2006 10:03 AM
Subject: Re: How to Log Warnings
.
-Mensaje original-
De: Subscriptions [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 10 de Marzo de 2006 10:27 a.m.
Para: mysql@lists.mysql.com
Asunto: Re: How to Log Warnings and Errors from queries
In PHP, you can see the error message as follows:
$result = mysql_query($sSQL) or die
Hi all,
I understand that the option log-errors and log-warnings only logs server
related internal errors. How do I enable logging errors from queries
executed, so that I can fix the problematic query statement accordingly?
The statement SHOW WARNINGS and SHOW ERRORS does not work on my server
In the last episode (Mar 08), ryan lwf said:
I understand that the option log-errors and log-warnings only logs
server related internal errors. How do I enable logging errors from
queries executed, so that I can fix the problematic query statement
accordingly?
The statement SHOW WARNINGS
On 12 Nov 2005, at 04:26, Harrison Fisk wrote:
The log-warnings option doesn't do what you want. It will cause
the mysqld server log more internal errors. Non-critical errors
such as network disconnects will be logged into the error log with
that setting.
The option you want
. Despite much rummaging in the docs, the log-
warnings options still seem completely undocumented (it gets a few
mentions as a startup option, but nowhere does it say where the
messages disappear to), and despite having it 'enabled' (it's
difficult to know what to set it to as it has
5.0.15, and I find I still
face much the same problem. Despite much rummaging in the docs, the
log-warnings options still seem completely undocumented (it gets a
few mentions as a startup option, but nowhere does it say where the
messages disappear to), and despite having it 'enabled' (it's
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line by line, I get no warnings.
How can I see
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When
At 12:50 PM 10/8/2005, you wrote:
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164
Master: 4.0.20-max
Slave: 4.1.14-max
Replication seems goes well.
This morning i see the follow messages on error log:
050831 5:30:04 [Warning] Slave: load data infile on table 'Stage' at
log position 30438086 in log 'tana-bin.001' produced 5003 warning(s).
Default database: 'TSM'
050831
Hello.
MySQL 4.1.x has a lot of improvements in the framework
of warnings, which MySQL 4.0.x might not have. So
loading the data on the master (4.0.20) hasn't produced the warnings.
You may want to get the files which was loaded to be able to reproduce
the situation later and get
Hi Guys,
I have been searching for the answer to this question for a while. The
answer is so obvious, yet there was no useful source of documentation
that showed it. I am using the load data infile syntax rather than the
command line utility. To get the warnings the show warnings command
Hi
The subject says it all! My mysqlimport command reports 43 warnings,
but I have no idea how to access them. SHOW WARNINGS was only
implemented after MySQL version 4.1, and I have 4.0.15-standard-log.
Any help?
Many thanks
Mick
--
MySQL General Mailing List
For list archives: http
Hello.
Similar questions are often asked on the list, but I don't remember
any solution for old versions.
michael watson (IAH-C) [EMAIL PROTECTED] wrote:
Hi
The subject says it all! My mysqlimport command reports 43 warnings,
but I have no idea how to access them. SHOW
warnings being
generated when I import a csv file.
My ~/.my.cnf file says this:
[client]
fields-terminated-by=,
fields-enclosed-by=\
#debug=log.txt
#debug=d,info,error,query,general,where:1,load.trace
debug=warning,load.trace
Nothing I do in the 'debug' param seems
I can't seem to get ahold of the 6 warnings being
generated when I import a csv file.
My ~/.my.cnf file says this:
[client]
fields-terminated-by=,
fields-enclosed-by=\
#debug=log.txt
#debug=d,info,error,query,general,where:1,load.trace
debug=warning,load.trace
Nothing I do in the 'debug
Hi,
I got back warnings, event when started with mysql -v -v, I don't have
the Warnings appearing on the console... Do I really have to insert
SHOW WARNINGS; in the dump file after each statements ???
On Apr 7, 2005 6:10 PM, Mister Jack [EMAIL PROTECTED] wrote:
Hi !
Thanks, for your answer
Hi,
sorry for the noise, it may be useful for someone else :
cat backup20050408.sql | sed 's/INSERT/SHOW WARNINGS;INSERT/' | sed
's/CREATE/SHOW WARNINGS;CREATE/' | sed 's/DROP/SHOW WARNINGS;DROP/'
backup.sql
then use the backup.sql thus created.
So I got :Invalid TIMESTAMP value in column
Hi !
Thanks, for your answer.
Indeed, I didn't think about the verbose option. I tried it and used
tee to log data.
Well so far I haven't got anymore Warnings (strange though...) :-)
On Apr 5, 2005 9:50 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Mister Jack [EMAIL PROTECTED] wrote
Hi,
I've got a dump file from my main DB (MySQL 4.1.10a), when I load it
with source backup.sql I can see some warnings around. Is there any
way to log those warnings, or to stop on warnings ? (show warnings
only show warnings for the _last_ query if there is any).
Thanks for your help
--
MySQL
Mister Jack [EMAIL PROTECTED] wrote on 04/05/2005 01:38:00 PM:
Hi,
I've got a dump file from my main DB (MySQL 4.1.10a), when I load it
with source backup.sql I can see some warnings around. Is there any
way to log those warnings, or to stop on warnings ? (show warnings
only show warnings
On 18 Feb 2005, at 16:05, Gleb Paharenko wrote:
There is no direct way to load warnings into log files.
Just for the archives, I reported this as a bug and it's in the MySQL
bug db as having been verified, so I guess now we just hope/wait for a
fix in a later version:
http://bugs.mysql.com
Hello.
There is no direct way to load warnings into log files. But you
may use a small value for max_error_count and launch mysql in a
batch mode saving results in the file.
Marcus Bointon [EMAIL PROTECTED] wrote:
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm getting
some infrequent warnings when importing data dumps created with
mysqldump, but I can't seem to find out what the warnings are.
I'm typically importing around 100,000 records at a time, so using
'SHOW WARNINGS' manually
-Original Message-
From: Marcus Bointon [mailto:[EMAIL PROTECTED]
Sent: den 18 februari 2005 14:47
To: mysql@lists.mysql.com
Subject: log-warnings
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and
I'm getting some infrequent warnings when importing data
dumps created
even know where the problem exists. Having 100 000 different inserts
would
increase the number of tries to 11 or 12.
Well, that's exactly the kind of thing I'm trying to avoid. The hassle
is that I have 1.7 million records spread over 26 tables, with hundreds
of warnings generated when I import. I
on the latest release
(4.1.9 now)? Try only --log-warnings, without specifying the exact value.
[snip]
We are with mysql 4.0.17-log and we want to use --log-warnings to see aborted
connections
in our errorlog.
We put log_warnings = 2 in our my.cnf and restarted mysql but we did not see
aborted
We are with mysql 4.0.17-log and we want to use --log-warnings to see aborted
connections in our errorlog.
We put log_warnings = 2 in our my.cnf and restarted mysql but we did not see
aborted connections in our errorlog.
We tried --log-warnings = 2 on the command line when we started mysql
hi all...
where can i see what these warnings are. i get them when i do load data
infile.
i was looking for some kind of log under /var/logs/ or mysql/var/log but
there isn't a log file for mysql at any of those locations. and the
mysql/var/ doesn't exist at all.
i created it and redid the load
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL viewer.
J.R.
-Original Message-
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 6:53 PM
To: [EMAIL PROTECTED]
Subject: Deleted: 0 Skipped: 0 Warnings
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL
viewer.
thanks.. but from the command line i get:
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'warnings' at line 1
is mysql-standard-4.0.13
mintchev [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 7:29 PM
To: J.R. Bullington
Subject: RE: Deleted: 0 Skipped: 0 Warnings: a lot
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL
viewer.
thanks.. but from the command line i get
Deleted: 0 Skipped: 0 Warnings: 125
mysql show warnings;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'warnings' at line 1
Also, try looking under HOSTNAME.ERR instead of a log file. That might
ok... i just saw this in the manual:
This command is implemented in MySQL 4.1.0
that's why it doesn't work... mine is 4.0.13.
so what do people that have earlier versions then 4.1 do to see the
warnings?!
I have never had a problem running that command, however you do have to
run it right
In the last episode (Dec 09), kalin mintchev said:
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Command is SHOW WARNINGS;
You can run this from either the command line or from the MySQL CC SQL
viewer.
thanks.. but from the command line i get:
Check the manual that corresponds
I want to see the warnings when load data from text file using command
mysal load data local infile 'mydata.txt' into table my_table;
When I got
Query OK, 1431 rows affected, 1506 warnings (0.27 sec)
Records:1431 Deleted: 0 Skipped:0 Warnings:1506
I have to find out what cause the warnings. I
At 09:24 AM 10/26/2004, you wrote:
I want to see the warnings when load data from text file using command
mysal load data local infile 'mydata.txt' into table my_table;
When I got
Query OK, 1431 rows affected, 1506 warnings (0.27 sec)
Records:1431 Deleted: 0 Skipped:0 Warnings:1506
I have to find
Hello,
Noticed this morning when restarting MySQL, saw this in the error log file:
Version 4.0.20(RPM's)
---
040601 9:17:17 /usr/sbin/mysqld: Normal shutdown
040601 9:17:18 InnoDB: Starting shutdown...
040601 9:17:20 InnoDB: Shutdown completed
040601 9:17:20
-warnings was changed to be ON by default.
Disable with --skip-log-warnings
--end quote
Yep, it works, the warnings disappear (no surprise really...)
Unfortunately after 3-4 questions on this list about these warnings nobody
from MySQL AB seems to think it's worth giving an answer about the
seriousness
PROTECTED]
I think, this is because --log-warnings was changed to be ON by default.
Disable with --skip-log-warnings
--end quote
Yep, it works, the warnings disappear (no surprise really...)
Unfortunately after 3-4 questions on this list about these warnings nobody
from MySQL AB seems to think
Mike,
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, June 01, 2004 5:29 PM
Subject: MySQL Warnings
Hello,
Noticed this morning when restarting MySQL, saw this in the error log
file:
Version 4.0.20(RPM's)
...
Also, we
to
install. I have version 4.1 However, when I run a query that produces
warnings, I am still not able to view them. I get your typical Error
1064 for bad syntax. However, I've confirmed from mysql.com that the
syntax is correct. Any help would be appreciated.
Kathy
--
MySQL General Mailing
Hi Katherine,
Sometimes happens, unfortunately, things as this:
http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html:
Note that the framework for warnings was added in MySQL 4.1.0, at which
point many statements did not generate warnings. In 4.1.1, the situation is
much improved, with warnings
I've been to that page (http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html) and as
you said, there are supposed to be warnings now. Do you have any ideas why I can't
view them?
Kathy
Renato Cramer [EMAIL PROTECTED] 05/18/04 9:30 AM
Hi Kathy,
Excuse me for duplicity.
Renato
Craig Harding [EMAIL PROTECTED] wrote:
Using Mysql 4.0.12
I know that 'show warnings' isn't implemented until 4.1.* but is there
something else that I can do to view warnings?
You can't.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
Bryan Harris [EMAIL PROTECTED] wrote:
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset about...
You can't.
From 4.1.1 you
Bryan Harris [EMAIL PROTECTED] wrote:
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset about...
TIA.
- Bryan
--
MySQL General
Hi all,
Could you please tell me what can be causing this warnings? How can I
see them?
My Python script is dying because of this warnings :(
Since I'm using 4.0.16, I can't use SHOW WARNINGS.
Thanks in advance,
Hector
mysql create table new_web select a.* from otr_new as a join internet
as b
Héctor Villafuerte D. wrote:
Hi all,
Could you please tell me what can be causing this warnings? How can I
see them?
My Python script is dying because of this warnings :(
Since I'm using 4.0.16, I can't use SHOW WARNINGS.
Thanks in advance,
Hector
mysql create table new_web select a.* from
[EMAIL PROTECTED] wrote:
mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but nothing shows up
mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but nothing shows up there.
From version
Tuncay Baskan (Yaz.Muh.-Proje Gel.ve Uyg.Gr.) [EMAIL PROTECTED] wrote:
When I run LOAD DATA it sometimes notices that there were some warnings. For example;
mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records
When I run LOAD DATA it sometimes notices that there were some warnings. For example;
mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings
For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
5:39 PM
Subject: Re: Can't Show Warnings
For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
Thanks.
Randy
--
MySQL General Mailing List
For list archives
Randy Chrismon [EMAIL PROTECTED] wrote:
For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
You can install it from development source tree:
: 16374 Deleted: 0 Skipped: 0 Warnings: 69
mysql show warnings;
Empty set (0.00 sec)
What am I doing wrong that I can't find out what the 69 warnings are?
I'm using 4.1.0 alpha.
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
'
- ;
Query OK, 16374 rows affected (20.83 sec)
Records: 16374 Deleted: 0 Skipped: 0 Warnings: 69
mysql show warnings;
Empty set (0.00 sec)
What am I doing wrong that I can't find out what the 69 warnings are?
I'm using 4.1.0 alpha.
For LOAD DATA, it works better in 4.1.1, as indicated here:
http
]/[tablename] into [tablename]
[database].[tablename]: Records: 1780 Deleted: 0 Skipped: 39 Warnings:
1178
Disconnecting from localhost
But even with verbose on it doesn't tell me what the warnings are, or what
rows were skipped. Where can I find that information?
Thanks
J Wadsworth [EMAIL PROTECTED] wrote:
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets
At 0:52 -0400 7/30/03, J Wadsworth wrote:
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets
1 - 100 of 155 matches
Mail list logo
