Script need for dropping databases

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

Re: Script need for dropping databases

On Fri, Nov 18, 2011 at 1:32 PM, a bv vbavbal...@gmail.com 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

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

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 MySQL

Restoring failed due to Unexpected Error

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

Re: Script need for dropping databases

Hi unknown, Have a look at database information_schema.TABLES: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='database'; 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

Re: Restoring failed due to Unexpected Error

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 that

Re: Restoring failed due to Unexpected Error

- Original Message - From: Reindl Harald h.rei...@thelounge.net 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

Re: Restoring failed due to Unexpected Error

Am 18.11.2011 14:18, schrieb Johan De Meersman: - Original Message - From: Reindl Harald h.rei...@thelounge.net 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

MySQL Community Server 5.1.60 has been released

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

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:

Re: MySQL Community Server 5.1.60 has been released

thanks On 11/18/11, Karen Langford karen.langf...@oracle.com 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

Aggregate Query

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

How often should we upgrade MySQL version

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

RE: How often should we upgrade MySQL version

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

Re: How often should we upgrade MySQL version

I love the answer On Fri, Nov 18, 2011 at 10:59 PM, Daevid Vincent dae...@daevid.com 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

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

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

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

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

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

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 f...@hotmail.com wrote: Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows

MySQL Community Server 5.5.18 has been released

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

Error on 'flush tables' command

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

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

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

Uninstall MySql Service

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: