Re: please help .........very urgent

Kane Wilson wrote: I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = results; $result = mysql_query($dbQuery) or die("Couldn't get file list"); if (!isset($result)) {echo "NULL";}

please help .........very urgent

hi , I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = results; $result = mysql_query($dbQuery) or die("Couldn't get file list"); if (!isset($result)) {echo "NULL";} //if (mysql_

Re: a confusing error: 111

yeah, i can access the database server normally with the client mysql. it works all right. the point is mysqladmin doesn't work. Thank u. On 9/7/05, 王静 <[EMAIL PROTECTED]> wrote: > On 9/7/05, Ben <[EMAIL PROTECTED]> wrote: > > What linux where you using? > RedHat linux 2.4.21 > > A blank passwor

Re: a confusing error: 111

On 9/7/05, Ben <[EMAIL PROTECTED]> wrote: > What linux where you using? RedHat linux 2.4.21 > A blank password is not a good idea, I'm > not sure if it is allowed anyway. yeah, i know. so what i'm trying to do is adding/changing password for the only account root with the tool mysqladmin. but the

Recommendations on new hardware

Hello, currently I run mysql 3.x on Mac OS X 10.3. I have about as much ram in the machine as I can, and have tunes it the best I can, however, I still see the performance drop pretty badly at times. After reading this: I suspect OS X is just not

Re: a confusing error: 111

唯一的账户root没有密码，服务可以启动 ps -e | grep mysqld 有进程mysqld_safe,mysqld n 个 我想改/加密码，mysqladmin -uroot 返回错误，连不上服务器 to Xiaodong: 你说得原来的协议指的是? thank u all. On 9/7/05, 王静 <[EMAIL PROTECTED]> wrote: > /usr/local/mysql-- > > On 9/7/05, Gu Lei <[EMAIL PROTECTED]> wrote: > > 王静 写道: > > > > >hi all. > > >i've ins

Re: a confusing error: 111

/usr/local/mysql-- On 9/7/05, Gu Lei <[EMAIL PROTECTED]> wrote: > 王静 写道: > > >hi all. > >i've installed MySQL database server 4.1.14 under linux platform > >After setting up the server successfully, i envoked mysqladmin, but > >what i got is an error: can't connect to local MySQL server through >

Re: a confusing error: 111

i recall i've managed to set up a connection to MySQL server using account root with the "password" item blank in Kdevelop. when i invoke mysqlaccess -uroot -p, it returned a prompt for password, i just hit return, but failed this time. mysqladmin -uroot got the same suituation with the error 111.

re:mysqldump: Error 2013

Hi, i've got the same kind of problem but not in a dump, in a restore. I tried to restore it in a MyIsam type table but i have the same error. Could other server variables interfer in this ? For example, i see that my long_query_time is set to '10' ... -- Christophe Charron PROLOGIQ 7 bis Rue

a confusing error: 111

hi all. i've installed MySQL database server 4.1.14 under linux platform After setting up the server successfully, i envoked mysqladmin, but what i got is an error: can't connect to local MySQL server through socket '/tmp/mysql.sock'(111) is there anyone who ever run into similar problem and how to

Re: LARGE operation stuck. What now?

Thanks for the questions, hopefully this will help: InnoDB, yes. It's version 4.1.11, not replicated. I am familiar with KILL. It is definitely something I CAN do, but not necessarily something I SHOULD do at this point in time. Usually when you kill a process while it's running, it will roll b

Re: LARGE operation stuck. What now?

INNODB I assume? Replicated environment? What version of mysql? See KILL in the SQL manual.. if you do a show processlist you can get the pid and you might be able to kill it. I believe that it's safe to do a KILL on an DELETE but any decision you make her is your own... That's a LOT of data

LARGE operation stuck. What now?

Here's the situation. I have a table of about 900 million rows, consisting of a bigint and an int in each row. There's an index on the bigint. The table is referenced in a SELECT in other DB operations roughly 15 or 20 times per day. We're under tight deadlines and some operations on the table

