Re: Error while running Mysql

2010-12-24 Thread Sharl.Jimh.Tsin
check the error log,and you know the 5.5.8 enable the innodb by default,make sure that you have enough RAM. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/23 Krishna Chandra Prajapati : > HI Adarsh, > > Try memtester command > > #memtester 5 1 > > It' a linux t

Re: Error while running Mysql

2010-12-23 Thread Krishna Chandra Prajapati
HI Adarsh, Try memtester command #memtester 5 1 It' a linux tool to check ram for errors. http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html Krishna On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma wrote: > Dear all, > > I am able o successfully build Mysql 5.5.8 from its sour

Re: Error while running Mysql

2010-12-23 Thread Joerg Bruehe
Hi! Johan De Meersman wrote: > Probably one for the guys with the compilers, but have you tried running it > with dtrace and seeing where it explodes ? TTBOMK, "dtrace" is a Solaris tool, and I haven't heard about it being available on CentOS. I assume this is a typo, and Johan meant "strace".

Re: Error while running Mysql

2010-12-23 Thread Ananda Kumar
n Thu, 23/12/10, Johan De Meersman wrote: > > > From: Johan De Meersman > > Subject: Re: Error while running Mysql > > To: "Adarsh Sharma" > > Cc: mysql@lists.mysql.com > > Date: Thursday, 23 December, 2010, 12:39 > > Probably one for the guys

Re: Error while running Mysql

2010-12-23 Thread Glyn Astill
I've no idea of the status of dtrace on linux, as I've never tried, but failing that you could run it through gdb to get some insight into the issue. --- On Thu, 23/12/10, Johan De Meersman wrote: > From: Johan De Meersman > Subject: Re: Error while running Mysql > To: &q

Re: Error while running Mysql

2010-12-23 Thread Johan De Meersman
Probably one for the guys with the compilers, but have you tried running it with dtrace and seeing where it explodes ? On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma wrote: > Dear all, > > I am able o successfully build Mysql 5.5.8 from its source code on CentOS > but when I issued the following

Error while running Mysql

2010-12-23 Thread Adarsh Sharma
Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I issued the following command , it doesn't shows the mysql> prompt, there is no error in log file. [r...@ws-test mysql-5.5.8]# bin/mysql -p Enter password: Welcome to the MySQL monitor. Commands en

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
a Cymbalista wrote: >>We have just moved to a new web server where we are running mysql >>version: 5.0.45 >>On the old machine, when we gave the following command: >>update table1 set passwd = password('xx') where user_name="xx"; >> >>and th

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Paul DuBois
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave t

We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave the following command, SELECT user_name FROM alon_

Re: Help with running MySQL 5 on OS X Leopard

2008-02-25 Thread Unnsse Khan
sse Khan 写道: Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql

Help with running MySQL 5 on OS X Leopard

2008-02-23 Thread Unnsse Khan
Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql -u root I get

Help with running MySQL 5 on OS X Leopard

2008-02-23 Thread Unnsse Khan
Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql -u root I get

Re: Question regarding running 'mysql' from a bash script

2006-01-12 Thread Mark Phillips
On Thursday 12 January 2006 12:47 pm, Jake Peavy wrote: > On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote: > > > There is a column in my table with string values, but the strings have > > spaces > > in them. I want to read the unique column values into an array in my bash > > script, so I can

Re: Question regarding running 'mysql' from a bash script

2006-01-12 Thread Mark Phillips
quot;${TEAM_QUERY}"|sed 's/^/"/g'|sed 's/$/"/g'`) Commas are not used in the definition of an array - just spaces between quoted strings. Thanks for your help! > > > > > > -Original Message- > From: Mark Phillips [mailto:[EM

Re: Question regarding running 'mysql' from a bash script

2006-01-12 Thread Jake Peavy
On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote: > There is a column in my table with string values, but the strings have > spaces > in them. I want to read the unique column values into an array in my bash > script, so I can use these values in a separate query on this table. How > do I > get

