On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote:
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
-bill
--
MySQL General Mailing
based on the log (eg. STATUS, COMMAND, NAME).
On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman
vegiv...@tuxera.be wrote:
-
FROM: Singer X.J. Wang w...@singerwang.com
SUBJECT: Re: server-side logging of query errors?
You could log all queries
From: Singer X.J. Wang w...@singerwang.com
Subject: Re: server-side logging of query errors?
You could log all queries using the audit plugin, 15% hit..
Fair point, though: maybe one of the different audit plugins has the capability
to specifically log faulty requests. Have a look through
(eg. STATUS, COMMAND, NAME).
On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
--
*From: *Singer X.J. Wang w...@singerwang.com
*Subject: *Re: server-side logging of query errors?
You could log all queries using the audit plugin, 15% hit
errors?
You could log all queries using the audit plugin, 15% hit..
Fair point, though: maybe one of the different audit plugins has
the capability to specifically log faulty requests. Have a look
through the slides from Percona Live London 2014, there was a talk
about auditing
at 11:05 AM, Johan De Meersman
vegiv...@tuxera.be wrote:
-
FROM: Singer X.J. Wang w...@singerwang.com
SUBJECT: Re: server-side logging of query errors?
You could log all queries using the audit plugin, 15% hit..
Fair point, though: maybe one of the different audit
You could log all queries using the audit plugin, 15% hit..
On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: Tomasz Chmielewski man...@wpkg.org
It would be a mild security risk; a malicious
(or just stupid, see Hanlon's
to the documentation:
http://dev.mysql.com/doc/refman/5.5/en/server-logs.html
- Error log - will only log mysqld errors - so, it won't log syntax
errors in the query
- General query log - it will log all queries, but without indicating
if it was an error or not
Is there a way to log query
out there has support for such logging, I'm not really
familiar with any of them.
- Original Message -
From: Tomasz Chmielewski man...@wpkg.org
To: MySql mysql@lists.mysql.com
Sent: Tuesday, 23 June, 2015 09:35:46
Subject: server-side logging of query errors?
Suppose I run a query
On 2015-06-23 17:29, Johan De Meersman wrote:
None that I'm aware of.
It's a pity!
This could ease debugging in many cases, without the need to change the
client (i.e. PHP/Perl/Python code which sends the queries, and we
suspect that some of them are bogus).
It would be a mild security
- Original Message -
From: Tomasz Chmielewski man...@wpkg.org
It would be a mild security risk; a malicious
(or just stupid, see Hanlon's razor) user could spam your server with
malformed requests until the logging disk runs full, at which point
the daemon would suspend operations
2013/2/14 Robert Citek robert.ci...@gmail.com
According to the client, nothing is writing to the slave and
everything is being logged at the master. I have not had the
opportunity to independently verified any of this, yet. I do know
that the slave is not in read-only mode, but rather we
, 2013 2:59 PM
To: Rick James
Cc: mysql
Subject: Re: slave replication with lots of 'duplicate entry' errors
On Thu, Feb 14, 2013 at 5:46 PM, Rick James rja...@yahoo-inc.com
wrote:
Is it in read only mode?
Furthermore, are all users logging in as non-SUPER users? Note:
root bypasses
replication with lots of 'duplicate entry' errors
2013/2/13 Robert Citek robert.ci...@gmail.com
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
robert.ci...@gmail.com
wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables?
Of those
Are you using all InnoDB?
S
On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek robert.ci...@gmail.comwrote:
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui man...@tuenti.com
wrote:
2013/2/13 Robert Citek robert.ci...@gmail.com
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
On Thu, Feb 14, 2013 at 5:46 PM, Rick James rja...@yahoo-inc.com wrote:
Is it in read only mode?
Furthermore, are all users logging in as non-SUPER users? Note: root
bypasses the readonly flag!
No. The user that is commonly used does have Super privileges. I am
not sure why, but it does.
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui man...@tuenti.com wrote:
2013/2/13 Robert Citek robert.ci...@gmail.com
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek robert.ci...@gmail.com
wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables?
Yes. Except for a handful of static MyISAM tables. But the tables
that are experiencing the issues are all InnoDB and large (a dozen or
so fields, but lots of records.)
Regards,
- Robert
On Thu, Feb 14, 2013 at 5:59 PM, Singer Wang w...@singerwang.com wrote:
Are you using all InnoDB?
S
--
2013/2/13 Robert Citek robert.ci...@gmail.com
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek robert.ci...@gmail.com
wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables?
Of those, which are the most likely?
[from off-list responder]:
Other
Agreed. Will do that along with several other possible changes. But
for the moment, I'm still gathering information and coming up with
plausible models.
Will also be turning on general mysql logging on both Master and
Slave, at least briefly, to see what statements are being run on both.
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek robert.ci...@gmail.com wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables?
Of those, which are the most likely?
[from off-list responder]:
Other possibility: The replication is reading from master
I am running debian with mysql 5.1
I am running the backup command like this :
innobackupex --user=root --password=pass --stream=tar .^C| bzip2 -
./xtra/052912backup.tar.bz2
and doing the restore command like this in the /var/lib/mysql directory:
tar -xvif ./xtra/052912backup.tar.bz2
and then i
after untaring (or aftering runing the backing) you need to run the
apply-log option:
http://www.percona.com/doc/percona-xtrabackup/howtos/recipes_ibkx_local.html
On Sun, Jun 3, 2012 at 4:19 PM, Joey L mjh2...@gmail.com wrote:
I am running debian with mysql 5.1
I am running the backup
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQL
5.1.41. For example, this is a simple
2011/12/27 18:13 +, Mark Haney
So, what the heck is going on here? I'm at the end of my wits.
I suspect that you have to make the block delimiter something other than
semicolon, and set the block in a routine or trigger.
Semicolon terminates SQL routine statements, after PL1. If the
On 12/27/2011 12:13 PM, Mark Haney wrote:
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on
Hi,
I have the following table and sql commands. The number of fields in
the file is different from that of the schema. And the last line
should not contain null. But there are only warnings but not errors
generated. I'm wondering how to generate errors instead of warnings.
~/linux/test/mysql
copied?
2) When the file is copied and parsed?
3) When the file is completely processed?
I'm guessing 2).
The reason for asking is to determine what errors may be returned and
how I can deal with them.
Is it possible for the file to be partially processed, say, inserting
the first half
: Monday, October 25, 2010 12:16 PM
To: mysql@lists.mysql.com
Subject: Load Data Infile Errors
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point
Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one of
our clients' servers I came across some strange behaviour from the slave
server. (two servers setup in master / slave replication)
: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: 02 June 2010 9:41 AM
To: mysql@lists.mysql.com
Subject: Strange errors / messages on slave server
Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one
-Original Message-
From: machiel.richards [mailto:machiel.richa...@gmail.com]
Sent: Wednesday, June 02, 2010 3:56 AM
To: mysql@lists.mysql.com
Subject: RE: Strange errors / messages on slave server
Hi All
Just one other note on this issue experienced.
I used google to try
?
On Wed, Jun 2, 2010 at 2:22 PM, Jerry Schwartz je...@gii.co.jp wrote:
-Original Message-
From: machiel.richards [mailto:machiel.richa...@gmail.com]
Sent: Wednesday, June 02, 2010 3:56 AM
To: mysql@lists.mysql.com
Subject: RE: Strange errors / messages on slave server
Hi All
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
Machiel Richards
-Original Message-
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: 02 June 2010 9:41 AM
To: mysql@lists.mysql.com
Subject: Strange errors / messages on slave server
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
Machiel Richards
-Original Message-
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: 02 June 2010 9:41 AM
To: mysql@lists.mysql.com
Subject: Strange errors / messages on slave server
Good day
I was told I should ask this on this list.
Any ideas?
Thanks
-Zardosht
-- Forwarded message --
From: Zardosht Kasheff zardo...@gmail.com
Date: Fri, Apr 23, 2010 at 9:01 PM
Subject: compiling errors on mysql 5.1.46 on win64
To: wi...@lists.mysql.com
Hello all,
I know
run win\configure followed by
win\build_vs9_x64.bat, and then open the generated MySQL.sln from
Visual Studio 2008. Do Build-Build Solution, and I get the errors
On Wed, Apr 28, 2010 at 4:31 PM, Michael Dykman mdyk...@gmail.com wrote:
What compiler are you using? Is this being done via a make
from
Visual Studio 2008. Do Build-Build Solution, and I get the errors
On Wed, Apr 28, 2010 at 4:31 PM, Michael Dykman mdyk...@gmail.com wrote:
What compiler are you using? Is this being done via a make file or
are you just trying to compile from a default MS Developer Studio?
On Wed, Apr 28
the generated MySQL.sln from
Visual Studio 2008. Do Build-Build Solution, and I get the errors
On Wed, Apr 28, 2010 at 4:31 PM, Michael Dykman mdyk...@gmail.com wrote:
What compiler are you using? Is this being done via a make file or
are you just trying to compile from a default MS Developer
Hi, I have several procedures that I have taken from an old Microsoft
database, and I have tired to use them in a MySQL 5.1.32 database, but
I am getting errors when trying to input them. There are three in
total that I am struggling with and would appreciate some guidance
of IN() at
http://www.artfulsoftware.com/infotree/queries.php.
PB
-
Matthew Stuart wrote:
Hi, I have several procedures that I have taken from an old Microsoft
database, and I have tired to use them in a MySQL 5.1.32 database, but
I am getting errors when trying to input them
Hi Baron,
If, I have started mysql server with --slave-skip-errors=1048 then this
error will be logged into mysql error file or not.
Thanks,
Prajapati
Krishna Chandra Prajapati
--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road
Hi,
If, I have started mysql server with --slave-skip-errors=1048 then this
error will be logged into mysql error file or not.
Thanks,
Prajapati
Krishna Chandra Prajapati
How can I remove a table space from the internal data dictionary? The
documentation doesn't help at all.
Even after a fresh installation and importing all dumps of the databases
from scratch, I get these errors:
Attempting backtrace. You can use the following information to find out
where
ended up
using connection pooling and now the number of connections reaches a high of
around 10 and I haven't had the problem since.
Mike
On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue [EMAIL PROTECTED] wrote:
We've started seeing mysql errors in the logs, and when i look at the
output
We've started seeing mysql errors in the logs, and when i look at the output
of mysql_error() (in php), i get lost connection to mysql server during
query. Here's an example stack trace:
'Can't connect to name database [Lost connection to MySQL server during
query]'
Similarly, we're seeing stack
your setup is. Another long shot in
a multi-db-server config would be to make sure they all have different
server ID's.
Good luck... hopefully someone else has better advice :)
Jake
On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue [EMAIL PROTECTED] wrote:
We've started seeing mysql errors in the logs
of connections reaches a high
of around 10 and I haven't had the problem since.
Mike
On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue [EMAIL PROTECTED] wrote:
We've started seeing mysql errors in the logs, and when i look at the
output
of mysql_error() (in php), i get lost connection to mysql
Hi !
Jittinan Suwanrueangsri wrote:
Hi all
If you know how to fix these problems please tell me.
System details
1.OS=Linux localhost.localdomain 2.6.25-14.fc9.i686 #1 SMP Thu May 1
06:28:41 EDT 2008 i686 i686 i386 GNU/Linux
2.tar = tar (GNU tar) 1.19
3.gcc =gcc (GCC) 4.3.0 20080428 (Red Hat
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)
perror 24 says: too many open files
perror 23 says: too many open files in system
mySQL show variables says: open_files_limit:
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)
, 2008 12:20 PM
Subject: Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from
:* Moon's Father [EMAIL PROTECTED]
*To:* [EMAIL PROTECTED]
*Cc:* mysql@lists.mysql.com
*Sent:* Saturday, June 21, 2008 12:20 PM
*Subject:* Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All
Hi
I am running the command on Gentoo OS
/usr/bin/rsync -avO /var/lib/mysql [EMAIL PROTECTED]:/var/lib/
/tmp/rsync-${TIMESTAMP}.log 21
I am getting the below error in the log file
mysql/
rsync: failed to set permissions on /var/lib/mysql: Operation not
permitted (1)
rsync: failed to open
Perl is being used for scripting
On Tue, Feb 26, 2008 at 3:44 PM, Vincent Bray [EMAIL PROTECTED] wrote:
On 26/02/2008, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
My web server log error is NULL::dba can't connect to mysql
This isn't an apache error; at a guess, it's probably a PHP
PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Apache log errors
Hi All,
My web server log error is NULL::dba can't
issues with your application and your
application is open to the internet, it is not unlikely that those
errors are being caused my someone on the outside attempting
SQL-injection against your site (and apparently failing).
If it is feasible, check your apache access.log for the same timestamp
as you
Hi All,
My web server log error is NULL::dba can't connect to mysql
The above error shows occasionally in the error log file of apache. Every
thing is fine on the mysql database server. It happens twice or thrice a
day. I am not able to find out whats the issue.
Please help me.
Thanks,
Hi All,
My web server log error is NULL::dba can't connect to mysql
The above error shows occasionally in the error log file of apache. Every
thing is fine on the mysql database server. It happens twice or thrice a
day. I am not able to find out whats the issue.
Please help me.
Thanks,
Krishna Chandra Prajapati 写道:
Hi All,
My web server log error is NULL::dba can't connect to mysql
The above error shows occasionally in the error log file of apache. Every
thing is fine on the mysql database server. It happens twice or thrice a
day. I am not able to find out whats the issue.
ERROR, REPAIR could not execute
Checking information_schema:USER_PRIVILEGES
Checking information_schema:VIEWS
ERROR, REPAIR could not execute
Oops! How can I fix these information_schema errors?? I ran a full:
/usr/local/bin/myisamchk --force --extend-check --update-state -O
: information_schema errors after (minor) upgrade
Running a FreeBSD system and mysql 5.0.27 server, I recently upgraded to
5.0.51 (but kept the 5.0.27 client). Everything seemed fine, until I ran a
databse check today:
Checking information_schema:CHARACTER_SETS Checking
information_schema:COLLATIONS Checking
bruce wrote:
hi..
doing a simple test of master/slave replication, using mysql.
i have two test systems:
master - foo (192.168.10.13)
slave - cat (192.168.20.20)
on both machines, i created a testmasterdb. on the master, i populated the
tbl within the db with some test data. there are no
hi..
doing a simple test of master/slave replication, using mysql.
i have two test systems:
master - foo (192.168.10.13)
slave - cat (192.168.20.20)
on both machines, i created a testmasterdb. on the master, i populated the
tbl within the db with some test data. there are no tbls in the
cannot ping the connection the first time, destroy the connection and
report Connection lost to MySQL Server due to Network Errors.
If you get an errored network packet, then ping your connection a 2nd time to
test it to verify you still have the connection. Then report back to the client
Network
Hi All,
I have this question...
I send a INSERT from client to server, the server write the row and send
the result ok
to the client. Due to a network failure the client doesn't receive the
result and an error is reported to the user.
How can I manage this error?
--
Ciao
Mirko
--
MySQL
for the right syntax to use near 'CONSTRAINT
FK_WorksOn_Users FOREIGN KEY
(
UserID
) REFERENCES TimeTracke' at line 8
what to do if this error comes plz anyone help me
--
View this message in context:
http://www.nabble.com/errors-in-mysql-syntax-tf4532650.html
This seems to be a frequent occurrence:
[EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in
binary log', data_len: 94, event_type: 15
Could not read entry at offset 4:Error
American Home Mortgage
w: 631-622-6382
c: 516-652-2475
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 11:33 AM
To: John Mancuso
Subject: Re: Binlog errors
Not that any ideas are jumping out at me but what file system are you
employing here
to corrupt all the binlogs
John Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 11:33 AM
To: John Mancuso
Subject: Re: Binlog errors
Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 12:04 PM
To: John Mancuso
Cc: mysql@lists.mysql.com
Subject: Re: Binlog errors
Do
errors
Not that any ideas are jumping out at me but what file system are you
employing here? and what types of MySQL tables are you using? I note
from the listing above that you seem to be taking extremely high
volumn
(1G in barely over 3 hours on a couple occasions). It seems a bit
spooky to me
On Thu, May 10, 2007 at 05:17:12PM +0100, Jon Ribbens wrote:
I suspect some sort of bug in the MySQLd authentication code.
I've managed to discover using --debug that it's due to MySQLd failing
to handle EINTR from read() in the authentication stage.
I've filed a bug report:
On Thu, May 10, 2007 at 03:37:26AM +0100, Jon Ribbens wrote:
I've just upgraded all the clients and servers to 5.0.41 (which looks
like it just came out); I'll see what happens.
It hasn't solved the problem, but it has changed the error message to:
OperationalError:
(2013, Lost
these errors were caught by the google indexing engine when the
site failed to display the HTML page, so it got the error message instead.
If you click on the link today, the error of course is gone. But if you
click on the cache link, you'll see the same error message as it occurred
(frozen in time
On Thu, May 10, 2007 at 08:58:37AM -0600, mos wrote:
If you do a google search:
http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N
you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
Maybe
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4,
and the MySQL-python-1.2.1_p2 connector.
We are getting intermittent mysterious errors as follows:
OperationalError:
(2013, 'Lost connection to MySQL server during query')
when attempting to connect to the MySQL server
the
problem.
On 5/9/07, Jon Ribbens [EMAIL PROTECTED] wrote:
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4,
and the MySQL-python-1.2.1_p2 connector.
We are getting intermittent mysterious errors as follows:
OperationalError:
(2013, 'Lost connection to MySQL server during query
On Wed, May 09, 2007 at 09:22:34AM -0400, Michael Dykman wrote:
I realize that's quite unlikely that you have performed a similar
sloppy import but there is likely some edge condition on your server
(wierd permissions in the data directory, corruoted tables, etc.)
but I still recommend that
When we first examined our server logs, we saw the same.. in our case
(again) it was only when we slowed down and examined the timestamps on
the start/stop messages that we realized that the server was
restarting at unexpected intervals. Over the course of our
development, we came across this
We also have random lost connections on simple queries, but we are running
MySQL v5.024a on Windows XP. We've checked the logs and nothing abnormal
has turned up and we're using only MyISAM tables with InnoDb disabled.
The only thing that I could suggest is to look for other copies of
On Wed, May 09, 2007 at 11:17:59AM -0400, Michael Dykman wrote:
When we first examined our server logs, we saw the same.. in our case
(again) it was only when we slowed down and examined the timestamps on
the start/stop messages that we realized that the server was
restarting at unexpected
Jon Ribbens a écrit :
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4,
and the MySQL-python-1.2.1_p2 connector.
We are getting intermittent mysterious errors as follows:
OperationalError:
(2013, 'Lost connection to MySQL server during query')
when attempting
On Wed, May 09, 2007 at 10:07:41PM -0400, Mathieu Bruneau wrote:
We found a similar issue because we were using persistent connection in
php and had a firewall between the mysql and the webserver. The problem
is that our persistent connection were setup for lasting up to something
like 8 hours
12 errors and the MySQL log has a lot
of errors as follows,
070327 8:24:20 [ERROR] mysql_ha_read: Got error 12 when reading table
'XLDEFN_IN'
070327 8:54:51 [ERROR] mysql_ha_read: Got error 12 when reading table
'XLDEFN_IN'
070327 8:55:19 [ERROR] mysql_ha_read: Got error 12 when reading
Hi,
I have a HP rp3410 with 4Gb RAM running HPUX 11.11. This is running,
Version: '5.0.26-pro-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
Pro (Commercial)
When this machine is put under load (i.e, a lot of database activity),
the clients are receiving Error 12 errors and the MySQL log
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL v5
installation and getting an SQL error in the process.
I am using the following command to dump the data in the v4 installation:
mysqldump -u root --password=secret --add-drop-table --databases db1
db2 db3 db4 db5 db6
The 'group' column needs to be quoted (use --quote-names with mysqldump).
cheers,
--bemansell
On 3/26/07, Rob Tanner [EMAIL PROTECTED] wrote:
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL v5
installation and getting an SQL error in the process.
I am using the
group is a reserved word, so MySQL thinks you're attempting a 'group
by' statement. Put backticks around group, you should always quote your
table and column names.
DROP TABLE IF EXISTS `admission_quotes`;
CREATE TABLE `admission_quotes` (
`id` int(4) NOT NULL auto_increment,
`quote` text,
Use --allow-keywords option with mysqldump command
Anil
-Original Message-
From: Brian Mansell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:18 PM
To: Rob Tanner
Cc: mysql@lists.mysql.com
Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5
The 'group
On 14.02.2007 08:00 CE(S)T, Colin Charles wrote:
The MySQL 5.0 release is available as a binary and is currently at
5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads
I read in the news some time ago that MySQL 5.0 is only going to be
available as source version in the
Yves Goergen wrote:
On 14.02.2007 08:00 CE(S)T, Colin Charles wrote:
The MySQL 5.0 release is available as a binary and is currently at
5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads
I read in the news some time ago that MySQL 5.0 is only going to be
available as
Yves Goergen wrote:
Hello,
I noticed that the current MySQL 5.0 release is not available as binary,
so I downloaded the source and compiled it on my testing machine.
Compilation went fine and I can connect to the new MySQL server version.
But then I tried to run the mysql_upgrade script to fix
On 10.02.2007 17:39 CE(S)T, Yves Goergen wrote:
ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
(and some more similar stuff)
As I found out I already asked that on a previous upgrade. Other sources
make me think that this is not an actual error but intended if the
tables are
Hello,
I noticed that the current MySQL 5.0 release is not available as binary,
so I downloaded the source and compiled it on my testing machine.
Compilation went fine and I can connect to the new MySQL server version.
But then I tried to run the mysql_upgrade script to fix possible issues
and
.
I have also tried to use the BUILD/compile-ia64-debug-max but I get the same
set of errors.
Could you please help ?
Which are the compilation, linking options used to produce the binary version
of MySQL 5.0.27 for Linux IA64 (using Intel icc and gcc), available at
http://dev.mysql.com/downloads
The first time I tried to run the mysqlhotcopy script, I got an error
that indicated that Perl couldn't find the DBI module.
So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that
stepped me through making and installing
MySQL DBD and the DBI modules(? don't know if I'm using the
DBD::mysqlPP is the pure Perl driver for DBI. Is there a reason you are
using that instead of DBD::mysql? I haven't done Perl/MySQL on OS X
before but on other platforms (and from the error you're getting here)
DBD::mysql is the typical driver for using DBI with MySQL. It also is
the driver
1 - 100 of 682 matches
Mail list logo