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 prajapat...@gmail.com: HI Adarsh, Try memtester command #memtester 5 1

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

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 adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I

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 vegiv...@tuxera.be wrote: From: Johan De Meersman vegiv...@tuxera.be Subject: Re: Error while running

Re: Error while running Mysql

2010-12-23 Thread Ananda Kumar
/12/10, Johan De Meersman vegiv...@tuxera.be wrote: From: Johan De Meersman vegiv...@tuxera.be Subject: Re: Error while running Mysql To: Adarsh Sharma adarsh.sha...@orkash.com 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 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. I

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 adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build

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_protein_passwd WHERE

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 the following command, SELECT

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
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_protein_passwd WHERE (user_name = xx

Re: Help with running MySQL 5 on OS X Leopard

2008-02-25 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

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

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

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

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 George Law
: 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 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 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 the

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

2006-01-12 Thread Mark Phillips
- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: 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

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 use these

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

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

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,

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 mysql tests I

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

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

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 file

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

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

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

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 not

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

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

RE: Need help in running MySql in PHP script

2005-05-16 Thread CIKALA Frédéric ROSI/SIPROD
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 help in running

Re: Need help in running MySql in PHP script

2005-05-16 Thread Kristen G. Thorson
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 MySql in PHP script Hi, Iam using

Re: Running mysql on a headless Windows CE Device

2005-04-19 Thread Dixie
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 trought SQLYog. Also works fine. Paolo

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

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

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

RE: Problem running MySQL in high school lab

2004-08-31 Thread SGreen
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 trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had

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

RE: Problem running MySQL in high school lab

2004-08-30 Thread Donny Simonton
: 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 permissions set wrong and my students couldn't

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

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 apps.

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: Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Kevin Cowley
a month. Kevin Cowley RD 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 on the same

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 /opt/database

RE: Running MySQL and PostgreSQL on the same hardware

2004-05-26 Thread Kevin Cowley
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 bottlenecks and OS

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Brent Baisley
, 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 downloaded and ran the binary installer (mysql

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Gabriel Ricard
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 mention of this problem on FAQTS

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Rich Allen
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 running mysql I get error 2002 as before. I found

Problem running MySQL on MacOS X.3

2004-05-10 Thread Tim Jarman
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 welcome! Please cc any replies to me as I am not currently subscribed

Re: Problem running MySQL on MacOS X.3

2004-05-10 Thread Sasha Pachev
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 welcome! Please cc any replies to me as I am

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

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 Usernames

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 binary with

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,

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

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 run

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

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\binmysqld-max.exe --console InnoDB: Error: log file group too small for innodb_thread_concurrency 031204 10:33:08InnoDB: Assertion

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

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 in RAMDisk

2003-08-18 Thread colbey
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/mysql To unsubscribe:http://lists.mysql.com

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

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
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/mysql To unsubscribe:http

Re: Running MySQL in RAMDisk

2003-08-18 Thread colbey
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 and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
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 using MyISAM

Re: Running MySQL in RAMDisk

2003-08-18 Thread Creigh Shank
performance just tuning my.cnf for a larger memory box.. 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

Re: Running MySQL in RAMDisk

2003-08-18 Thread Brent Baisley
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 -- MySQL General Mailing List

Re: Running MySQL in RAMDisk

2003-08-18 Thread mos
: 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 database? How many rows? How many MB

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 these

Re: Running mysql (complete newbie)

2003-07-31 Thread Aftab Jahan Subedar
- 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. Don't think so. /tmp is drwxrwxrwt Cheers Peter On Wed, 2003-07-30 at 18:43, O'K Web Design wrote: Hi

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

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
. 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) Hi guys and gals, I'm a complete newbie to mysql, so please bear with me. Today I

Re: Running mysql (complete newbie)

2003-07-30 Thread Peter Bradley
: Running mysql (complete newbie) Hi Mike, Hmmm. Don't think so. /tmp is drwxrwxrwt Cheers Peter On Wed, 2003-07-30 at 18:43, O'K Web Design wrote: Hi Peter It sounds like you have a directory permission problem. I had one just this week. Just make sure that mysql

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 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

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.

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 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

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
: 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 establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created

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 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

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 permitted

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 running

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 run the

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

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-23 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

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

2002-10-21 Thread Nikki Mason
: 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\binmysqld-opt --standalone --console 021020 8:20:30 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB

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

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

2002-10-21 Thread Miguel Angel Solórzano
- 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 download/install - problems running MySQL Miquel, I tried what you suggested

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

2002-10-20 Thread Nikki Mason
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, they recommended that I too use it. Please can you tell

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

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

2002-10-19 Thread Insanely Great
. 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/install - problems running MySQL Hi, I

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

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 CPU and

Re: Server comparison running Mysql

2002-10-08 Thread James Riordon
At 11:12 -0300 10/06/2002, I whispered: Maybe P4 1,7 mhz performs marginally better than a P3/1000Mhz, but ... My webserver have a P3/450Mhz with 384 MB Ram and a 10 Gb IDE drive :P I cant seem to get above 1.0 load average on the machine on normal use (I have average 10-30 people online

  1   2   >