RE: Question regarding running 'mysql' from a bash script

2006-01-12 Thread George Law
: Thursday, January 12, 2006 12:44 PM To: MYSQL List Subject: Question regarding running 'mysql' from a bash script There is a column in my table with string values, but the strings have spaces in them. I want to read the unique column values into an array in my bash script, so I

Re: Question regarding running 'mysql' from a bash script

2006-01-12 Thread Sid Lane
one answer to your question as asked would be to wrap the column in a concat() function and put the double quotes around each row. the better answer is to use PERL

Re: Question regarding running 'mysql' from a bash script

2006-01-12 Thread Mark Phillips
Oops - I forgot my version of mysql - 4.0.22 running on Red Hat Linux 7.3 2.96-113 kernel 2.4.20-30.7. Mark On Thursday 12 January 2006 10:43 am, Mark Phillips wrote: > There is a column in my table with string values, but the strings have spaces > in them. I want to read the unique column val

Question regarding running 'mysql' from a bash script

2006-01-12 Thread Mark Phillips
There is a column in my table with string values, but the strings have spaces in them. I want to read the unique column values into an array in my bash script, so I can use these values in a separate query on this table. How do I get the values into an array? For example, the column teams in my

Re: Running mysql on XP

2005-10-25 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html T Uma Shankari wrote: > > Hello! > > I am trying to run mysql on XP. I have started the net start mysql. > This service started without any error. My.ini file was there in > c:\windows only. But i c

Running mysql on XP

2005-10-21 Thread T Uma Shankari
Hello! I am trying to run mysql on XP. I have started the net start mysql. This service started without any error. My.ini file was there in c:\windows only. But i couldn't able to connect mysql. Can anyone please tell me where is the problem? regards uma -- MySQL General Mailing List For

Re: Error Running MySQL tests

2005-10-07 Thread Gleb Paharenko
Hello. Perhaps master mysqld process was unable to start. If it leaves an error log find it and check for the clues. You may want to edit test scripts to find out the place where master mysqld is invoked and add --log-error=[file] to it's options. Manish Marathe wrote: > Hello all,

Error Running MySQL tests

2005-10-05 Thread Manish Marathe
Hello all, I checked out the MySQL code and was running tests using mysql-test- run.sh. I keep getting this error: ERROR: /tmp/mysql/mysql-test/var/run/master.pid was not created in 400 seconds; Aborting Any insights, suggestions ? Thank You -Manish -- MySQL General Mailing List For list

Re: Running MySQL tests

2005-10-05 Thread Manish Marathe
Hello, Any inputs or information on running MySQL tests under Valgrind, http://valgrind.org . Thanks -Manish On Tue, 2005-10-04 at 14:25 -0700, Manish Marathe wrote: > Hello All, > > I was building mysql after checking out from the bk repository. In that > process, while executing

Running MySQL tests

2005-10-04 Thread Manish Marathe
Hello All, I was building mysql after checking out from the bk repository. In that process, while executing mysql tests I executed them in the environment of Valgrind with the output in xml. After each test case Valgrind thinks output is completed so it completes its xml outputfile, but when the

Re: problem when running mysql server

2005-05-27 Thread gerald_clark
qin lei wrote: > I have instal mysql in /usr/local/mysql. When I run the server. The > message showed on the screen is as follows: > > [EMAIL PROTECTED] bin]# ./safe_mysqld & > [1] 5122 > [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from > /var/lib/mysql > STOPPING server from pid

RE: problem when running mysql server

2005-05-26 Thread Peter Normann
qin lei wrote: > I have instal mysql in /usr/local/mysql. When I run the server. The > message showed on the screen is as follows: [snip] > Warning: Ignoring user change to 'root' because the user was set to > 'mysql' earlier on the command line > 050526 17:46:09 InnoDB: Started > 050526 17:46:09

problem when running mysql server

2005-05-26 Thread qin lei
I have instal mysql in /usr/local/mysql. When I run the server. The message showed on the screen is as follows: [EMAIL PROTECTED] bin]# ./safe_mysqld & [1] 5122 [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysql

Re: Need help in running MySql in PHP script

2005-05-17 Thread Jigal van Hemert
> Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT > and IE as web browser and executed the php > script,but got a fatal error describing that > undefined fuction mysql_connect() in the file and > not getting the desired output. This is not a MySQL problem/issue. The error undefined function ind

Re: Need help in running MySql in PHP script

2005-05-17 Thread Michael Genereux
Are you getting a MySQL error? On 5/17/05, madderla sreedhar <[EMAIL PROTECTED]> wrote: > > Hi, > > Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT > and IE as web browser and executed the php > script,but got a fatal error describing that > undefined fuction mysql_connect() in the file and >

Need help in running MySql in PHP script

2005-05-17 Thread madderla sreedhar
Hi, Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT and IE as web browser and executed the php script,but got a fatal error describing that undefined fuction mysql_connect() in the file and not getting the desired output. I had uncommented the php.ini file the entry named 'extension=php_mysql.

Re: Need help in running MySql in PHP script

2005-05-16 Thread Kristen G. Thorson
some kind of bridge whose name begins with php-mysql*. Check weather the php.ini has got the extension ligne uncommented ... Hope it helps -Message d'origine- De : madderla sreedhar [mailto:[EMAIL PROTECTED] Envoyé : lundi 16 mai 2005 14:52 À : sql firm Objet : Need help in running MyS

RE: Need help in running MySql in PHP script

2005-05-16 Thread CIKALA Frédéric ROSI/SIPROD
ll need to install some kind of bridge whose name begins with php-mysql*. Check weather the php.ini has got the extension ligne uncommented ... Hope it helps -Message d'origine- De : madderla sreedhar [mailto:[EMAIL PROTECTED] Envoyé : lundi 16 mai 2005 14:52 À : sql firm Objet : Need

Need help in running MySql in PHP script

2005-05-16 Thread madderla sreedhar
Hi, Iam using mysql 5.04 , php 5.0 with IIS 5.0 webserver and written some scripts and executed on IE webbrowser but getting an fatal error "undefined function mysql_connect() in the code " kindly tell me where iam going wrong and also tell the mysql username how to find it out becoz when Iam op

Re: Running mysql on a headless Windows CE Device

2005-04-19 Thread Dixie
iquidIce [EMAIL PROTECTED] Hi, that's isn't the solution but if you have a Ipoq HP... you can try to install a linux embedded distro (like familiar or OpenZaurus) and the mysql binaries for thats OS. I'm running mysql on Zaurus 6000L sync to Debian & SuSe server and a winXp pro troug

Running mysql on a headless Windows CE Device

2005-04-18 Thread LiquidIce
Greetings! I am trying to figure out how I can install mysql on my headless WinCE 5.0 web server device. I've already gotten PHP up and running, my next step is to install mysql, and run phpMyAdmin to allow people to navigate and modify their tables. I've been searching everwhere for mysql binari

Re: slowly running mysql server

2005-03-09 Thread James Nobis
Run an explain on the query and post it here. Make sure all the join columns are appropriately indexed. Also, notice the large difference in rows examined vs sent (My guess is this is due to the left joins.) Left joins are horribly overused and I know you said that you cannot change the query bu

slowly running mysql server

2005-03-09 Thread iv
Hi I have a big problem with my mysq server. ater installing it in a new machine it works extremally slowly. My mysql server serves a quite big web site with numerous queries. Unfortunately, I can't alter the queries. And one more thing. Everything run much better on a previous machine. What I ha

RE: Problem running MySQL in high school lab

2004-08-31 Thread SGreen
s installer. > > Donny > > > -Original Message- > > From: Todd O'Bryan [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 30, 2004 8:09 PM > > To: [EMAIL PROTECTED] > > Subject: Problem running MySQL in high school lab > > > > I'm

RE: Problem running MySQL in high school lab

