u/g to 4.1.22 but now getting mysql_connect() error in php

Hi FC3 test box running mysql 3.23.58 and php 4.3.9 worked ok. (i know they are old but is only a local test box server for testing before i update a live version). installed mysql 4.1.22 and it starts up ok 080626 20:14:58 mysqld started 080626 20:14:59 InnoDB: Started; log sequence numbe

Re: Moving Database from Windows to Linux

I would suggest running something like this from your new linux server: mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u root -h localhost DATABASE This will pump the ouptut directly from mysqldump into mysql running on the linux machine, so you don't need another transfer mechan

Re: Moving Database from Windows to Linux

See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of a User Because of the fundamental difference between binary data files under Windows and under Linux. In Response To: At 07:09 PM 6/26/2008, you wrote: >See Thread at: http://www.techienuggets.com/Detail?tx=42035

Re: Moving Database from Windows to Linux

I move 1giga size of 'JPetstore' record(sql text) from RH4.6 to RH5.2. mysqldump&mysql commands are no problem. pg_dump&psql commands are same result. It takes about 10 minutes of my Celeron 1G.hz note. First I gziped sql text to small size, then ftp, unpacked on Target(Linux). I forgot any of dat

Re: Moving Database from Windows to Linux

At 07:09 PM 6/26/2008, you wrote: See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of a User Hi, I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized database that I'd like to move from a Windows 2000 based server to a Linux server. What's th

BACKUP DATABASE * TO '/tmp/all.backup'; - DOES NOT WORK (6.0.4-alpha)

Hello Hello I have troubles with 'BACKUP DATABASE', I thought it was problem of syntax, but have tried even the samples in http://dev.mysql.com/doc/refman/6.0/en/backup-database.html and the command is not recognized $ mysql --version mysql Ver 14.14 Distrib 6.0.4-alpha, for pc-linux-gnu (i686)

Moving Database from Windows to Linux

See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of a User Hi, I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized database that I'd like to move from a Windows 2000 based server to a Linux server. What's the best way to do this? I normally ta

Re: Query - One-to-Many question

Tina, >Even if I do this simple query, while hardcoding in a catalog_number: >SELECT subject, catalog_number FROM course_subject >WHERE (catalog_number = 520) AND >((subject = 'ME') OR ((course_offer_number = 1) AND (subject NOT LIKE 'ME'))) Errrm, you mean ...subject <> 'ME'..., don't you!?

Re: Performance problem with more than 500 concurrent queries

At 10:39 AM 6/26/2008, you wrote: Hello, thanks for the answer. Where is the error.log stored? I run the mysqladmin, it requires the password and it exits immediately. But I cannot find any error.log. Thanks, Guillermo Guillermo, Look in the \MySQL\Data\*.err file. Also I don't

Re: Query - One-to-Many question

Even if I do a basic select (with no joins) for a given catalog_number, I still get two rows back. Even if I do this simple query, while hardcoding in a catalog_number: SELECT subject, catalog_number FROM course_subject WHERE (catalog_number = 520) AND ((subject = 'ME') OR ((course_offer_number

Re: Query - One-to-Many question

Tina, >for some reason, it still pulled all of the rows Are there multiple rows which meet your WHERE condition? If so, and if you want just one of them, your need another WHERE condition. PB - Tina Matter wrote: Peter, That was the first query I tried, but for some reason, it still p

Re: Query - One-to-Many question

Peter, That was the first query I tried, but for some reason, it still pulled all of the rows. So I've been trying to come up with another solution. Any other ideas? Thanks for the reply. Tina Peter Brawley wrote, On 6/26/08 2:12 PM: Tina >Basically, if the subject is "ME", then I want

Re: Query - One-to-Many question

Tina >Basically, if the subject is "ME", then I want to select that row. >If there is no row for that catalog_number that has a subject of "ME", >then I want to grab the row that has a course_offer_number of '1' >and a subject that is not equal to "ME". Is this what you mean? SELECT ... FROM

Re: Performance problem with more than 500 concurrent queries

Generally your error log will be .err in your data_dir. -Aaron On Thu, Jun 26, 2008 at 8:46 AM, <[EMAIL PROTECTED]> wrote: > Sorry about the long signature in the email. I forgot to remove it... > > Guillermo > > > > > > > From: > [EMAIL PROTECTED] > To: > mysql@lists.mysql.com > Date: > 26.06.2

Query - One-to-Many question

I have two tables: 1.) A course table (stores course_id and catalog_number) 2.) A course_subject table (stores course_id, catalog_number, subject, and course_offer_number) For each row in the course_table, there can be many rows in the course_subject table, due to cross-postings among diffe

MySQL 6.0.4: 'RESTORE TABLE' *nor* 'RESTORE DATABASE' available

Hi I've just reinstalled my system and used the oportunity to get the latest MySQL, so I got 6.0.4 version and installed it. The problem is that want to restore some tables but 'RESTORE TABLE' nor 'RESTORE DATABASE' (as specified in the manual online) are not available, 'BACKUP xxx' are neither a

Cluster Certification Study Guide available again

The Cluster Certification Study Guide (CCSG), first published in November 2007, is on sale again! The first edition had a number of issues with general layout, font sizes, and paper quality. For the new edition, we've addressed those issues, and thanks to our new print-on-demand publisher the pr

Re: Performance problem with more than 500 concurrent queries

Sorry about the long signature in the email. I forgot to remove it... Guillermo From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: 26.06.2008 17:39 Subject: Re: Performance problem with more than 500 concurrent queries Hello, thanks for the answer. Where is the error.log stored? I

Re: Performance problem with more than 500 concurrent queries

Hello, thanks for the answer. Where is the error.log stored? I run the mysqladmin, it requires the password and it exits immediately. But I cannot find any error.log. Thanks, Guillermo --- Guillermo Acilu Senior Engineer, Koiaka GmbH Koiaka GmbH Riesserkopfstr. 17 82467 Garmisch-Partenkirc

Re: Performance problem with more than 500 concurrent queries

do this mysqladmin -uroot -p debug and check the error.log, see if there are any locks on the tables. On 6/26/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello guys, > > I am new to this list and also kind of new to mysql too. > > I have a multi-thread application written in Ruby. The

Performance problem with more than 500 concurrent queries

Hello guys, I am new to this list and also kind of new to mysql too. I have a multi-thread application written in Ruby. The application is reading one table that has two columns (Father, Children). As you might suspect, this is a tree. The fields are foreign keys to a second table, but the sec

Re: improve performance of this sql

Hi All, I just spoke to the dev, they say this is the main sql select * from (select A.LEAF_CATEG_ID, A.CLUSTER_ID, A.SIGNATURE, A.IS_NULL, A.HEIGHT, A.NO_LISTINGS, A.NO_SUCC_LISTINGS, A.TOTAL_QTY, A.SOLD_QTY, A.ASP, A.NO_BIDS, A.MIN_PRICE, A.MAX_PRICE, A.MIN_ITEM_ID, A.MAX_ITEM_ID from C_DATA A,