I familiar with mysql on linux, as of late - ubuntu.
I am installing mysql on a mac mini, with the Lion - osx 10.7
operating system.
mysql-server was downloaded and built with macports.
Following instructions included has not resulted in a successful
startup.
I have recorded error messages, but it
Yeah, I think adjusting max packet size may be helpful, remember change that
value in both server and client
From: Johnny Withers
To: Neil Tompkins
Cc: [MySQL]
Sent: Monday, October 10, 2011 4:13 PM
Subject: Re: Fwd: Large insert query gives MySQL server gone
Max packet size?
On Oct 10, 2011 6:12 PM, "Neil Tompkins"
wrote:
> As per the subject we've a large insert query that gives up the error
MySQL server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
> As per the subject we've a large insert query that gives up the error MySQL
> server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
>>> Jessica Bela 10/10/2011 4:47 PM >>>
Hi all,
how I can import in my PC a database Mysql that has been created in another
PC and with other tools?
Assuming the source and destination are BOTH mysql databases:
mysqldump database > export.sql
...creates a file 'export.sql'. Copy it to th
.here is one way
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
On Mon, Oct 10, 2011 at 4:47 PM, Jessica Bela wrote:
> Hi all,
> how I can import in my PC a database Mysql that has been created in
> another PC and with other tools?
Hi all,
how I can import in my PC a database Mysql that has been created in another
PC and with other tools?
Your instrumentation script should be invoking "SHOW PROCESSLIST" and
parsing the status fields.
- md
On Mon, Oct 10, 2011 at 2:16 PM, Angela liu wrote:
> Hi, Folks:
>
> Have any idea how to monitor Locked queries with Nagios?
>
> Thanks
--
- michael dykman
- mdyk...@gmail.com
May the
Hi, Folks:
Have any idea how to monitor Locked queries with Nagios?
Thanks
2011/10/10 09:19 -0400, Brandon Phelps
If this column(s) is/are a character type now, then you would need to have the
values in quotes.
Note that because of implicit conversion if they had numberic values no error
would be reported, but maybe the equality would not be exact.
That query looks fine. What error are you getting if you execute the query
from the CLI? Also is it possible that the s_id or owed columns are no longer
numeric data types? If this column(s) is/are a character type now, then you
would need to have the values in quotes.
-Brandon
On 10/10/20
Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where t
> It is seems strange to me why the same command "mysql -hlocalhost
> -uxxx" when it is run from the command line, it will show an error.
> When it is run in a bash script, it runs fine. I guess this might be
> described somewhere, but I'm yet to find the answer. Does anybody know
> why this happen
13 matches
Mail list logo