Re: trouble understanding why query is not using the index.

On Tue, 6 Sep 2005, Dan Nelson wrote: In the last episode (Sep 06), Jason Pyeron said: there is an unique key index 'pathref_2 (pathref,version)' on this table. so why does 'explain select * from files where (pathref,version)=(129286,0);' scan the whole table? I have to admit I have never se

Re: trouble understanding why query is not using the index.

In the last episode (Sep 06), Jason Pyeron said: > there is an unique key index 'pathref_2 (pathref,version)' on this > table. > > so why does 'explain select * from files where > (pathref,version)=(129286,0);' scan the whole table? I have to admit I have never seen this syntax used in a where c

trouble understanding why query is not using the index.

there is an unique key index 'pathref_2 (pathref,version)' on this table. so why does 'explain select * from files where (pathref,version)=(129286,0);' scan the whole table? I can rewrite the query, but for reasons out of my control I have to design a query which takes single value for a pat

Re: Date Ranges

"Shaun" <[EMAIL PROTECTED]> wrote on 09/06/2005 03:47:25 PM: > Hi, > > Given two dates, can Mysql calculate and return all the dates that occur > between them? > > Thanks for your advice. > > > Given any two dates, MySQL can tell if a third date is within that range. That's easy. To act

Re: Date Ranges

At 20:47 +0100 9/6/05, Shaun wrote: Hi, Given two dates, can Mysql calculate and return all the dates that occur between them? No. Given two dates, MySQL can determine which of a set of already-existing dates stored in a table occur between them and return those. -- Paul DuBois, MySQL Docume

Date Ranges

Hi, Given two dates, can Mysql calculate and return all the dates that occur between them? Thanks for your advice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqladmin question

Thanks Michael, but it now seems that on prepared selects, the values are still place holders, whilst on prepared inserts they are substituted in. Does anyone know how to address this issue? +-+---++---+-+--+--+--

Re: mysqladmin question

You can log on to your mysql server and run: show full processlist; That should give you what you are looking for. -m On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote: mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing

mysqladmin question

mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+--+--+-

Re: Newbie needs info!

Jay There's a short list of SQL & relational tutorials at http://www.artfulsoftware.com/dbresources.html, and of a few MySQL resources at http://www.artfulsoftware.com/mysqlinfo.html. PB Jay Paulson wrote: Hi everyone, Long time reader, first time poster. I've been using MySQL for

Re: renaming indexes

I do not want to change any details about a field. I only want to rename an index. The index is not involved in a PRIMARY key, albeit the index in question is a UNIQUE key. On Tue, 6 Sep 2005, m i l e s wrote: Jason, The only way that I can think to do this is the change its status as a pr

Re: Replication problem

- Original Message - > > However, this does not seem to replicate to the slave, and no error > > shows > > Have you compared the slave's relay logs and master's binary logs? Does > this query present in both logs? The hint was what I needed, Gleb. Spasibo. It turns out that the admi

Re: renaming indexes

Jason, The only way that I can think to do this is the change its status as a primary key field... Once you do that, you can rename the field, and then reinitiate it as a primary keyfield. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

renaming indexes

Is there a way to rename an index without droping it? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner & Sr. Manager 7 We

URGENT --- OSX 10.4 ODBC driver error

Hello All, I am downloading and installing the "Installer package (Mac OS X v10.3)" from the mysql site. I am installing on a OSX 10.4 machine, at the end of the install I get an error message saying "The application MYODBCConfig quit unexpedically after it was reopened, max OSX and other appl

RE: Newbie needs info!

On Tue, 6 Sep 2005 10:58:28 -0500, "John Trammell" <[EMAIL PROTECTED]> said: > The DuBois book is a good start: http://www.kitebird.com/mysql-book/ This might be too basic but it's really clear: http://www.w3schools.com/sql/default.asp > > > -Original Message- > > From: Jay Paulson [m

RE: Newbie needs info!

