Mysql Help / Error Thx

2008-01-11 Thread Matthias L.
Dear Users I searched google, find alot of tips, but none of the them was successfully. After a db move with ibdata files, which cannot be dumped (cause of a table failure) we made a hardcopy of the files and moved it onto the new server. Eg. we copy ibdatafiles, the original my.cnf to the new

Re: There's not enough space in /var/lib/mysql/ ---help!!!!

2007-08-13 Thread Michael Habashy
On 8/13/07, Dan Buettner <[EMAIL PROTECTED]> wrote: > > Michael, it looks to me like your root partition is absolutely 100% chock > full. Am I misunderstanding your request for help? Sounds like you are > saying you think you have nothing in that partition - but your 'df -h' > command is showing

Re: There's not enough space in /var/lib/mysql/ ---help!!!!

2007-08-13 Thread Dan Buettner
Michael, it looks to me like your root partition is absolutely 100% chock full. Am I misunderstanding your request for help? Sounds like you are saying you think you have nothing in that partition - but your 'df -h' command is showing 0 bytes available in /. Dan On 8/13/07, Michael Habashy <[E

Fwd: There's not enough space in /var/lib/mysql/ ---help!!!!

2007-08-13 Thread Michael Habashy
I am using debian 4.0 and mysql-server-5.0 package. My server will not start because it states that there is not enough spaceCan someone assist? rider:~# df -h FilesystemSize Used Avail Use% Mounted on /dev/mapper/vg_house-lv_root 493G 468G 0 100% / tmpf

an't connect to local MySQL -- Help me!

2007-04-26 Thread Brown, Charles
I am getting this message from mysql. We had our binlog directory full. What is the resolution? Error 2002 (HY000) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This message is intended only for the use of the Addressee and

Re: INstalling DBD for mysql--Help needed

2006-03-07 Thread Vinay
created 64 bit objects and I had to use right 64-bit flags for DBD::mysql installation. Thanks for all who helped Vinay - Original Message - From: "Jake Peavy" <[EMAIL PROTECTED]> To: "MySQL" Sent: Friday, March 03, 2006 5:38 PM Subject: Re: INstalling DBD f

Re: INstalling DBD for mysql--Help needed

2006-03-03 Thread Jake Peavy
On 3/3/06, Vinay <[EMAIL PROTECTED]> wrote: > > Hello, >I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I > have installed DBI successfully but having a hard time installing DBD for > mysql on HP-UX. > I am getting make errors while installing. I want to use perl to connect >

INstalling DBD for mysql--Help needed

2006-03-03 Thread Vinay
Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank yo

[OT] Strange message from mysql-help@lists.mysql.com

2004-11-05 Thread Santino
Hello, I have just received this message from [EMAIL PROTECTED]: At 21:17 + 5-11-2004, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please click on the following link: ... Received: (qmail 20876 invoked by uid 48); 5 Nov 2004

Re: Install MySQL Help Tables

2003-09-13 Thread Paul DuBois
At 10:46 PM -0400 9/13/03, Randy_Chrismon/[EMAIL PROTECTED] wrote: Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight install (rpm -Uvh) failed on a bunch of dependencies -- including the fact that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on the exis

Install MySQL Help Tables

2003-09-13 Thread Randy_Chrismon/FDS
I'm confused... The 4.1 alpha features says that MySQL now has help files installed with the server. I did a clean install (Win2K), following all directions to the best of my ability, and find no help files. I did discover a SQL file that purported to "fill" the help files: fill_help_tables.sql

Re: Simple MySQL help needed...

2003-06-15 Thread Shane Bryldt
too, for efficiency. Best of luck, -Shane - Original Message - From: "Phill Gillespie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 15, 2003 3:54 PM Subject: Re: Simple MySQL help needed... > Shane Bryldt wrote: > > >I think t

Re: Simple MySQL help needed...

2003-06-15 Thread Phill Gillespie
SET cardnumb=%d WHERE newphoto=1 and tbprinted=1;", iHighNum); This in effect leaves any processing possible to the client side. Hope that helps, -Shane - Original Message - From: "Phill Gillespie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 1

Re: Simple MySQL help needed...

2003-06-15 Thread Shane Bryldt
- From: "Phill Gillespie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 15, 2003 1:53 PM Subject: Simple MySQL help needed... > Hi * > > I'm running MySQl 3.23 and I'm trying to run a very simple command that > basically finds the highest num

Simple MySQL help needed...

2003-06-15 Thread Phill Gillespie
Hi * I'm running MySQl 3.23 and I'm trying to run a very simple command that basically finds the highest number in a column and then for all matching rows sets their card number to be +1. The code looks like this: #cardnumb is actually a string of the form SNx so set @high=x as a nu

Re: os X install mySQL help

2003-06-06 Thread Ted Rogers
A good reference, may help (or not): http://www.entropy.ch/software/macosx/mysql/ Ted Rogers On Thursday, June 5, 2003, at 03:18 PM, gerald jones - Sun Microsystems - Broomfield United States wrote: This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.

Re: os X install mySQL help

2003-06-06 Thread Jim Dickenson
ald jones - Sun Microsystems - Broomfield United States > <[EMAIL PROTECTED]> > Date: Thu, 5 Jun 2003 13:18:29 -0600 (MDT) > To: [EMAIL PROTECTED] > Subject: os X install mySQL help > > This is a mac os X installation problem: When I download/install the pkg > version of mysql

os X install mySQL help

2003-06-06 Thread gerald jones - Sun Microsystems - Broomfield United States
This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: " touch: /usr/local/mysql/var/myhostname.err: N

re: RE: MySQL Help Needed Please

2003-01-06 Thread Egor Egorov
On Sunday 05 January 2003 09:08, Anton Zavrin wrote: > Well, I read, played around and updated it (I guess) > Now, when I try to start mysql with this command (same as before), it > gives me that: > # /usr/local/bin/safe_mysqld --user=mysql & > [1] 71491 > # Starting mysqld daemon with databases f

Re: MySQL Help Needed Please

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)
<[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 8:08 AM Subject: RE: MySQL Help Needed Please Well, I read,

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, >ps -ef | grep mysqld >got nothing Because the MySQL SERVER isn't running! >Though I can do: ># mysql -u root -p With this command,

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
t (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p E

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Connect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called my

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
70948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please > I

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
ailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez

Re: MySQL Help Needed Please

2003-01-03 Thread Thomas Spahni
Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahn

MySQL Help Needed Please

2003-01-03 Thread Anton Zavrin
Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' ex

re: MySQL Help - Initial Configuration

2002-12-14 Thread Egor Egorov
On Friday 13 December 2002 22:19, Benjamin Fisher wrote: > I'm fairly new to MySQL, and RDBMS's in general, but not to system > administration nor linux. I'm running Gentoo, and I can't seem to get > mySQL to work. [skip] > My guess, it can't find the pid to stop it with. > > And the file /var/r

MySQL Help - Initial Configuration

2002-12-14 Thread Benjamin Fisher
I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. Gallio root # /etc/init.d/mysql start * Starting mysqld... [ ok ] Then I: Gallio root # ps ax PID TTY STAT TIME COMMAND 1 ? S 0:04 init

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ed Carp
ED]> To: "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 10:00 AM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > > Michael T. Babcock wrote: > > >May I rephra

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
;; "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 6:54 PM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Sorry, my bad. > > What is this PAGER and where do I run your test scr

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
D] Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example ... > I'll also have to read up on those UDF's. Sounds interesting. ...or PAGER. Try to do a test: \P mail root@localhost; select User,Host,Password from mysql.u

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> To: "'Michael T. Babcock'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Frid

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
Michael T. Babcock wrote: >May I rephrase your comment? > >"I need to send E-mails to people from MySQL data". > >I recommend just doing a SELECT on the data in question and generating >the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 5:10 PM Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Hi, > > I think youd should make an UDF which t

RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
* * Ireland * * ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of walt Sent: 06 September 2002 15:05 To: [EMAIL PROTECTED] Cc: MySQL Mailing List Subject: Re: [MySQL] HELP: Can MySQL run external progr

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ralf Narozny
Hello! walt wrote: >"Keith Burke [Experience IT]" wrote: > > > >>Greetings, >> >>I'm new to this list but not to MySQL. I've been using MySQL on >>Linux with PHP for the past year or two. I've always managed to sort out >>any problems by looking at the documentation on the website but

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail forexample

2002-09-06 Thread Michael T. Babcock
Keith Burke [Experience IT] wrote: > I need to be able to send Emails to people from MySQL command >line. > > May I rephrase your comment? "I need to send E-mails to people from MySQL data". I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea
Message - From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 1:23 PM Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for example > Greetings, > > I'

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gerald Clark
Write it in perl. Perl has modules for MySQl and Email. Keith Burke [Experience IT] wrote: >Greetings, > > I'm new to this list but not to MySQL. I've been using MySQL on >Linux with PHP for the past year or two. I've always managed to sort out >any problems by looking at the documentatio

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread walt
"Keith Burke [Experience IT]" wrote: > Greetings, > > I'm new to this list but not to MySQL. I've been using MySQL on > Linux with PHP for the past year or two. I've always managed to sort out > any problems by looking at the documentation on the website but my > current problem has me pe

[MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]
Greetings, I'm new to this list but not to MySQL. I've been using MySQL on Linux with PHP for the past year or two. I've always managed to sort out any problems by looking at the documentation on the website but my current problem has me perplexed. I need to be able to send Emai

RE: Jon Frisby---MySQL help needed

2002-07-29 Thread Jon Frisby
> Whatever you have suggested so far hasn't worked. I thought that > maybe something > is missing in my stating the problem and implementing your > suggested solutions. > So here is a more expanded picture of the queries: > > $sth=$dbh->prepare("INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)");

Re: Jon Frisby---MySQL help needed

2002-07-29 Thread Brian Reichert
On Mon, Jul 29, 2002 at 01:13:30PM -0400, Aamer Rauf wrote: > Hi Jon, > Whatever you have suggested so far hasn't worked. I thought that maybe something > is missing in my stating the problem and implementing your suggested solutions. > So here is a more expanded picture of the queries: > > $sth

Jon Frisby---MySQL help needed

2002-07-29 Thread Aamer Rauf
Hi Jon, Whatever you have suggested so far hasn't worked. I thought that maybe something is missing in my stating the problem and implementing your suggested solutions. So here is a more expanded picture of the queries: $sth=$dbh->prepare("INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)"); $sth

error in mysql - help!!!

2002-07-25 Thread jan henrik mo
I have tried to install mysql, but there is something wrong... When I start up my computer I get this error-message in a pop-up with a 'winmysqladmin.exe'-header: Error reading Memo2 -> Lines.Strings: The parameter is incorrect. Does anybody know what this means, and what I can do to make mysql

mySQL help

2002-07-09 Thread Yung Nguyen
Hi, I am a student, I am due to return for my final year where I must complete a final year project. I have decided to develop a JSP website connected to a database. I have installed TomCat and have been recommended to use MySQL. I have downloaded MySQL but I would like help on how I would

RE: mysql help !! urgent

