Re: MySQL Daylight Savings Time Patch

2007-02-23 Thread Ryan Stille
Ryan Stille wrote: Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At least the tim

Re: MySQL Daylight Savings Time Patch

2007-02-23 Thread Ryan Stille
Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At least the time_zone_name and tim

InnoDB: Assertion failure

2007-02-23 Thread M.
Hi. a few days ago, i posted and error mysql, and now i am getting this one: The machine has: 2 CPU Pentium III 700 Mhz Aprox. 4 GB RAM. Redhat 7.2 Mysql version: 4.0.14-standard-log Kernel: Kernel 2.4.18-17.7 (highmem) i`ve searching in google, and i found this king of logs so many times, but

columns_priv : how it works ? [ MySQL 4.1 ]

2007-02-23 Thread Gilles MISSONNIER
hello, There is something I obviously missed, can't figure out what, since it seems so simple. as user root (of mysql), mysql> use mysql; I can see : mysql> select * from columns_priv where User='demandeur' order by Column_name; and I get : +--+---+--+---+-

Re: Restore Question

2007-02-23 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], [EMAIL PROTECTED] <[EMAIL PROTECTED]> typed: > After creating a new mysql db from the script, should I have first > restored the old mysql database, then the user databases? You should first restore mysql database just to be on the safe side, but I don't think the imp

Re: copy data from prod to test - when database name is not the same name

2007-02-23 Thread Rolando Edwards
mysql -h... -u... -p... -e"CREATE DATABASE IF NOT EXISTS mysql_TEST;" mysqldump -h... -u... -p... --routines --triggers Mysql_prod | mysql -h... -u... -p... -Dmysql_TEST - Original Message - From: "Charles Brown" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, February 23, 200

copy data from prod to test - when database name is not the same name

2007-02-23 Thread Brown, Charles
Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test. Th

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-23 Thread mos
Jim, At 01:58 AM 2/23/2007, Jim Winstead wrote: On Thu, Feb 22, 2007 at 11:33:47PM -0600, mos wrote: > That's just one guy's opinion. :) And quite misinformed, unfortunately. The pricing is what I am getting off of your web site. So if I am misinformed, then it is MySQL AB that is misinformi

Restore Question

2007-02-23 Thread ddevaudreuil
We're in the process of changing our InnoDB databases to file-per-table. I started last night with our test server. It went pretty smoothly, except for one stupid mistake on my part. I backed up all databases, deleted he data and log files, re-created the MySQL database from the script, then

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-23 Thread Raul Andres Duque
Why you always talk about *client* fee ?? what about the server? Sincerily, I'm see MySQL is not the best option for a commercial application (you don´t distribute you application with GPL lincense). Postgresql is a excellent DB using BSD license and the last version improve the speed reponse.

Re: backup stratergy

2007-02-23 Thread Ananda Kumar
Hi Juan, Thanks a lot for the quick reply. Any idea how much it would cost for ibbackup for innodb. Will mysql be providing this with any of their new release. regards anandkl On 2/23/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Ananda, For Innodb the best is Innodb Hot Backup ( www.i

Re: backup stratergy

2007-02-23 Thread Juan Eduardo Moreno
Ananda, For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) ) For MyISAM you can use a simple backup ( copy/paste) of your files. Also, you can do snapshots using mysqldump. Also, you can use Zmanda ( www.zmanda.com). Regards, Juan Eduardo On 2/23/07, Ananda Kumar <[EMAIL PROTECT

Re: unauthenticated user

2007-02-23 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], Jerome Macaranas <[EMAIL PROTECTED]> wrote: > Would it be possible to prevent reverse lookup? Im using the latest > GA version.. Please read the manual section on how MySQL uses DNS. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

backup stratergy

2007-02-23 Thread Ananda Kumar
Hi All, Can you please direct me to any good documentation for a good backup and recovery stratergy for MyISAM and INNODB in mysql. regards anandkl

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-23 Thread Jim Winstead
On Thu, Feb 22, 2007 at 11:33:47PM -0600, mos wrote: > That's just one guy's opinion. :) And quite misinformed, unfortunately. $595 is the per-server price for MySQL Enterprise, which includes support, the network monitoring and advisory service, and more. It is not the OEM pricing. You may notic