Uninstall MySql Service

2011-11-18 Thread AndrewMcHorney
Hello I want to completely reinstall my sql server due to prior install issues. How can you uninstall the MySql service? I am running under window 7. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arc

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Bruce Ferrell
Bravo Basil! I've been looking at this all day and wondering myself. Now that I've said that.. And now for something terribly evil, is there an strace for cygwin? On 11/18/2011 03:30 PM, Basil Daoust wrote: > Maybe this is the wrong place to ask, but why would you want to do this? > Mysql has

Error on 'flush tables' command

2011-11-18 Thread Hank
I'm getting an occasional error from one of my slaves running community mysql 5.5.16: 'Got an error writing communication packets' on query. Query: 'flush tables' Which halts replication on this slave until I issue a 'SET GLOBAL sql_slave_skip_counter=1' command on the slave. There are a few FE

MySQL Community Server 5.5.18 has been released

2011-11-18 Thread Hery Ramilison
Dear MySQL users, MySQL 5.5.18 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.18 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL D

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Basil Daoust
Maybe this is the wrong place to ask, but why would you want to do this? Mysql has binaries for Windows, just use one of them? On Fri, Nov 18, 2011 at 4:16 PM, Franck Houssen wrote: > > Hello mysql-list, > > I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows > 7 using Cyg

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Reindl Harald
Am 18.11.2011 23:16, schrieb Franck Houssen: > $ mysql -u dummy -p (when I type a real password : dummy, YES... or anything > else) > ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using > password: YES) and if you submit the same post every day you will get the same anser as

Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Franck Houssen
Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows 7 using Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any password th

Re: How often should we upgrade MySQL version

2011-11-18 Thread muad shibani
I love the answer On Fri, Nov 18, 2011 at 10:59 PM, Daevid Vincent wrote: > Ever heard the old saying, "If it ain't broke, don't fix it." ;-) > > I'd say that as a general rule: > > 1. if you aren't experiencing problems then don't upgrade. > 2. if you aren't subject to any vulnerabilities that

RE: How often should we upgrade MySQL version

2011-11-18 Thread Daevid Vincent
Ever heard the old saying, "If it ain't broke, don't fix it." ;-) I'd say that as a general rule: 1. if you aren't experiencing problems then don't upgrade. 2. if you aren't subject to any vulnerabilities that may be found, then don't upgrade 3. if you don't need a new feature introduced, then do

How often should we upgrade MySQL version

2011-11-18 Thread Neil Tompkins
We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL Genera

Aggregate Query

2011-11-18 Thread Nigel Peck
Hi all, Could do with some help please. I have a query that grabs details of items that have been ordered from an ecommerce site. Order details are in "tracking" and ordered items in "trackitem". The query works fine and generates a row for each item, including bits of info retrieved from

Re: MySQL Community Server 5.1.60 has been released

2011-11-18 Thread hu dai
thanks On 11/18/11, Karen Langford wrote: > Dear MySQL users, > > MySQL Server 5.1.60, a new version of the popular Open Source > Database Management System, has been released. MySQL 5.1.60 is > recommended for use on production systems. > > For an overview of what's new in MySQL 5.1, please see

RE: ibdata1 and undo log

2011-11-18 Thread Rozeboom, Kay [DAS]
Thanks for the response, Johan. It would really help if I could determine when the ballooning is occurring. Do you know of any way to do that? -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, November 17, 2011 1:28 AM To: Rozeboom, Kay [DAS] Cc: m

MySQL Community Server 5.1.60 has been released

2011-11-18 Thread Karen Langford
Dear MySQL users, MySQL Server 5.1.60, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.60 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysql-nutsh

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Reindl Harald
Am 18.11.2011 14:18, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> but anyways, the message sounds like a damaged compressed file > > Looks more like he's got an HTML file instead of an SQL file, to me. > > Have a look inside the file, maybe the HTML

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > but anyways, the message sounds like a damaged compressed file Looks more like he's got an HTML file instead of an SQL file, to me. Have a look inside the file, maybe the HTML is just a wrapper or something. How was the backup taken ? -

Re: Restoring failed due to Unexpected Error

2011-11-18 Thread Reindl Harald
Am 18.11.2011 12:41, schrieb Adarsh Sharma: > But when I restore the data below error exists :- > > [root@test1 hdd2-1]# gunzip < source.sql.gz | mysql test > > gunzip: stdin: unexpected end of file > ERROR 1064 (42000) at line 30309: You have an error in your SQL syntax; check > the manual th

Re: Script need for dropping databases

2011-11-18 Thread Nuno Tavares
Hi , Have a look at database information_schema.TABLES: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=''; As long as your MySQL version is >= 5.1, you don't need a cron script, you can use the MySQL scheduler, create a stored procedure that will run each month. You'll need to use pr

Restoring failed due to Unexpected Error

2011-11-18 Thread Adarsh Sharma
Dear all, Today i need to restore the backup of a 40GB table in a new system. I create a script that takes the backup in compressed format ( 2.3 GB ).The existing hard disk crashes & I need to restore my data. But when I restore the data below error exists :- [root@test1 hdd2-1]# gunzip < sou

Re: how do I make utf8 the default encoding for my MySQL installation

2011-11-18 Thread Reindl Harald
Am 18.11.2011 04:31, schrieb Martin Mueller: > [mysqld] > init_connect=’SET collation_connection = utf8_general_ci’ > init_connect=’SET NAMES utf8′ > default-character-set=utf8 > character-set-server=utf8 > collation-server=utf8_general_ci > skip-character-set-client-handshake > On a Mac with My

Re: Script need for dropping databases

2011-11-18 Thread Mohan L
On Fri, Nov 18, 2011 at 1:32 PM, a bv wrote: > Hi, > I have a linux box running mysql plus phpmyadmin which has tables > getting montly data and when a new month starts a new table is > created. I want to store only 2 years of data so when a new month > starts i need to drop the table which b

Script need for dropping databases

2011-11-18 Thread a bv
Hi, I have a linux box running mysql plus phpmyadmin which has tables getting montly data and when a new month starts a new table is created. I want to store only 2 years of data so when a new month starts i need to drop the table which became the data container of 2 years previous data. So to