Hello,
I know this mail group may be not according to my question, so Please help
me. I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to
select data from 2 table with separate in 2 database name. How could I do
this? here is some example.
DB#1
victor writes:
> can mysql use the linux password /etc/passwd for the authentication
No, and it'd be a _really_ bad thing to do anyway.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned
Hi, All.
Help my, please! I can't compile MySQL util comp_err. Where can I
find it as binary for Win32?
--
Best regards,
Pavel mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://
On Wed, Sep 19, 2001 at 12:37:04PM -0400, Alexander Pichtchikov wrote:
> Gents,
>
> When version 4.1 of MySQL with view supporting will publish?
Sometime after 4.0.
Seriously, though, I don't think anyone knows with much certainty.
The 4.0 release has to hit alpha/beta/gamma testing and then be
Hi, Adrian.
AG> Hi,
AG> Could anyone tell my why from time to time, the file my.cnf (under Win2000
AG> and MySql) is automatically renamed into my_cnf.bak?
AG> Adrian
Probably you use winmysqladmin.exe.
AG> -
AG> Before post
On Thu, Sep 20, 2001 at 10:21:07AM +0800, victor wrote:
>
> can mysql use the linux password /etc/passwd for the authentication
No. Because it cannot guarantee that users are who they say they are.
If you think of authorization and authentication as two separate
problems, the reasons are a littl
On Thu, Sep 20, 2001 at 12:38:44AM -0400, Anthony Rodriguez wrote:
> Please help! There is a parse error in line10:
>
>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 14 days, processed 255,630,232 queries (210/sec. avg)
Hi,
Could anyone tell my why from time to time, the file my.cnf (under Win2000
and MySql) is automatically renamed into my_cnf.bak?
Adrian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
On Wed, Sep 19, 2001 at 07:54:12AM -, program tester wrote:
> Hello,
>
> I would like to know that how many databases can i use for one site
> at max? Hopeing for kind help
Gee, you could probably easily use 100,000 or more if you have
ReiserFS or another filesystem that can handle "la
The manual said if you want to write a BLOB data into
file, you should use INTO DUMPFILE,
But that still doen't work.
I got a Dumpfile with just 1 byte.
There is a BLOB data in my table.
What is the problem?
best regards
hxia
>See MySQL Manual section 6.4.1
>SELECT INTO OUTFILE
--
On Thu, Sep 20, 2001 at 01:36:10PM +0800, Luke Chiam wrote:
> Thanks for the reply Jeremy.
>
> > > I keep getting "500 Internal Server error" when accessing my
> > > database, my application is a C++ development of my own.
> >
> > Smells like Apache to me.
>
> Thats what I thought, but on readin
On Wed, Sep 19, 2001 at 04:37:03PM -0400, Phillip Spademan wrote:
> Hello All.
>
> I am working with a rather large MySQL DB, it seems that it likes to
> swap ALOT, even after the operations are done, i have bumped up my
> cache sizes, i have tones of .bin files in my var dir, any ideas?
What OS
On Wed, Sep 19, 2001 at 09:37:57AM -0400, Phillip Spademan wrote:
> Hello:
>
> I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system
> with 1G ram, it takes forever to get anything out, i have even tryed
> selecting the data into a file. Is there any tricks/tips anyone can
> give me
Thanks for the reply Jeremy.
> > I keep getting "500 Internal Server error" when accessing my
> > database, my application is a C++ development of my own.
>
> Smells like Apache to me.
Thats what I thought, but on reading Apache docs & faq, it mentioned that it
is probably the cgi script failure
On Thu, Sep 20, 2001 at 12:45:29AM -0400, Will French wrote:
>
> I looked but could not find any reference in the docs regarding
> limits on the number of columns a table may have. I can say for
> certain that at 50 you are at no risk (I have tables with 140+).
> The only db that I know the limit
On Thu, Sep 20, 2001 at 01:10:50PM +0800, Luke Chiam wrote:
> Hi,
>
> I keep getting "500 Internal Server error" when accessing my
> database, my application is a C++ development of my own.
Smells like Apache to me.
> I used to suspect memory leaks but thats has been checked with
> LeakTracer,
Hi,
I keep getting "500 Internal Server error" when accessing my database, my
application is a C++ development of my own.
I used to suspect memory leaks but thats has been checked with LeakTracer,
and passed!
The problem I think is documented here at
http://www.mysql.com/doc/C/o/Communication_e
Just a point. The limit might be high, but accessing a table as such will
not be as quick... if possible, should normalise your data. the whole idea
behind RDMS.
If this has been done, ignore me :)
Luke
-
Before posting, pleas
Please help! There is a parse error in line10:
etc.
Thank you!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thr
I looked but could not find any reference in the docs regarding limits on
the number of columns a table may have. I can say for certain that at 50
you are at no risk (I have tables with 140+). The only db that I know the
limit on is MS Sql Server and it allows 255.
> -Original Message-
Placed At : BOM
Durga Prasad@SATYAM
09/20/2001 09:52 AM
Hi,
iam trying to use mysql as the back end of a web enabled application.
My tables have fields numbering more than 50.
Iam a newbie and so i would like to know if there are any limits on th
Hi,
I keep getting "500 Internal Server error" when accessing my database, my
application is a C++ development of my own.
I used to suspect memory leaks but thats has been checked with LeakTracer,
and passed!
The problem I think is documented here at
http://www.mysql.com/doc/C/o/Communication_e
See MySQL Manual section 6.4.1
SELECT INTO OUTFILE
database <- to satisfy mailer-daemon
> -Original Message-
> From: Jason Kwok [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 10:21 PM
> To: [EMAIL PROTECTED]
> Subject: Load_File
>
>
> Load_File is used to read a pic
can mysql use the linux password /etc/passwd for the authentication
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Load_File is used to read a picture (or any binary) file into table, but how
to write it back to disk from a table?
==
Best Regards
Jason Kwok
==
---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.281 / Virus Database: 149 - Release Date:
On Wed, Sep 19, 2001 at 06:55:00PM -0700, Ida Sze wrote:
> Dear Sir/Madam,
> I'd like to upload data into a table from a text
> file. Inside the file, there is a field about the
> date. It is in MM/DD/YY format. But inside the MySQL
> manual I can't find any information about it, so can
> you te
Dear Sir/Madam,
I'd like to upload data into a table from a text
file. Inside the file, there is a field about the
date. It is in MM/DD/YY format. But inside the MySQL
manual I can't find any information about it, so can
you tell me what can
I do?
Thank you!
Best Regrads,
Ida
--- [EMAIL PRO
On 19-Sep-2001 Neil Silvester wrote:
> I am having a little problem with a PHP 4 statement in one of my webpages. I
> am using a drop down box of selections that is built a table in a MySQL
> database.
> This is what I have so far (everything works well, the correct information
> is displayed f
I am struggling with this myself right now. I posted a similar question to
this group earlier in the day and it must be a poser because no one has
responded.
I fear that the only way to do this with a single sql statement is using the
replace command:
Let's say you have 2 tables like this:
Main
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hi,
I believe that the query below is correct, but I do not believe that it is
possible in MySQL currently due to it not supporting sub-selects:
UPDATE table1 SET ID=table2.ID, Company=table2.Company,
Modified=table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company WHER
> I would like to find out what record in the table has
> the largest amount of characters. This way I could possibly
> decrease the varchar size (currently 100) to speed up the
> queries.
>
> My table is as below.
> CREATE TABLE competitor (
> CompetitorsName varchar(35) not null,
>
echo ('' . $row["Category"] .
'');
You might be able to escape the " with /" or the like but I'm not great at
php, yet. ;)
- Original Message -
From: "Neil Silvester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 5:42 PM
Subject: PHP and Mysql problem
At 8:43 AM +1000 9/20/01, Neil Silvester wrote:
>Hello,
>I am working on a MySQL database that lists the current competitors
>of the company I work for as a part of a global intranet. At present
>I have a table that contains the corporate website of our
>competitors. I would like to find out wh
> -Original Message-
> From: Neil Silvester [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 20 September 2001 08:12
> To: [EMAIL PROTECTED]
> Subject: PHP and Mysql problem
>
>
> I am having a little problem with a PHP 4 statement in one of my webpages. I
> am using a drop down box of se
Hello,
I am working on a MySQL database that lists the current competitors of the
company I work for as a part of a global intranet. At present I have a table
that contains the corporate website of our competitors. I would like to find
out what record in the table has the largest amount of char
I am having a little problem with a PHP 4 statement in one of my webpages. I
am using a drop down box of selections that is built a table in a MySQL
database.
This is what I have so far (everything works well, the correct information
is displayed for both the Category and ID column values.
I'm currently hosting about 6700 MySQL databases.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "program tester" <[EMAIL PROTECTED]
On Wednesday 19 September 2001 14:32, Tom Meckna wrote:
> Hi Venu!
>
> Sorry for bothering you. I belive I have the driver installed correctly
> but I dont understand what name I use when calling it from a java program.
> A example would be
>
> Class.forName(driverName);
> Ex from book
> Class.fo
Hi
> -Original Message-
> From: Tom Meckna [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 1:46 PM
> To: [EMAIL PROTECTED]
> Subject: ODBC Drivers
>
> I obtained a copy of MySQL from sams teach yourself MySQL in 24
> hours. I
> am a java programmer and I have writ
Hows it going!
I have created a mysql database on a windows 2000 platform and have been
able to connect, start it as a service, performed all basic SQL
statements(insert, update, select, delete) and use it from the command line.
I obtained a copy of MySQL from sams teach yourself MySQL in 24
I just compiled from scratch, and successfully installed v3.23.42 on an
RH7.1 system. EVerything went fine, no errors anywhere, it started up
fine and I was able to set passwords fine. Then I try to log in and
execute 'show databases;' and it just sits there:
Welcome to the MyS
Hello All.
I am working with a rather large MySQL DB, it seems that it likes to swap
ALOT, even after the operations are done, i have bumped up my cache sizes, i
have tones of .bin files in my var dir, any ideas?
Thanx!
_
Get you
On 19 Sep 2001 12:25:35 -0700, Michael Tam wrote:
> Hi all,
>
> I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I
> would like to know if there is any beneficials running MySQL over IDE-RAID
> and is there any configuration I need to optimize MySQL to utilize the
> RAID??
anyone have any idea what this means?
and why it comes up?
mysql> use mydatabase;
Reading table information for compltion of table and coumn names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
this only comes up for _some_ databases
not all
any he
Hi all,
I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I
would like to know if there is any beneficials running MySQL over IDE-RAID
and is there any configuration I need to optimize MySQL to utilize the
RAID??
All helps/suggestions are greatly appreciated.
Regards,
From: Will French <[EMAIL PROTECTED]>
> > Sorry about that. Here's the answer:
> >
> > [EMAIL PROTECTED]
> And this means what? A little less criptic, please, for use simpletons.
Heh, it means that I typed too quickly and wasn't really watching.
[EMAIL PROTECTED]
As for why I wrote tha
database, sql, query, table
> Sorry about that. Here's the answer:
>
> [EMAIL PROTECTED]
>
And this means what? A little less criptic, please, for use simpletons.
-
Before posting, please check:
http://www.mysql.com/ma
What is "copy-db utility"?
Where can I find it? Does it come with MySQL or any other DB?
Tell me and I will make use of it, and let you know if there are issues.
Today I have 4 dbbases (LDAP, Oracle, SQL Server and MySQL) and I have to
keep them with the closest table structure as possible. Thi
Hi guys,
From: Carl Troein <[EMAIL PROTECTED]>
> Sadly, the admin of this list doesn't give a shit. This
> is rather obvious from
Sorry about that. Here's the answer:
[EMAIL PROTECTED]
---
Rodney Broom
Programmer: Desert.Net
sql
---
okay. the problem was still the same one.
i was just adding that i couldn't find a data directory.
i'll try upgrading to 2.2.19 but i'm not sure if i can cause i'm running
suse 6.4 - that might be a completely stupid statement - i'm not sure yet!
any pointers anyone?
-powlow
> - Origina
On Wednesday 19 September 2001 09:59, Floyd Mann wrote:
> > > > And while I am on the subject - we are aware of an I/O bug in 2.2.14
> > > kernel
> > >
> > > > even without the special "safety" patch from SuSE) that make MySQL
> > corrupt
> > > > tables under heavy load. Two of our users were runn
On Wednesday 19 September 2001 09:38, powlow wrote:
> i upgraded to 2.2.16. still same problem. can't seem to find a data
> directory. just installing from rpm all standard. this really bugs me...
No, that is not the same problem. You were getting a segfault. If it cannot
find datadir, start deb
What is the query you are running + what version of mysql are you using?
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 2:12 AM
Subject: BDB table : different results on adjacent queries
> hi a
I assume that you have already scanned the MySQL manual section 4.10.4
"Replication Features and Known Problems" to see if anything listed there as
a problem is relevant to your situation. I found a couple of gotchas there
that caused me some problems.
-Original Message-
From: Gabe E. Ny
>Description:
mysql couldn't find the lockfile, so i stopped and reinstalled it. since then
i can't connect, error message:
[root@primergy mysql-3.23.42]# /usr/local/mysql/current/bin/safe_mysqld
Starting mysqld daemon with databases from /var/mysql/data
010919 18:55:04 mysqld ended
[ro
I have found that if I do manual changes to the table, it replicates. If
the applications my company wrote make changes, they don't replicate. I am
having the programmers find where they went sloppy.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Gabe E. Nydick" <[
server-id=1
log-bin=/usr/local/mysql-3.23.39/bin-log/db1-bin
those are the only replication settings.
Have you possibly heard of bad programming practices in Perl/DBI that would
cause a query not to make it into the bin-log?
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]
Just a quick question regarding how (if at all) MySQL's binary update log
consumes resrouces as it records modifications to various tables in the
database.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not f
Gents,
When version 4.1 of MySQL with view supporting will publish?
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request t
I was thinking we could use copy-db utility. Can anybody tell me if that
is a possibility and if there are any known issues.
Thanks
-Original Message-
From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 12:27 PM
To: Kishore Balasubramanya; [EMAIL PROTE
Since I know Oracle, MySQL, and Java the fastest way I did it was:
1) I created scripts for creating the tables in both DBs (this is the way I
usually do). They differ a bit on datatypes, and I had to remove all the
foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql
and
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [grant table installation failed]
>Description:
Tried to install MY
Try it and see. What I think you want is to rank your usernames according
to who has the highest wucount and rank and then show the individual records
in descending order of wucount/rank but grouping records by username. This
differs from the suggestion of simply adding username at the front of
sql
Could this user please be removed? It's [EMAIL PROTECTED]
- Forwarded message from [EMAIL PROTECTED] -
From: [EMAIL PROTECTED]
Date: Wed, 19 Sep 2001 17:01:13 +0100
Subject: 123box.co.uk mail delivery system
To: [EMAIL PROTECTED]
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Wed, 1
Hi,
I am making a program which reads information from the online system
and logs them into the MySQL database. The libraries for the other part
were compiled with '-64'. However I found that the lib of MySQL client was
compiled with '-32'. Thus create linking problem!
Is there a version o
So sprach »Felipe Baytelman« am 2001-09-19 um 11:37:36 -0400 :
> I'm getting
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
Does the file actually exist? I know that you deleted it, but
Alexander Skwar
--
How to quote: http://learn
Hi,
Can anybody tell me how to get all the data and the table structures
from Oracle to Mysql.
Thanks,
Kishore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
i upgraded to 2.2.16. still same problem. can't seem to find a data
directory. just installing from rpm all standard. this really bugs me...
thanks for your words so far
-powlow
- Original Message -
From: "powlow" <[EMAIL PROTECTED]>
To: "Sasha Pachev" <[EMAIL PROTECTED]>; <[EMAIL PROTEC
I'm getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Error
Everything began when I deleted the mysql.sock
I have restarted mysqld several times, but nothing.
What should I try?
Maybe you would like to ICQ: 8188532
Felipe B
Correct. I need the data sorted by the wucount first, but still have the
data grouped together by the username. I don't quite follow the reasoning
behind a temp table. Won't I still have the problems of the sorting, or can
you explain to me how this will solve that problem?
Glen
-Original
Distinct what? I need all of the data presented. Oracle is not an option,
but unions would not solve my problem, I don't think...
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:47 AM
To: Terje Kristensen; Solsberry, Glendon; [EMAIL
Well, here is where the problem comes in... Taking the data that I posted:
junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120
junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120
junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120
Ir
Hi
The following example gives me a problem.
I create a new database by sending the following SQL commands:
create database dummy
create table `Dummy Table` (`Dummy Time` timestamp(14) NOT NULL)
When i run mysqldump with the parameters shown below
mysqldump -uroot -pxx -A -a -F -l
>Description:
Hello, I've been using MY-SQL with 3 tables, which
all have the same primary key = .
Everything was fine for several months but yesterday I received
an "ERROR 1034" in mysql stating that the key file for
one of the tables was incorrect.
I think you should be safe to just restart MySQL
On Wednesday 19 September 2001 08:32 am, Felipe Baytelman wrote:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
>
> I'm not a linux guy... I don't fly trough this OS...
>
> Could you help me?
>
> I'm really hurried!
>
> Felipe Bay
Hi!
> "Adams," == Adams, Bill TQO <[EMAIL PROTECTED]> writes:
Adams,> Peter Zaitsev wrote:
>> I'm quite lucky with providing with bad tables which does not repear
>> properly or having other strange behavior.
Adams,> Sometimes when myisamchk does not work (or it says it has repaired the ta
Felipe Baytelman <[EMAIL PROTECTED]> writes:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Restarting mysql should recreate the socket.
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please check:
http:
So sprach »Felipe Baytelman« am 2001-09-19 um 10:32:14 -0400 :
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Become root, and do:
mksock /var/lib/mysql/mysql.sock
chmod 777 /var/lib/mysql/mysql.sock
chown . /var/lib/mysql/mysql.sock
replace and by the user/group the mysql process ru
Felipe Baytelman writes:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Just restart mysqld and it'll be created.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
do you mean upgrade to 2.2.16?
-paulo
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: "powlow" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 2:21 PM
Subject: Re: rpm install error
> On Wednesday 19 September 2001 04:48, powlow wrote:
> >
Oops... I think I deleted mysql.sock - WHAT CAN I DO?
I'm not a linux guy... I don't fly trough this OS...
Could you help me?
I'm really hurried!
Felipe Baytelman
BayTex Producciones
[EMAIL PROTECTED] http://www.baytex.net ICQ: 8188532
Chile: (09) 879 01 67
Phillip Spademan writes:
> I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G
> ram, it takes forever to get anything out, i have even tryed selecting the
> data into a file. Is there any tricks/tips anyone can give me for managing
> large DB's?
Spend some time on re
I am not possitive that I completely follow what you are trying to do...
but, here goes:
What if you create a temporary table first:
CREATE TEMPORARY TABLE tu (
usernamevarchar(255),
maxwucount bigint,
maxrank int
) SELECT username, max(wucount) as maxwu
Three things to try
One use "distinct"
Two use temp table
Three use oracle and unions
Simon
-Original Message-
From: Terje Kristensen [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2001 14:39
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: SV: Simple SELECT query (or so I thought)
If you change you order by to
order by username, wucount desc, rank desc
Won't this group it the way you want it ??
Terje K
> -Opprinnelig melding-
> Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
> Sendt: 19. september 2001 15:29
> Til: '[EMAIL PROTECTED]'
> Emne: Simple SELECT qu
Hi,
How about adding and ORDER BY username, giving:
SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate',
'$lastDay') order by username, wucount desc, rank desc;
Andrew Murphy
<^oo^> Im a bit of a night owl.
-Original Message-
From: Solsberry, Glendon [mailto:[EMAIL P
Hello:
I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G
ram, it takes forever to get anything out, i have even tryed selecting the
data into a file. Is there any tricks/tips anyone can give me for managing
large DB's? It also likes to crash tables every month or so t
Can anybody help me out with this??? This would make life so much easier
for my poor stats package. Anyone?
-Original Message-
From: Solsberry, Glendon
Sent: Friday, September 14, 2001 10:17 AM
To: MySQL
Subject: Simple SELECT query (or so I thought)
I am running a stats page for our
On Wednesday 19 September 2001 04:48, powlow wrote:
> oops. its suse...damn
>
> still...any ideas?
>
> -powlow
uname -a
Does it show kernel 2.2.14? If yes, upgrade the kernel. SuSE introduced a
special "safety feature" into their 2.2.14 kernel that makes our binary
coredump right away. They
Since you failed to check the error log and post it here I can only guess.
chown -R mysql /usr/local/mysql
R Talbot wrote:
> I have deleted the Mysql 3.22.32 install and compiled
> source for and installed Mysql 3.23.40.
> The new installation resides at /usr/local/mysql.
> Make Test did f
Hi,
I am trying to use PHP and MySQL together on a script that I installed. I
got an error message of the following on my browser when I try to execute
the PHP file:
Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/apache/htdocs/authen/authlib/backend.php on line 98
I am pretty new to mysql, and have been studying the feesibility of offering
a mysql version of my product (currently uses ms sql server).
Reading a post to this list yesterday, it came to my attention that there is
no FROM clause allowed in either the UPDATE or DELETE statements (actually,
the D
i can't find my my.cnf or data directory.
i am going nuts here...these may seem like stupid questions but i'm not even
thinking logically any more...
any help is much appreciated.
tahnks
-powlow
- Original Message -
From: "powlow" <[EMAIL PROTECTED]>
To: "Sasha Pachev" <[EMAIL PROTECTE
its actually not an installation problem. just starting the server.
if i try to run mysqld (not safe-mysqld) i get this message :
linux:/var/lib/mysql # mysqld
Fatal error: Please read "Security" section of the manual to find out how to
run mysqld as root!
010919 12:35:58 Aborting
010919 12:35
oops. its suse...damn
still...any ideas?
-powlow
- Original Message -
From: "powlow" <[EMAIL PROTECTED]>
To: "Sasha Pachev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 11:17 AM
Subject: Re: rpm install error
> kernel version 2.2
> how do i find out my
>> There are some others with a similar problem(including me).
>
>Hi guys. I'd be really interested in knowing things like how many
requests, and of what type, are being made of >your database(s). If
you're making a couple of dozen SELECTs per day, then I'd say that you
have a problem, but >if you
kernel version 2.2
how do i find out my Red Hat version? its not installed through rpm...i
think...
MySQL-3.23.42-1.i386.rpm
MySQL-client-3.23.42-1.i386.rpm
MySQL-shared-3.23.42-1.i386.rpm
installing shared : no problem
when installing client i get : group man does not exist - using root (13
tim
Hallo, kann mir jemand sagen, was daran falsch ist ?
select mobile_number,
count(correct) anzahl
from answers
where correct = '1' and
anzahl >= 5 and
DATE_FORMAT(date, '%Y%m%d%H%i') >= DATE_FORMAT(DATE_SUB(NOW(),
Tabitha Ridwan writes:
> How to install MySQLGUI under redhat 6.2 ?
What about it? Are you wondering how to do it?
Have you tried and failed? If so, why don't you want
to let anyone know what you did and what errors you
got? Vague questions deserve vague answers.
--
Carl Troein - Círdan / I
1 - 100 of 107 matches
Mail list logo