2004-08-30 Thread Donny Simonton
[EMAIL PROTECTED] > Sent: Monday, August 30, 2004 8:09 PM > To: [EMAIL PROTECTED] > Subject: Problem running MySQL in high school lab > > I'm trying to teach my students how to use MySQL, and have installed it > on all the lab machines along with Cygwin. Originally, I had the

Problem running MySQL in high school lab

2004-08-30 Thread Todd O'Bryan
I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld& works fine. Unfortunately, if you then mysql -u root, after a r

Re: Running mysql-administrator and mysqlcc graphical clients

2004-07-13 Thread Duncan Hill
On Tuesday 13 July 2004 08:12, A. Lanza might have typed: > Hi list, > > i've installed mysql-administrator and mysqlcc graphical clients > downloaded from mysql.com. As i read in doc from the site, i unzipped > the downloaded files in /usr/local. > > It seems to be ok, but i cannot execute the app

Running mysql-administrator and mysqlcc graphical clients

2004-07-13 Thread A. Lanza
Hi list, i've installed mysql-administrator and mysqlcc graphical clients downloaded from mysql.com. As i read in doc from the site, i unzipped the downloaded files in /usr/local. It seems to be ok, but i cannot execute the apps. [EMAIL PROTECTED] bin]$ ls mysql-administrator mysql-administrato

RE: Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Kevin Cowley
ics.co.uk -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:10 To: [EMAIL PROTECTED] Subject: RE: Running MySQL and PostgreSQL on the same hardware Thanks Kevin, I am comfortable with the software installs etc.. I was more concerned with hardware bottlenec

RE: Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Andrew Braithwaite
10:53 To: Andrew Braithwaite; [EMAIL PROTECTED] Subject: RE: Running MySQL and PostgreSQL on the same hardware Andrew I've done it but only in a test environment. I actually had 3 different versions of Mysql running plus Postgres. Each of the Mysql's and Postgress were installed to /op

RE: Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Kevin Cowley
or over a month. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 10:47 To: [EMAIL PROTECTED] Subject: Running MySQL and PostgreSQL o

Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Andrew Braithwaite
Hi All, Does anyone have any experience of running MySQL and PostgreSQL on the same hardware? At the moment we have several reasonable fast servers (dual Xeon GHz, 1GB ram, 15,000rpm scsi disk) running MySQL in a replicated environment with high volumes of queries (high read:write ratio) and I

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Rich Allen
o ps -A |fgrep "mysql" on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Gabriel Ricard
where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found men

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Brent Baisley
or installing correctly. That said, I've been running MySQL on a Mac for quite some time without a problem. So if will run. There are some known issues with running 4.1 on a Mac. On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloa

Re: Problem running MySQL on MacOS X.3

2004-05-10 Thread Sasha Pachev
docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most w

Problem running MySQL on MacOS X.3

2004-05-10 Thread Tim Jarman
/Library/StartupItems/MySQL/MySQL start >Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcom

Re: Problem running MySQL

2004-04-14 Thread Egor Egorov
Franz Klein <[EMAIL PROTECTED]> wrote: > > I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a > network. I have administrator privileges. I have also installed MySQL > Administrator. When I try to look at the users I get the following error > message: > > Could not fetch User

Problem running MySQL

2004-04-14 Thread Franz Klein
Hi I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a network. I have administrator privileges. I have also installed MySQL Administrator. When I try to look at the users I get the following error message: Could not fetch Usernames MySQL Error Nr. 1044 Access denied for user:

Re: Running mysql standalone

2004-02-11 Thread Egor Egorov
"Colin O'Connor" <[EMAIL PROTECTED]> wrote: > I don't have much experience with MySQL server, but I am working on a > project which consists of a Java application accessing MySQL databases. The > program is packaged with the mysqld binary for Windows, and the Java program > simply executes the bina

Running mysql standalone

2004-02-10 Thread Colin O'Connor
I don't have much experience with MySQL server, but I am working on a project which consists of a Java application accessing MySQL databases. The program is packaged with the mysqld binary for Windows, and the Java program simply executes the binary with a few options (specifically --basedir, --tmp

