MySQL vs Plone/Zope/Python

I've been experimenting with databases, both Drupal and Plone. Plone is a can of worms, but it's intriguing, partly because it's so different. It sounds like they replace LAMP with something completely different, though it's a complete mystery to me at present. I wondered if anyone on this list ha

ALTER TRIGGER in MySQL

Hello, I was reading the docs on Triggers at: http://dev.mysql.com/doc/mysql/en/using-triggers.html Looks like there is no support for Alter Trigger. So if I want to change a trigger, I have to first drop the existing one and recreate another? Am I correct? Karam ___

Re: Creating new username & password

David Blomstrom wrote: What's the easiest way to create a username and password for a new database? It's been so long since I created my original database, I forgot how. You can do it with a query like this: GRANT USAGE ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Replace

MySQL 4.0.23a defunct

Hi Im running a stock install of Slackware 10.1 with the default setup of mysql. Whats happening is when I hit the reload button several times on a page that uses php and accesses mysql I get defunct and zombies start showing when viewing top. I also get this when I run a web based apache be

Creating new username & password

What's the easiest way to create a username and password for a new database? It's been so long since I created my original database, I forgot how. When I created my new database with phpMyAdmin, I scanned the page looking for anything mentioning username or password but I couldn't find anything. I

Re: MySQL in CentOS? try before?

