Initial install instructions for mac lion/macports
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 may suffice if I were pointed to initial setup instructions for Mac Lion. So far, google has not edified me. TIA -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fwd: Large insert query gives MySQL server gone away
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 away 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 unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
Re: Fwd: Large insert query gives MySQL server gone away
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 unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
Fwd: Large insert query gives MySQL server gone away
> 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
Re: import database
>>> 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 the target pc, then on the target mysql < export.sql If the source database is something OTHER than MySQL, we'd need to know what that database is. CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addressee only, and its contents may be legally privileged or confidential. If the reader of this message is not the intended recipient, you are hereby notified that any distribution, dissemination, or copy of this message is strictly prohibited. If you have received this message in error, please delete it immediately and notify the sender. This message is not intended to be an electronic signature nor to constitute an agreement of any kind under applicable law unless otherwise expressly indicated herein.
Re: import database
.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?
import database
Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools?
Re: Monitor Locked query
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 Source be with you.
Monitor Locked query
Hi, Folks: Have any idea how to monitor Locked queries with Nagios? Thanks
Re: Weird UPDATE Problem
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Weird UPDATE Problem
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/2011 09:14 AM, D. Marshall Lemcoe Jr. wrote: 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 table_name was mysql_real_escape_string("collection_41_students"). With the new MySQL version, the UPDATE query does not work, and echo mysql_error(); results nothing. Is my syntax correct going from version to version? Thanks in advance, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Weird UPDATE Problem
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 table_name was mysql_real_escape_string("collection_41_students"). With the new MySQL version, the UPDATE query does not work, and echo mysql_error(); results nothing. Is my syntax correct going from version to version? Thanks in advance, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Why the same command have different results when it is in a bash script and when it is not?
> 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 happens and how to make the command line version working? > > ~$ mysql -hlocalhost -uxxx > ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using > password: YES) > ~$ cat `which mysqllocalhostxxx.sh ` > #!/usr/bin/env bash > > mysql -hlocalhost -uxxx > ~$ mysqllocalhostxxx.sh > Welcome to the MySQL monitor. Commands end with ; or \g. What does 'which mysql' give you? Is it perhaps in 'alias -p'? And is there perhaps a .my.cnf file in your users directory? -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org