Re: running mysql 3.23 and mysql 4.0 on same linux/suse box

2003-12-10 Thread Stefan Egli
Anyone has an idea about this issue? Thanks in advance!!! Regards, Stefan Stefan Egli wrote: Hi there, I'm having problems running two versions of mysql simultaneously on the same box. The versions I'm using are: * mysql 3.23.48 * mysql 4.0.16 What happens: * I have the 3.23 version up and runn

running mysql 3.23 and mysql 4.0 on same linux/suse box

2003-12-09 Thread Stefan Egli
Hi there, I'm having problems running two versions of mysql simultaneously on the same box. The versions I'm using are: * mysql 3.23.48 * mysql 4.0.16 What happens: * I have the 3.23 version up and running (can see that it has 5 processes running with ps, and 'bin/mysqladmin status' shows tha

Running MySQL Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
Dear All, I am working in Linux 8.0 and running mysql 4.0.16. I am trying to access same data files from the two mysql daemons. I mean there are two PC's running with mysql and one NAS server where data files are kept. To run mysql on the machines I first mount the NAS file system and then r

Error when running mysql for the first time

2003-12-04 Thread Torben Wind Meyhoff
Hi, I downloadet the mysql 4.1 development tree made a windows source tree, and compiled with VC++6. After running mysql in console I got this error: D:\MySQL\bin>mysqld-max.exe --console InnoDB: Error: log file group too small for innodb_thread_concurrency 031204 10:33:08InnoDB: Assert

Bug:: Running mysql in lynxos-powerpc

2003-10-15 Thread Sp.Raja
Hi, I tried to install mysql on PowerPC-LynxOS machine, and got into the following issues. If some body can help me resolve this, it would be of great help. First I like to list the changes I did to compile mysql for PowerPC-LynxOS using cross compilers in sparc-sunos. Configure script changes -

I've notice when running mysql interruptible sleep occurs

2003-10-09 Thread Dathan Vance Pattishall
procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 0 1 0 5232 93140 26732 3736888 0 0 157510 388 343 11 1 88 0 1 0 5232 88552 26748 3741348 0 0 892 6 327 269 1

Re: Running MySQL in RAMDisk

2003-08-18 Thread Jeremy Zawodny
On Mon, Aug 18, 2003 at 09:42:51AM -0500, mos wrote: > > External RAM disks that are around 8g are extremely > expensive. Some have built in in battery protection and operate > independently from the OS so if the OS reboots, you still have your data. A > couple of years ago I priced t

Re: Running MySQL in RAMDisk

2003-08-18 Thread mos
, you wrote: At 09:17 AM 8/18/2003, you wrote: Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences? Creigh 305-541-1122 Creigh, How larg

Re: Running MySQL in RAMDisk

2003-08-18 Thread Brent Baisley
. On Mon, 18 Aug 2003, Creigh Shank wrote: > Have a very large database and due to performance requirements it seems > that running MySQL in RAMDisk might be a good solution. Access to the > database is through PHP. Any suggestions or experiences? > > Creigh > 305-541-1122

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
sky putting it in memory if it's being > > >updated and power goes bye-bye.. > > > > > >You should be able to get alot more performance just tuning my.cnf for a > > >larger memory box.. > > > > > > > > > > > >On Mon, 18 Au

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences? Creigh 305-541-1122 Creigh, How large is the database? How many rows? How many MB? Are you us

Re: Running MySQL in RAMDisk

2003-08-18 Thread colbey
7;s being > >updated and power goes bye-bye.. > > > >You should be able to get alot more performance just tuning my.cnf for a > >larger memory box.. > > > > > > > >On Mon, 18 Aug 2003, Creigh Shank wrote: > > > > > Have a very large database

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
d due to performance requirements it seems > that running MySQL in RAMDisk might be a good solution. Access to the > database is through PHP. Any suggestions or experiences? > > Creigh > 305-541-1122 > > > -- > MySQL General Mailing List > For list archives: http://

Re: Running MySQL in RAMDisk

2003-08-18 Thread mos
At 09:17 AM 8/18/2003, you wrote: Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences? Creigh 305-541-1122 Creigh, How large is the

Re: Running MySQL in RAMDisk

2003-08-18 Thread colbey
formance requirements it seems > that running MySQL in RAMDisk might be a good solution. Access to the > database is through PHP. Any suggestions or experiences? > > Creigh > 305-541-1122 > > > -- > MySQL General Mailing List > For list archives: http://lists.mys

Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences? Creigh 305-541-1122 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Running mysql (complete newbie)

2003-07-31 Thread Aftab Jahan Subedar
e permissions on the /var/lib/mysql directory as well. Mike - Original Message - From: "Peter Bradley" <[EMAIL PROTECTED]> To: "O'K Web Design" <[EMAIL PROTECTED]> Sent: July 30, 2003 1:03 AM Subject: Re: Running mysql (complete newbie) Hi Mike, Hmmm

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
Ha! Nice one Nick. Changed the user to mysql, but there's no mysql group, so changed the group to daemon (sounded right). Anyway mysql is now up and running. Just out of interest, the owner of all the directories in /usr/local/mysql is '503'. Grepping /etc/passwd for '503' returns nothing. mys

Re: Running mysql (complete newbie)

2003-07-30 Thread Nick Stuart
Hi guys/gals, the problem is directory perms but not in the tmp. And yes you should have my.cnf in your /etc (can change this location but cant remember where), and there are sample cnf files in the support-files directory of mysql. As far as the directory issue goes simply run: chown -R mysql data

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
Hi Sanya Don't appear to have a file called my.cnf anywhere on my system. Should I have? If so how should it be formatted, and what should be in it? Peter On Wed, 2003-07-30 at 18:42, Sanya Shaik wrote: > You need to set the sock in usr/local/mysql/data/my.cnf to /tmp/mysql.sock > > >

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
e > > > > - Original Message - > From: "Peter Bradley" <[EMAIL PROTECTED]> > To: "O'K Web Design" <[EMAIL PROTECTED]> > Sent: July 30, 2003 1:03 AM > Subject: Re: Running mysql (complete newbie) > > > > Hi Mik

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
hat mysql can write to /tmp. Mike > > > - Original Message - > From: "Peter Bradley" <[EMAIL PROTECTED]> > To: "msql general mailing list" <[EMAIL PROTECTED]> > Sent: July 30, 2003 12:50 AM > Subject: Running mysql (complete newbie) &g

Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
Hi guys and gals, I'm a complete newbie to mysql, so please bear with me. Today I downloaded mysql4.0 binary distribution and installed it on my SuSE Linux 8.1 box. I've unzipped it and put it in: /usr/local/mysql-standard-4.0.14-pc-linux-i686 and I've created a symbolic link to give me /usr/l

Error running mysql test

2003-06-11 Thread Abd El-Hameed Mohammed
Dear all I had installed mysql. Things comes right till i tried to execute " perl run-all-tests" i got the following error /usr/local/bin/perl: relocation error: /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init Any ideas? hamid

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote: % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is "*" (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some id

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted -- ...and then [EMAIL PROTECTED] said... % % On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: % % >...and then [EMAIL PROTECTED] said... % >% ... % >% Most things I've read say to establish a "mysql" user -I take it this % >% is to ru

Re: running MySQL 101

2002-12-15 Thread Paul DuBois
At 20:34 -0500 12/15/02, [EMAIL PROTECTED] wrote: Sorry all, but I'm trying! What is the fix for the following behavior (besides "shoot the user" ;) Looks like the stuff under /var/mysql isn't owned by ted. For starters, try this as the Unix root user: chown -R ted /var/mysql Then try runnin

running MySQL 101

2002-12-15 Thread tlr7425
Sorry all, but I'm trying! What is the fix for the following behavior (besides "shoot the user" ;) --- Welcome to Darwin! [greenroom:~] ted% safe_mysqld --user=ted & [1] 551 [greenroom:~] ted% touch: /var/mysql/greenroom.err: Permission denied chown: /var/mysql/greenroom.err: Operation not permitt

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a "mysql" u

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a "mysql" user -I take it this % is to run the daemon(mysqld?) under?

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
. Hope this helps. Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 8:12 PM To: MySQL List Subject: running mysql (mysql users) I wish to attempt to clarify one of my earlier questions: Most things I've read say to establi

Re: running mysql (mysql users)

2002-12-15 Thread Ryan McDougall
TR, Ok first I would like to say that I have just recently started using MySQL so I feel your pain and I hope my explination helps you out. The mysql user your referring to is probably the user that is should be used to run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm no

running mysql (mysql users)

2002-12-14 Thread tlr7425
I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a "mysql" user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also,

Re: Server comparison running Mysql

2002-10-22 Thread Matthew Halpin
James have you copied over the php and apache confs from the good server to the bad? One of those might be the cause of the problem. Is ensim involved here at all? I doubt it as it doesnt really rely on mysql except for the creation of databases. This is a guess as I have zero ensim experence (but

Re: Fw: Which files to download/install - problems running MySQL

2002-10-21 Thread Miguel Angel Solórzano
ope now is clarify for you: Regards, Nikki - Original Message - From: Nikki Mason <[EMAIL PROTECTED]> To: Miguel Angel Solórzano <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 20, 2002 8:41 AM Subject: Re: Which files to do

RE: Which files to download/install - problems running MySQL

2002-10-21 Thread Fernando Grijalba
*** -Original Message- From: Nikki Mason [mailto:nikki_mason@;btopenworld.com] Sent: October 21, 2002 15:22 To: Miguel Angel Solórzano Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Fw: Which files to download/install - problems running MySQL My email below was rejected for some reason, so I am

Fw: Which files to download/install - problems running MySQL

2002-10-21 Thread Nikki Mason
October 20, 2002 8:41 AM Subject: Re: Which files to download/install - problems running MySQL > Miquel, > > I tried what you suggested, but still it didn't work properly. > > For the server: > C:\>cd mysql\bin > > C:\mysql\bin>mysqld-opt --standalone --console > 02

Re: Which files to download/install - problems running MySQL

2002-10-20 Thread Nikki Mason
i Mason <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, October 19, 2002 9:29 PM Subject: Re: Which files to download/install - problems running MySQL At 15:16 19/10/2002 +0100, Nikki Mason wrote: Hi, >Hi, > >I wish to learn SQL, and as some of my friends already use MySQL

Re: Which files to download/install - problems running MySQL

2002-10-19 Thread Miguel Angel Solórzano
At 15:16 19/10/2002 +0100, Nikki Mason wrote: Hi, Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a

Re: Which files to download/install - problems running MySQL

2002-10-19 Thread Insanely Great
or Windows. http://www.sqlyog.com Insane SQLyog - The Definative MySQL GUI for MySQL http://www.sqlyog.com - Original Message - From: "Nikki Mason" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 19, 2002 7:46 PM Subject: Which files to download/

Which files to download/install - problems running MySQL

2002-10-19 Thread Nikki Mason
Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a C or C++ compiler installed. My PC is not connecte

Re: Server comparison running Mysql

2002-10-13 Thread James Riordon
On Sunday, October 6, 2002, at 01:53 AM, James Riordon wrote: >> Have you tried monitoring server B via 'top' or something and see what >> processes are taking up CPU time and/or swapping. > > > Hello, > > I have monitored top for a bit. It is definitely MySQL-Max that is > taking up the

RE: Re: Server comparison running Mysql

2002-10-08 Thread James Riordon
At 11:17 -0500 10/06/2002, I whispered: > > -Original Message- >> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]] >> Sent: Sunday, October 06, 2002 9:04 AM >> To: James Riordon; [EMAIL PROTECTED] >> Subject: RES: Re: Server comparison running M

  1   2   3   >