Re: User Accounts

2005-10-22 Thread Michael Stassen
Colin Shreffler wrote: After installing MySQL on OS X, there don't appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an Admin account? Cheers -c After installation, you need to run mysql_ins

User Accounts

2005-10-22 Thread Colin Shreffler
After installing MySQL on OS X, there don¹t appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an ŒAdmin¹ account? Cheers -c

Re: help with query

2005-10-22 Thread Peter Brawley
ja, Your question is a little cryptic. If a questionid column value identifies a particular question, and a vote column value contains a user's vote (1,2,3, &c), can't you just write... SELECT questionid, vote,count(vote) FROM ... GROUP BY questionid, vote PB - [EMAIL PROTECTED] wrote:

Re: help with query

2005-10-22 Thread SGreen
<[EMAIL PROTECTED]> wrote on 10/22/2005 06:24:07 PM: > > > I have a table of votes with four fields, a primary key, and userID, > that are just there for tracking purposes. But then I have > questionID and vote fields. For each question, a user could pick a > number of it's importance from 1

help with query

2005-10-22 Thread jabbott
I have a table of votes with four fields, a primary key, and userID, that are just there for tracking purposes. But then I have questionID and vote fields. For each question, a user could pick a number of it's importance from 1 to 5. That number is what gets stored in the vote field. So,

Re: pgrep shows 2 processes!

2005-10-22 Thread Gleb Paharenko
Hello. Check the number of threads of MySQL Server which're returned by ps with -m option. M.E. Koch wrote: > Dear List, > > I have one mysql 4.1.11 running wich just shows > 2 Processes. > Other mysql environments I do have show more than > 10 Processes. > > I don't have no cl

Re: Compiling a MySQL Client using Apple's xCode

2005-10-22 Thread Gleb Paharenko
Hello. I'm not familiar with xCode, but usually you should include libmysqlclient (if you're using C). See: http://dev.mysql.com/doc/refman/5.0/en/mysql-apis.html I suggest you to make a request to [EMAIL PROTECTED] in case you want to include parts of MySQL in your products. Bruce

Re: Should I buy commercial license?

2005-10-22 Thread Gleb Paharenko
Hello. The complete answer you can only obtain from [EMAIL PROTECTED] Kenji HIROHAMA wrote: > (I've posted to forums, but also send to this ML.) > > Hi, > > I took a look at mysql.com, but I still have a question about > commercial license. > > If we build and host a web-system

Re: Bug in 4.0? 'CREATE TABLE `db`.`table ..' fails silently on replication slave

2005-10-22 Thread Gleb Paharenko
Hello. > the query entered into the binlog, however the slave ignores it >silently: Check your server's relay logs if they contains this statement. See: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html http://dev.mysql.com/doc/refman/5.0/en/slave-logs.html Check that

Re: Problem Upgrading

2005-10-22 Thread Gleb Paharenko
Hello. If you want to debug this issue, have a look here: http://dev.mysql.com/doc/refman/5.0/en/debugging-client.html But if I were you I would check first if mysql client from the official binaries produces the same faults. Ed Kasky wrote: > > I am attempting to upgrade usin

Re: restore of mysqldump-ed data is corrupted

2005-10-22 Thread Gleb Paharenko
Hello. > mysqldump options. I have backup data stored in sql file which Icannot > get back in same form as it was in database. I see now the problem. For a pity, the dump could be made with loss of the information. However this way might be helpful. Put SET NAMES 'UTF8'; line in the b

Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8

2005-10-22 Thread Gleb Paharenko
Hello. Not enough information to make a conclusion. This could be a bug, say: http://bugs.mysql.com/bug.php?id=12410 Slawomir Orlowski (CYMPAK) wrote: > hello, > > I have mysql-4.1.8 compiled form source working on RH7.2. > I have tried to backup my database with mysqldump. > >

Problem starting MySQL With Moved Data Directory

2005-10-22 Thread Hal Vaughan
I'm using MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of Debian, just to clarify). I had a setup of a program I've been working on for several years that is on a RAID. I changed MySQL's data directory so it will be on the same RAID and backed up, along with all my other data

Re: max packet size question

2005-10-22 Thread Michael Stassen
Jasper Bryant-Greene wrote: On Fri, 2005-10-21 at 21:40 -0700, Logg, Connie A. wrote: The max packet size depends on the MTU your network and interface settings allow. The common packet size is 1500, however, if you can use 9000, you will get much better performace. I believe Rob is talkin