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 c
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 List
hing including
> >> bad queries (eg. select fark from fark from fark fark fark from frak).
> >> You should be able to write a JSON parser that extracts what you want
> >> based on the log (eg. STATUS, COMMAND, NAME).
> >>
> >> On Wed, Jun 24, 2015 at 11:05
from frak).
>> You should be able to write a JSON parser that extracts what you want
>> based on the log (eg. STATUS, COMMAND, NAME).
>>
>> On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman
>> wrote:
>>
>> -
>>>
>>
at 11:05 AM, Johan De Meersman
wrote:
-
FROM: "Singer X.J. Wang"
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 cap
(eg. STATUS, COMMAND, NAME).
On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman
wrote:
>
> --
>
> *From: *"Singer X.J. Wang"
> *Subject: *Re: server-side logging of query errors?
>
> You could log all queries using the audit plugin, 1
> From: "Singer X.J. Wang"
> 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 thro
You could log all queries using the audit plugin, 15% hit..
On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman
wrote:
> - Original Message -
> > From: "Tomasz Chmielewski"
>
> >> It would be a mild security risk; a malicious
> >> (or just stupid, see Hanlon's razor) user could spam your
- Original Message -
> From: "Tomasz Chmielewski"
>> 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 until s
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 ri
he proxies out there has support for such logging, I'm not really
familiar with any of them.
- Original Message -
> From: "Tomasz Chmielewski"
> To: "MySql"
> Sent: Tuesday, 23 June, 2015 09:35:46
> Subject: server-side logging of query errors?
&
?
According 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
2013/2/14 Robert Citek
>
>
> 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 promise not to
>
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.
Regard
2013/2/13 Robert Citek
> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> 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 i
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 wrote:
> Are you using all InnoDB?
>
> S
--
MySQL General Ma
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui wrote:
> 2013/2/13 Robert Citek
>>
>> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>> wrote:
>> > Any other possibilities? Do other scenarios become likely if there
>> > are two or more tables?
>> >
>> > Of those, which are the most likely?
>>
On Thu, Feb 14, 2013 at 5:46 PM, Rick James 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.
Regards,
- Rober
Are you using all InnoDB?
S
On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek wrote:
> On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui
> wrote:
> > 2013/2/13 Robert Citek
> >>
> >> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> >> wrote:
> >> > Any other possibilities? Do other scenarios bec
ysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
>
> 2013/2/13 Robert Citek
>
> > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>
> > wrote:
> > > Any other possibilities? Do other scenarios become likely if there
> &
ursday, February 14, 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
> wrote:
> >> Is it in read only mode?
> > Furthermore, are all users logg
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek 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 not from the point
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 wrote:
> I am running debian with mysql 5.1
> I am running the backup command like this :
>
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
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 MySQ
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
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 sc
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/
: 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
fully 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 h
> > >
> > >-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
> > >
> > &
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.
> >
> >
> >
>
Wed, Jun 2, 2010 at 2:22 PM, Jerry Schwartz 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
>-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 ex
: 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 of
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)
t; - michael dykman
>>
>> On Wed, Apr 28, 2010 at 4:34 PM, Zardosht Kasheff wrote:
>>> I am using Visual Studio 2008. I run "win\configure" followed by
>>> "win\build_vs9_x64.bat", and then open the generated MySQL.sln from
>>> Visual
;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 wrote:
>>> What compile
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 wrote:
>> What compiler are you us
I was told I should ask this on this list.
Any ideas?
Thanks
-Zardosht
-- Forwarded message --
From: Zardosht Kasheff
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 this is a win32 list, but I
IN(SELECT...) is abysmally slow. For alternatives see "The
unbearable slowness 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
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...
This is a
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
nection 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
nded 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
g
the connection... don't know what 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]>
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 database [Lost connection to MySQL server during
query]&#
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
>
> - Original Message -
> *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
ne 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,
I am running mysqldump with --no-data option, but it gives error:
"can't e
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) (2
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: 6
Hi
I am running the command on Gentoo OS
/usr/bin/rsync -avO /var/lib/mysql [EMAIL PROTECTED]:/var/lib/ >
/tmp/rsync-${TIMESTAMP}.log 2>&1
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
ue.
>
If you aren't observing any 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 ap
L PROTECTED];
[EMAIL 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
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 proba
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.
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,
Krish
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,
Praja
1
To: mysql@lists.mysql.com
Subject: 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 Chec
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
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 sla
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
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 G
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-tf45
inlog 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
spoo
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
t's no excuse 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
Subje
cture
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
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
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: http://bugs.mysql.c
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%22&hl=en&start=90&sa=N
>
> you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
Ironically 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 occurr
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 connect
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 ho
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 serve
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
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
libmysql
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 is
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
e 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 MyS
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 My
se activity),
> the clients are receiving "Error 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
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
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 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,
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 th
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
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 s
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 th
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 p
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 her
--
I have tried to compile the MySQL 5.0.27 source code with the same settings used
to compile 5.1.14, but it fails as well.
I have also tried to use the BUILD/compile-ia64-debug-max but I get the same
set of errors.
Could you please
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 tha
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 right
1 - 100 of 709 matches
Mail list logo