Hi all, This amazing feedback from you guys, I feel much comfortable now start digging on this CentOS. Thanks & Cheers KH Jason Pyeron wrote: Yes, we use it for our Crisfield product, and we use it for our servers too. On Thu, 4 Aug 2005, KH wrote: Hi all, I just came across Centos (Co

Re: True randominess

Pat Adams <[EMAIL PROTECTED]> writes: > On Thu, 2005-08-04 at 14:44 -0500, 2wsxdr5 wrote: >> There are also several places that you can get a reasonably random >> number for the seed from your machine. The amount of free disk space, >> unless that doesn't change much on your machine. The amoun

RE: How to delete log files? Was: RE: Where did my disk space go?

One thing to remember about *nix, is that disk space is not released until all processes that had a file open have closed it. For example, if a process has a 2Gb file open, and another process rm's the file, an ls will show that file as gone but the disk space is not released until the firs

RE: How to delete log files? Was: RE: Where did my disk space go?

Hi Siegfried, There is a section on each of the log files. I wouldn't go deleting the log files without understanding exactly what you are trying to do. Have a read of the section I mentioned. The logfiles that you are showing in your directory are only 5Mb each and won't be taking anything if you

How to delete log files? Was: RE: Where did my disk space go?

David (and anyone else): Here is the directory of my data directory. I don't see hundreds of mega bytes here, but deleting ib_logfile* and ibdata1 would sure help. Which of these files I can delete without loosing any data from my database? drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:

explain not explaining long running query?

I have a query that is taking days to complete (not good). If I change the query so that it selects less rows it runs fast. I ran an explain on both queries and it didn't give any hints as to why the one query is taking days to run. In fact explain knows how many rows each query will examine. P

RE: Where did my disk space go?

Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 5

how to determine right value for max_allowed_packet?

all, I just finshed hosing down a minor (that could have been FAR worse) fire where replication failed with an: "Error reading packet from server: Packet too large - increase max_allowed_packet on this server" in my error log. I bumped it up from 1M to 4M, restarted mysql (as well as dependant

Re: True randominess

On Thu, 2005-08-04 at 14:44 -0500, 2wsxdr5 wrote: > There are also several places that you can get a reasonably random > number for the seed from your machine. The amount of free disk space, > unless that doesn't change much on your machine. The amount of free > RAM, (up time mod cpu usage).

Re: True randominess

Pat Adams wrote: However, in answer to your question, there is no way to get TRUE randomness in a computer system. Even cryptographically secure random number generators can be predicted under absolutely identical circumstances. While technically that is true, there is a method that will gi

MySQL 4.1.13a binaries now available

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, The MySQL 4.1.13 release included a fix to resolve a potential security vulnerability in the zlib compression library (CAN-2005-2096) that is bundled with the MySQL distribution. Very shortly afterwards, an additional potential zlib security fl

Re: True randominess

On Thu, 2005-08-04 at 15:00 -0400, Scott Hamm wrote: > I've noticed that rand() do not change on each query request. Is there a way > I could get a TRUE randominess into MySQL? http://dev.mysql.com/doc/mysql/en/mathematical-functions.html Are you using RAND() or RAND(n)? Using RAND() makes MySQL

Re: indexes

Michael Stassen wrote: Sebastian wrote: I read the manual on indexes but i am a little confused how i should build the type of index i need. i have this structure: | id | item | type || 3 || 23 || news || 4 || 46 || faqs || 5 || 23 || news || 6 || 23 || news query:

True randominess

I've noticed that rand() do not change on each query request. Is there a way I could get a TRUE randominess into MySQL? -- Power to people, Linux is here.

Re: indexes

Some sections of the manual seem to indicate that it's better to create indexes after data population, rather than before. See section 7.2.14, "Speed of INSERT Statements". The general procedure there is to load the data using LOAD DATA INFILE, and then use myisamchk. "This creates the index tree

binary log long format

The current documentation states : Log some extra information to the log files (update log, binary update log, and slow queries log, whatever log has been activated). For example, username and timestamp are logged for queries. Before MySQL 4.1, if you are using --log-slow-queries and --log-l

Re: indexes

Sebastian wrote: i forgot to add another question, is it ok to add index after the tables and data are already built, or is it better to create the index before data gets inserted? It's probably better to create the indexes up front (assuming you know in advance which ones will be needed),

Re: indexes

Sebastian <[EMAIL PROTECTED]> wrote on 08/04/2005 01:31:13 PM: > i forgot to add another question, > > is it ok to add index after the tables and data are already built, or is > it better to create the index before data gets inserted? > > Sebastian wrote: > > > I read the manual on indexes bu

Re: indexes

Sebastian wrote: I read the manual on indexes but i am a little confused how i should build the type of index i need. i have this structure: | id | item | type || 3 || 23 || news || 4 || 46 || faqs || 5 || 23 || news || 6 || 23 || news query: SELECT id, item, type .

Question on V5.0.9 and SHOW command

Hello, I have a strange issue. When I issue the command SHOW COLUMNS from TABLE XYZ I get the usual output.The key field is blank because there is no key on the field. However, when I issue the command from a PERL script the the DBI::DBD it returns MUL in the key field. There is no index asso

Count two kinds of related records?

I'm searching a table of people who own properties, and I want to also include the total count of related properties, and the count of related properties whose (status is 'Active' and approval is 'Active'). I've got: select accounts.name, count(properties.property_id) as totalcount from a

Re: indexes

i forgot to add another question, is it ok to add index after the tables and data are already built, or is it better to create the index before data gets inserted? Sebastian wrote: I read the manual on indexes but i am a little confused how i should build the type of index i need. i have t

RE: 4.1 and unions

From: Scott Noyes [mailto:[EMAIL PROTECTED] > UNION is not broken; the syntax in the given comment is > incorrect. You can do > SELECT * FROM table UNION SELECT * FROM table > or > (SELECT * FROM table) UNION (SELECT * FROM table) > but not > SELECT * FROM table UNION (SELECT * FROM table) Oh,

indexes

I read the manual on indexes but i am a little confused how i should build the type of index i need. i have this structure: | id | item | type || 3 || 23 || news || 4 || 46 || faqs || 5 || 23 || news || 6 || 23 || news query: SELECT id, item, type ... FROM comments WH

Re: 4.1 and unions

UNION is not broken; the syntax in the given comment is incorrect. You can do SELECT * FROM table UNION SELECT * FROM table or (SELECT * FROM table) UNION (SELECT * FROM table) but not SELECT * FROM table UNION (SELECT * FROM table) On 8/4/05, Mike Johnson <[EMAIL PROTECTED]> wrote: > > Hi all,

Re: 4.1 and unions

mysql> select * from files where id < 10 union (select * from files where id >20 and id <30); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 mysql> select * from files where

4.1 and unions

Hi all, Is there anyone using version 4.1 that can verify or refute the claim posted at the bottom of the upgrade notes here? http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html The user claims that UNION statements with parentheses are broken in 4.1. That is, 'SELECT * FROM table1 UNION (

Re: How to find Balance?

Is this what you had in mind? It assumes MySQL version 4.1 or later: SELECT id, price - (SELECT SUM(IF(type = 'PAID', amount, 0 - amount)) FROM payment py WHERE py.id = pr.id ) AS balance FROM price pr; On 8/4/05, Yesmin Patwary <[EMAIL PROTECTED]> wrote: >

Re: How to find Balance?

Yesmin Patwary <[EMAIL PROTECTED]> wrote on 08/04/2005 12:42:44 PM: > > Dear All, > > > > I am trying to calculate balance for all id's. Can it be done using > only one MySQL query (without any scripting, eg: php,perl,asp..)? > > > > price table: > > id|price > > 1|150 > > 2|100 > > 3

Re: Database equivalent to NorthWind for M$ SQL

Lol On 8/4/05, mos <[EMAIL PROTECTED]> wrote: > > At 09:02 AM 8/4/2005, you wrote: > >Is it possible if MySQL could create its own ficitional database to > >standardize the way we train ourselves in MySQL and to be able to > >communicate our ideas to others than having to expose our actual workin

How to find Balance?

Dear All, I am trying to calculate balance for all id's. Can it be done using only one MySQL query (without any scripting, eg: php,perl,asp..)? price table: id|price 1|150 2|100 3|300 payment table: id|transaction_type|amount 1|PAID|75 1|PAID|25 1|REFUND|60 1|REFUND|30 1|

Re: Database equivalent to NorthWind for M$ SQL

At 09:02 AM 8/4/2005, you wrote: Is it possible if MySQL could create its own ficitional database to standardize the way we train ourselves in MySQL and to be able to communicate our ideas to others than having to expose our actual working datas to others? Let M$ have their own NorthWind and we h

RE: Where did my disk space go?

I did the following from the Cygwin bash prompt on WinXP Pro. cd /c/mysql find . -size -10M | xargs ls -l I only found one file greater than 10 megabytes. I'm looking for several hundred megabytes. Thanks, Siegfried -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Ibbackup question

I've been using it for a while. you can find more info in http://www.innodb.com/manual.php. --xinhuan On 8/4/05, Clyde Lewis <[EMAIL PROTECTED]> wrote: > > I'm in the process of testing this backup utility and need to know if > anyone > have any experience using it as their primary > backup s

Re: Persistent Corruption [UPDATE]

thanks for everyone help/suggestions -- I wound up swapping the media, and what was corrupt prior, seems to be all nice and happy now -- so - as suggested, looks to be that the drive was starting to fault On 7/31/05, Chris McKeever <[EMAIL PROTECTED]> wrote: > Thanks for all the help - I tried th

Re: MySQL in CentOS? try before?

Yes, we use it for our Crisfield product, and we use it for our servers too. On Thu, 4 Aug 2005, KH wrote: Hi all, I just came across Centos (Community Enterprise Operating System - http://www.centos.org/) It came with mysql as well. Hence my question here, does anyone guru here using this O

Re: MySQL in CentOS? try before?

We've been using CentOS more and more. I recently built a small prototype datawarehouse with CentOS (but I used MySQL 5 RPM's instead of the stock). I've had no problems that I didn't have with RHEL on CentOS. I also have a few similar RHEL systems, so when a problem occurs on a CentOS box, I r

RE: Where did my disk space go?

Thank you David and Sebastion, I am not doing this in a transaction (at least, I did not do anything special to start a transaction) and I have no need for a transaction. How do I check the log files you two suggest? Thanks, Siegfried -Original Message- From: Logan, David (SST - Adelaide

Problem with datetime values and MyODBC driver

Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I create TADOQuery object which has datetime parametr and I fill this parametr with valid datetime value then I can see in MYSQL's qu

RE: is this correct

[snip] Is this the general enquiry list foe mysql sorry to be a pain [/snip] Yes, and there was no pain at all. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Ibbackup question

I'm in the process of testing this backup utility and need to know if anyone have any experience using it as their primary backup solution. Any help would be greatly appreciated. Thanks in advance. *** Clyde Lewis DBA General Parts (919)227-5100 [EMAIL PROTECTED] -- MySQL

Re: MySQL 4.1.12-debian + large HEAP table

Hello Gleb, Thanks for your answer. --- Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > > 1. Why does the HEAP table take so much more > physical > > space than the MyISAM table? > > There is a formula which allows to count the > approximate memory usage > for one row. Multiply an ob

re: is this correct

hi, Is this the general enquiry list foe mysql sorry to be a pain yours Ben (jmonkey) :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Ibbackup and GNR

I've been searching for a decent backup utility and is currently in the process of testing ibbackup from www.innodb.com and is presently stuck. I've tried running the script but it will only parse the first GNR in my my.cnf file. The my.cnf file has five group numbers which sets up five databases.

Re: Database equivalent to NorthWind for M$ SQL

Is it possible if MySQL could create its own ficitional database to standardize the way we train ourselves in MySQL and to be able to communicate our ideas to others than having to expose our actual working datas to others? Let M$ have their own NorthWind and we have ours. On 8/4/05, [EMAIL PRO

Re: Database equivalent to NorthWind for M$ SQL

It's only known in certain circles and it's only useful as an educational tool. What it is: Northwind is a small, populated, relational database for a fictional trading company that MS uses as an example database in several layers of training documentation. If you have never used any of the MS

Re: Database equivalent to NorthWind for M$ SQL

Ok. Now that I got NorthWind into my MySQL 5.0.9 database and also am running M$ SQL database server at where I work, this might be a good opportunity for me to learn how to mirgate from M$ SQL database to MySQL using Northwind and to see the difference between them. Is there anything that I sh

Re: Database equivalent to NorthWind for M$ SQL

I ran a quick search on google regarding the NothWind Database or schema, but I did not run across anything that would explain what it is and what it is used for, however, it seems to be a pretty useful and known one. I would appeciate insight on this. thanks esv. ps. I think it would be more

Re: MySQL in CentOS? try before?

On 4 Aug 2005, at 08:03, KH wrote: I just came across Centos (Community Enterprise Operating System - http://www.centos.org/) It came with mysql as well. Hence my question here, does anyone guru here using this OS before for production ? Success story? Centos is a handy beast. It is a str

Re: Problems after upgrading form 4.1.10a to 4.1.13 on RHEL4 - solved

On 3 Aug 2005, at 13:01, Gleb Paharenko wrote: I've just successfully upgraded from 4.1.9 to 4.1.13 (all are standard rpms for x86) on Fedora 3. Check that you able to start MySQL with mysqld_safe (for example /usr/bin/mysqld_safe -- user=mysql&). See: http://dev.mysql.com/doc/mysql/en/start

Re: sudden mysqldump errors

Hello. Does your problem still exist? Are you able to perform the dump by hand with mysqldump? Is it possible that your table has grown so the default value of max_allowed_packet is too small. What version of MySQL do you have. See: http://dev.mysql.com/doc/mysql/en/communication-errors.ht

sudden mysqldump errors

Hi list, our overnight backup scripts have suddenly been getting a lot of mysqldump errors like: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `cs_email_things` at row: 512234 I've checked the obvious things, and no luck: * disk space is OK * nothing in

Possible? Urgent please.

Using OpenRowSet Transact SQL, I want to view/obtain data from MySql using this function in "MS SQL Query Analyzer". Can I do this at all? I have MyODBC driver and the relevant OLE DB provider to connect to MySQL db, I can connect to MySQL db, but having problem with the last parameter (table nam

Re: MySQL 4.1.12-debian + large HEAP table

Hello. > 1. Why does the HEAP table take so much more physical > space than the MyISAM table? There is a formula which allows to count the approximate memory usage for one row. Multiply an obtained value by number of rows and compare the results with the size of your table. See: http:

Re: default collation char

Philippe Poelvoorde wrote: Enrique Sanchez Vela wrote: I would like to have MySQL differentiate between 'abc' and 'ABC' both the server and clients. so far anything I've done has not worked. Is altering the column type an option ? If yes, you would change any 'text' for 'blob' and any 'varcha

Re: default collation char

Enrique Sanchez Vela wrote: Hello Folks, I would like to have MySQL differentiate between 'abc' and 'ABC' both the server and clients. so far anything I've done has not worked. Is altering the column type an option ? If yes, you would change any 'text' for 'blob' and any 'varchar' for 'varcha

MySQL in CentOS? try before?

Hi all, I just came across Centos (Community Enterprise Operating System - http://www.centos.org/) It came with mysql as well. Hence my question here, does anyone guru here using this OS before for production ? Success story? Cheers KH -- MySQL General Mailing List For list archives: http:/