2002-06-22 Thread Cal Evans
mysqld --skip-grant-tables -Original Message- From: Jesse Angell [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: mysql help !! urgent Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin

mysql help !! urgent

2002-06-22 Thread Jesse Angell
Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work a

Re: PHP and MySQL help please !

2002-04-25 Thread Jan-Michael Ong
"password"); > > $db = mysql_pconnect("localhost", "user", "password"); > > Ideas ? Why is it now a undefined function ? > > Andrew > -Original Message- > From: Andrew Rich [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 25 April

RE: PHP and MySQL help please !

2002-04-24 Thread Michael Chang
t; ? > > I am not sure if the include statement is design to add mysql BINARIES or > SOURCE CODE ?? > > Lost. > > Andrew > > -Original Message- > From: Andrew Rich [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 25 April 2002 11:28 AM > To: Andrew R

RE: PHP and MySQL help please !

2002-04-24 Thread Andrew Rich
11:28 AM To: Andrew Rich; [EMAIL PROTECTED] Subject: RE: PHP and MySQL help please ! Further to this, I removed the "@" symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect("localhost", "user&qu

RE: PHP and MySQL help please !

2002-04-24 Thread Andrew Rich
ser", "password"); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to

PHP and MySQL help please !

2002-04-24 Thread Andrew Rich
+ PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- Go to SQL now Number of books found: ".$num_results.""; ?>

Re: Need MySQL help with tables and records

2002-03-16 Thread Bob Hall
On Sun, Mar 17, 2002 at 12:28:35AM -0500, Lionlike wrote: > Hi, I need a little help as I am a beginner with db things. I'm > building a database for technicians and "help-desk" problems where > technical problem tickets are stored in one table, and technicians in > another. Really I have two

Need MySQL help with tables and records

2002-03-16 Thread Lionlike
Hi, I need a little help as I am a beginner with db things. I'm building a database for technicians and "help-desk" problems where technical problem tickets are stored in one table, and technicians in another. Really I have two main questions. First, each problem may have more than one tech

Re: Some PHP - mySQL help please ... new to both

2002-03-09 Thread Lou Picciano / Essex Systems
A quick diagnostic? Try the page phpinfo.php in the phpMyAdmin directory - this will give you the 'whole picture' in terms of your php installation... Even easier? Any php page which contains the code: Will give you this full info report. Very useful! Lou Picciano > > Thanx Lou, this rea

Re: Some PHP - mySQL help please ... new to both

2002-03-09 Thread Daniel Negron/KBE
Essex SystemsTo: MySQL List <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: Re: Some PHP - mySQL help please ... new to both

Re: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Lou Picciano / Essex Systems
this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou > -Original Message- > From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 08, 2002 11:05 AM > To: [EMAIL PROTECTED] > Subject: Some PHP - mySQL help please ...

Re: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Nathan
CTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 10:51 AM Subject: RE: Some PHP - mySQL help please ... new to both Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your des

Some PHP - mySQL help please ... new to both (Along same lines)

2002-03-08 Thread Administrator
Along the same lines, I have run some scripts that give a similar error that time out is there something in php.ini or mysql that will alow the timing to not stop after 60seconds or 30seconds or something. Had a script to run and pull keywords from a massive db, and it kept timing out. Hope that

RE: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Brian Warn
| Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am v

RE: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Daniel Negron/KBE
| | To: "'Daniel Negron/KBE'" <[EMAIL PROTECTED]&

RE: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Todd Williamsen
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am

Some PHP - mySQL help please ... new to both

2002-03-08 Thread Daniel Negron/KBE
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run throu

RE: MYSQL HELP

2002-02-20 Thread Daniel Rosher
11:18 a.m. > To: David McInnis; 'Shade, Richard'; [EMAIL PROTECTED] > Subject: Re: MYSQL HELP > > > David, > > > How would you use a temporary table? Is that the most efficient way? > > Use SELECT INTO temp_tbl to replace the sub-select clause. > Re

Re: MYSQL HELP

2002-02-20 Thread DL Neil
David, > How would you use a temporary table? Is that the most efficient way? Use SELECT INTO temp_tbl to replace the sub-select clause. Rewrite the existing SELECT into a join with the temp_tbl. Is there another way? =dn > Richard, > > > Does anyone know what is wrong with this syntax...

RE: MYSQL HELP

2002-02-20 Thread David McInnis
How would you use a temporary table? Is that the most efficient way? David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:03 AM To: Shade, Richard; [EMAIL PROTECTED] Subject: Re: MYSQL HELP Richard, > Does anyone know what is wr

Re: MYSQL HELP

2002-02-20 Thread DL Neil
Richard, > Does anyone know what is wrong with this syntax... > > Select H.FinishCode, L.RowID > From CallHistory As H, BD2.CallList As L > Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID = > L.RowID) > AND H.RowID = L.RowID); Sub-selects not (yet) permitted by MySQL (

RE: MYSQL HELP

2002-02-20 Thread Shade, Richard
Richard Shade Systems Administrator (936)559-2280 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:39 AM To: Shade, Richard Subject: Re: MYSQL HELP Your message cannot be posted because it appears to be either spam or

MySql help required

2002-01-03 Thread Raghu Babu Bandi
Hi, Does the mysql support internationalisation?. If so, Kindly let me know what settings I need to configure to insert korean strings into the table and retrieve the same and show it in a browser(jsp page)?. Is there any GUI tool for mysql(like Toad for Oracle)?. if so where can I get that?.

Re: DBD::mysql HElp

2001-12-30 Thread Clinton Hesse
From: "David J Jackson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 10:16 PM Subject: Re: DBD::mysql HElp > Did you do install "mysql" or install "DBD-mysql"? > > Here's what the ac

Re: DBD::mysql HElp

2001-12-29 Thread David J Jackson
Did you do install "mysql" or install "DBD-mysql"? Here's what the activestate page has to say: ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing ppm install DBI install DBD-mysql This will fetch the modules via HTTP and install them. If you need to use a WWW p

DBD::mysql HElp

2001-12-29 Thread Clinton Hesse
> Hi, > > I'm trying to install DBD::MYSQL on Windows 2000 Pro. > I've already install DBI > > Using ppm for ActivePerl > I downloaded DBI and extracted it to a folder. > Then i ran > > ppm> intall DBI > It installed fine. > > I did the exact same thing for DBD::MYSQL but i get the following

DBD::mysql HElp

2001-12-28 Thread Clinton Hesse
Hi, I'm trying to install DBD::MYSQL on Windows 2000 Pro. I've already install DBI Using ppm for ActivePerl I downloaded DBI and extracted it to a folder. Then i ran ppm> intall DBI It installed fine. I did the exact same thing for DBD::MYSQL but i get the following error Error: Package 'DBD

Some question about establish a Cluster for Mysql,Help!

2001-11-01 Thread Magic
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Some question about establish a Cluster for Mysql,Help!

2001-11-01 Thread Magic
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Some question about establish a Cluster for Mysql,Help!

2001-11-01 Thread Magic
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li ---

Re: M$ SQL Export to Mysql Help

2001-08-30 Thread Gerald Jensen
- Original Message - From: "Curtis Spencer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 2:54 PM Subject: M$ SQL Export to Mysql Help > I have a nicely sized database of about 40 records, which I have in > MS SQL but I need

M$ SQL Export to Mysql Help

2001-08-30 Thread Curtis Spencer
I have a nicely sized database of about 40 records, which I have in MS SQL but I need to move it to my production server, which is Mysql. I was going to do it this way: Export MS SQL database into a file and then use LOAD DATA INFILE But I was wondering if there were a way to export into SQ

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Pete Kuczynski
Only time I had this error on a NT4 server was when I attempted to get logging to work and I made a mistake editing the mycnf and myini files. When I cycled the mysql service, it would no come back up. Removing the offending edit allowed it to start. Pete Michael Tam wrote: > > Hi all, > >

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
AIL PROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, July 03, 2001 9:10 AM Subject: Re: MySQL HELP -- Unable to start Win2k service > >I have tried to remove the service, uninstalled the mysql and reinstall

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Werner Stuerenburg
>I have tried to remove the service, uninstalled the mysql and reinstalled it. I >got the same result. Looks like the problem may be with a dirty shutdown and problems in tables. Try to run isamchk. Maybe this helps. -- Herzlich Werner Stuerenburg ___

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Miguel Angel Solórzano
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the pos

MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated u

RE: DBD::MySQL Help!!

2001-05-23 Thread Megan Payne
I had the same problem too. If you go to CPAN and then go to DBD::Mysql, click on the ftp site to Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one instead, it should work. Worked like a charm f

Re: DBD::MySQL Help!!

2001-05-23 Thread Mark Rowlands
If this was the binary install, I had the same problemso I compiled from source.problem went away. > Hi, > > Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- > I know this is prolly not the best list for this question, but its the only > related list im currentl

mysql --help / -e option: wrong message

2001-05-17 Thread carsten . pedersen
>Description: mysql --help states that the -e option produces output similar to that of --batch. This is not the case. >Fix: Either the text or the program should be changed to conform to each other. >Release: mysql-3.23.33 (Official

Re: MySQL Help

2001-05-08 Thread Joseph Bueno
Salvador Casquero Algarra wrote: > > Hi, > > I am having a terrible problem with MySQL and I am desperated as > nobody seems to find the source. I have a Web site ( www.genteirc.com ) > whith MySQL database access. The problem is that those Mysql processes are > growing continuou

MySQL Help

2001-05-07 Thread Salvador Casquero Algarra
Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gig

Re: DBD::MySQL Help!!

2001-05-02 Thread Ken Menzel
, 2001 2:19 AM Subject: DBD::MySQL Help!! > Hi, > > Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I > know this is prolly not the best list for this question, but its the only > related list im currently subscribed to... When I do the install it askes m

DBD::MySQL Help!!

2001-05-01 Thread Rick Kukiela
Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put

Problem in mysql (Help)

2001-01-11 Thread Ravi Ranjan
hi, I am working on Mysql Database. I am facing following problem while trying to grant permission after login as administrator mysql Ver 9.16 Distrib 3.21.33b, for pc-linux-gnu (i586) server version: 3.21.33b-log mysql> grant all on temp.* to ravi@localhost identified by 'ravi'; ERROR 106