The DuBois book is a good start: http://www.kitebird.com/mysql-book/ > -Original Message- > From: Jay Paulson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 06, 2005 10:56 AM > To: mysql@lists.mysql.com > Subject: Newbie needs info! > > Hi everyone, > > Long time reader, first ti

Newbie needs info!

Hi everyone, Long time reader, first time poster. I've been using MySQL for some years now and never really did any advance stuff in it. I mainly do updates, deletes, and selects. My selects aren't even that complex as I don't have a very good understanding of the join syntax and exactly wh

Re: Sort aborted

Hello. What operating system do you use? `su` to mysql user (I think the less ugly method should exists) and check if you able to create big files. Bgs <[EMAIL PROTECTED]> wrote: > > Hi, > > There are no quotas at all. The server has been up since march. This is > the first tim

Re: query-log.html

Hello. > host when I have hostnames in the 'user' table. It will only > work with ip addresses. (This is where I came in originally). Are you sure that you're running MySQL without --skip-name-resolve? See: http://dev.mysql.com/doc/mysql/en/dns.html > > I think I must have had my

Re: INNODB memory allocation error during startup

We see that error when we go above the memory limits of a 32 bit operating system. When we run a 64 bit binary on our 64 bit hardware we can allocate more memory and it fires up fine. I'm a Mac guy so your string of letters and numbers describing your hardware and MySQL version don't mean m

Re: How to optimize fulltext selection?

Hello Thank you so much. I Just increase the size of some buffers: # The MySQL server [mysqld] default-character-set = cp1251 port= 3306 socket = /x/xx.sock basedir = /x datadir = /x/x log-error = /x/error.log log-slow-queries = /x/slow.log pid-f

Re: query-log.html

>Hello. > > > >Are you sure that the logging isn't enabled in a different way. > >For possible ways to enable logs see: > > http://dev.mysql.com/doc/mysql/en/program-options.html I think I must have had my head screwed on the wrong way round when I was looking at the log file. I've deleted it now

Re: Sort aborted

Hi, There are no quotas at all. The server has been up since march. This is the first time we had this problem, but now it is consistent... I run the query and after a few seconds, with about 8-10kB written on the disk, I get the abort. Bye Bgs Gleb Paharenko wrote: Hello. Do you have

Re: Sort aborted

Hello. Do you have filesystem quotas enabled on your system? Bgs <[EMAIL PROTECTED]> wrote: > > Hi all, > > > We have a problem with our mysql 4.1.11 system. It has been working well > since the installation, we only have one problem. In the case of certain > selects, it always

Re: Replication problem

Hello. > However, this does not seem to replicate to the slave, and no error shows Have you compared the slave's relay logs and master's binary logs? Does this query present in both logs? See: http://dev.mysql.com/doc/mysql/en/slave-logs.html http://dev.mysql.com/doc/mysql/en

Re: How concerned should I be about Collation?

Hello. There is no statement which is able to change the collation and character set information in all tables at once. For single table use an ALTER TABLE statement. See: http://dev.mysql.com/doc/mysql/en/alter-table.html Dave <[EMAIL PROTECTED]> wrote: > MySQL General List, > >

Replication problem

We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4 as a slave. Replication seems to work extremely well, except in the following circumstance. On the master server, running a query similar to: insert into zmast.leagueinfo (countieslist, defaultleaguecode, leaguename ...

Re: SCO issue

Schalk Neethling wrote: You guys should subscribe to the Planet MySQL RSS feed. The entire issue was cleared up there by a member of the MySQL AB staff. http://www.planetmysql.org/ Maybe the "MySQL AB staff" could take the trouble of answering posts about this issue on this list? Maybe the an

Re: Merging two tables which contain passwords with different encryption methods [SOLVED]

No, because that would require MySQL to 'see' the plain text version of the password. For MySQL to do that, the proces would look something like: PASSWORD()ed password ---> plain text ---> MD5ed password The first link in that chain is mathematically impossible (even if you never saw the