Hi,
I have my Database in MYSQL and wanna use PHP on Apache
At the starting of the page I have given
I says that mysql_connect
Fatal error: Call to undefined function: mysql_connect()
in /var/www/html/rcmms/appl.php on line 5
Please advice
Sameer
--
http://www.dyp
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
> Does anyone know where rollbacks are stored for innodb tables? I
> assume memory since I keep getting a table full error when trying to
> drop an index. sql,query
I'm not exactly sure what you're asking, but the rollback information
needs
On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote:
[snip]
> In a case like this (where so many rows are covered by the index)
> it's not self evident that a table scan is not faster than an index
> scan.
>
> Especially with many users using the key cache at the same time, a
> tab
On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote:
>
> I believe mySQL uses B-Trees (not binary trees), that's about all I
> know :)
Right. The indexes are B-Tree structures (until R-Trees appear in
4.1, of course).
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magaz
On Thu, May 16, 2002 at 11:32:48AM -0400, Lance Lovette wrote:
> I have partitioned my data such that each client has its own
> database (clientdb1, clientdb2, ... clientdbN). All the databases
> have the same structure (same tables, columns, etc.). This design
> works great except for one caveat
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote:
> Thank you Egor for you reply.
>
> I did read about indexing text column on the mysql site. So I tryed
> to index my column like described. After 1 hour, I had to reboot my
> machine because there was no other way.
No other way?
You could h
On Thu, May 16, 2002 at 12:36:31PM -0400, vlady wrote:
> Hi all,
>
> I would like to know how often (delay in sec.) the slave checks the
> master for new records in the log, and if one can control that .
The only delay is caused by the slave running a query and network
latency. There's not other
On Thu, May 16, 2002 at 11:45:26AM -0400, adam nelson wrote:
>
> I'm finally getting around to working with InnoDB for real :-)
Great.
> Anyway, is there any reason to still use MyISAM on any tables.
Of course there is.
> Concurrency is my biggest problem (Locked tables, etc.).
Then for you
On Mon, May 20, 2002 at 10:10:04AM +0800, Patrick Hsieh wrote:
> Hello list,
>
> I am planing to write a script to telnet mysql server(port:3306) and
> try to verify the server status. When I try something like this:
>
> home:~ #telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhos
On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote:
>
> Hello All,
>
> I recently moved my database from mysql 3.22.29 to 3.23.41, and
> udated all my tables to MyISAM tables. Under ISAM, I could take the
> filesize of the ISD table and divide by the record length to get the
> exact n
Hi all,
Anyone know why sometimes MySQL cannot be stopped? I get messages like this
...
I can stop only with kill -9 pid_number.
Killing mysqld with pid 478
Wait for mysqld to exit\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
Regards,
Valics Lehel
---
Wel it depends on what you want to do. If it's webpages, the file system idea is
ideal, but
if its a binary run by many people on different machines you'll have to map the
directory holding the images
to every machine. That a big no no, due to security risks getting higher. The db idea
is then
Please start here http://www.mysql.com/doc/index.html This is your new best
friend.
//Please don't kill me. I want to learn about databases. I hear MySQL is a
//good start. I have RedHat Linux and I've download and (I believe)
installed
//mysql.
Please read http://www.mysql.com/doc/I/n/Inst
Hi,
Please don't kill me. I want to learn about databases. I hear MySQL is a
good start. I have RedHat Linux and I've download and (I believe) installed
mysql.
Okay, my questions are? What is the difference between the mysql server and
the client program? Do I need both? What is the r
While the link in the note below didn't work, a quick search on Google did
turn up what I needed. Thanks to Rick for turning me to that site.
Here's a synopsis of what got MySQL to build:
$ perl -i -pe 's!^(#define _AIX32_CURSES)!/* $1 */!' include/global.h
$ perl -i -pe 's!^(#define _AIX32_CURS
SQL
>
>
>
> One more point -
>
> Be sure to use the term GNU/Linux -- please
>
> thanks
>
> On 2002.05.20 22:33 Ruben I Safir wrote:
> Can everyone PLEASE post this at the water cooler...
>
> Thanks
>
>
>
> GNU/LINUX BUSINESSDEMO AT CUNY
>
> NYLXS with co-operation with the City Uni
Hi Jeff,
On Tue, 2002-05-21 at 11:15, Jeff Field wrote:
> I think I understand how to set up replication but have a couple unanswered
> questions. I'm hoping the list can help.
>
> I have two servers with MySQL. Each server currently has completely
> different databases, except for the standard
Hi.
Disclaimer: I am not actively using replication currently, so take it
with a grain of salt.
On Mon, May 20, 2002 at 08:15:59PM -0500, [EMAIL PROTECTED] wrote:
> I think I understand how to set up replication but have a couple unanswered
> questions. I'm hoping the list can help.
>
> I have
Hi.
What you see is described in the section about "Known Errors and
Design Deficiencies in MySQL":
http://www.mysql.com/doc/B/u/Bugs.html
In short, the problem is that you ORDER by a column which does not
appear in the SELECT clause. Something that is not allowed in ANSI SQL
and not fully supp
I encountered the same problem, then I simply commented the line in the
system header file
curses.h.
but the error I got is a bit different, it said:
"declaration is not declaring anything" something like this...
another header I modified is the pthread.h
but there is a problem with the AIX vers
I think I understand how to set up replication but have a couple unanswered
questions. I'm hoping the list can help.
I have two servers with MySQL. Each server currently has completely
different databases, except for the standard mysql permissions database.
Server 1 is in production and server 2
Hi. I am trying to build MySQL 3.23.49, and I am having some problems.
If anyone has any suggestions, they would be **much** appreciated :)
I have tried to compile MySQL 3.23.49 a couple of ways under AIX, and
I have gotten this twice (more info below):
xlC -DUNDEF_THREADS_HACK -I./../include -
- Original Message -
From: "Rick Shifman" <[EMAIL PROTECTED]>
To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 10:13 PM
Subject: Re: Very large database
> My OS is Linux, running Apache. Do I have to go with Alpha architecture
> ?
> I need t
Hi Buff,
Try under the optimization section. Though keep in mind the impact on
speed shouldn't be that great.. By the way.. in an ideal design your
primary key
will be an integer ;-)
Buff Smith wrote:
>
> Colin,
>
> Where can I read about the impact of having Primary Keys as VARCHAR? This
Bonjour mysql!
Tue, 21 May 2002 00:30:38 +0200, tu as dit :
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> sql,query
> If you just reply to thi
Colin,
Where can I read about the impact of having Primary Keys as VARCHAR? This
entails an 8 times overhead in Sybase, Oracle, and Microsoft for changing
PK values. It must rebuild the index versus and "update-in-place."
Buff Smith, Maestro
THE BLUES BUFFET BAND
310 280-3593
http://BluesBuf
Hello
I have simple query here that seems to be giving
uneeded info and I am hoping that some mysql pros know
whats going on here. Basically I want the first query
to show the second results. We choose a distinct
a.oprid and if we leave out the "order by a.effdttime
desc" the query gives what I w
Hi.
I was wondering if MySQL can handle 140Gb data and 64Gb index.
I would appreciate any input. Thanks.
Rick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi.
On Mon, May 20, 2002 at 03:31:49PM -0400, [EMAIL PROTECTED] wrote:
> Hi.
>
> I was wondering if MySQL can handle 140Gb data and 64Gb index.
> I would appreciate any input. Thanks.
http://www.mysql.com/doc/T/a/Table_size.html
So the general answer is Yes, but your OS might not.
Bye,
On Monday, 20. May 2002 19:58, SpyProductions Support Team wrote:
> Shouldn't this come up with a list of names from each table that matches?
>
>
> SELECT * FROM table1,table2 WHERE table1.name = table2.name;
>
>
> Does anyone see anything wrong with this query? It keeps giving me an
> empty set
At 3:22 PM -0400 5/20/02, Alex Pilson wrote:
>Is it possible to alter or modify a timestamp field to a different date?
Doh. I found the answer...
The answer is yes.
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL P
Hi.
On Mon, May 20, 2002 at 04:13:36PM -0400, [EMAIL PROTECTED] wrote:
> My OS is Linux
That is too unspecific. Version numbers matter. Filesystem
matters. Distribution matters.
Best idea is probably to ask the vendor or your distribution, as this
will get you the most accurate answer for your
My OS is Linux, running Apache. Do I have to go with Alpha architecture
?
I need to keep 64Gb index in RAM to maintain quick response for web
users. I heard of index clustering across multiple machines - is that an
option ?
Thanks.
Benjamin Pflugmann wrote:
> Hi.
>
> On Mon, May 20, 2002 at 03:3
Webmaster wrote:
> Here's my dilema. Our website runs a quarterly prize giveaway. Currently
> we have an ASP form that gathers the inputed info into a database and
> then sends us an e-mail confirmation of the entry. Our rules
> specifically state that only one entry is allowed per quarter. As I
Hello.
On Mon, May 20, 2002 at 03:22:12PM -0400, [EMAIL PROTECTED] wrote:
> Is it possible to alter or modify a timestamp field to a different date?
Yes.
Bye,
Benjamin.
PS: If you expected a different answer, you may want to consider to
elaborate a bit.
--
[EMAIL PROTECTED]
--
Hi.
On Mon, May 20, 2002 at 03:15:44PM -0400, [EMAIL PROTECTED] wrote:
[...]
> > > SELECT * FROM table1,table2 WHERE table1.name = table2.name;
[...]
> > Else, try to create a test case. I.e. try to create a minimal set of
> > SQL commands which will produce the strange behaviour in order to
> >
I am writing a server that connects to MySQL via DBI (driver and/or ODBC).
I have appended a piece of simplified test code illustrating the problem.
Here are my observations.
- Problem only occurs under Windows (Win2K) and never under Unix (FreeBSD).
- Any child fork that connects to MySQL after
Is it possible to alter or modify a timestamp field to a different date?
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso 5 Web Development
Hi.
This is almost off-topic for this list, as it is more of a programming
problem that a database problem.
Aside from that, you know that you cannot really prevent multiple
registrations as it is easy to get a different mail address?
For the same reason, you probably do not want to tell them t
> Hi.
>
> On Mon, May 20, 2002 at 01:58:25PM -0400,
> [EMAIL PROTECTED] wrote:
> >
> > Shouldn't this come up with a list of names from each table
> that matches?
> >
> > SELECT * FROM table1,table2 WHERE table1.name = table2.name;
> >
> > Does anyone see anything wrong with this query?
>
> No.
>
Hi.
On Mon, May 20, 2002 at 01:58:25PM -0400, [EMAIL PROTECTED] wrote:
>
> Shouldn't this come up with a list of names from each table that matches?
>
> SELECT * FROM table1,table2 WHERE table1.name = table2.name;
>
> Does anyone see anything wrong with this query?
No.
> It keeps giving me a
Hi everyone,
I have a rather obscure problem with hung login connections in mysql.
I've set the wait|interactive_timeout to 120 seconds, but it has no
effect.\
If I attempt to `mysqladmin kill `, the process is marked 'killed',
but never goes away.
Now I know the main problem is with the p
Chris Stefanick wrote :
>
> How do you tell mysql what ip to listen on for connections? I'm remember
> seeing a configuration file for this sort of thing somewhere, but the exact
> file escapes me at the moment. Any help you could give would be great!
>
> Thanks,
> Chris Stefanick
>
Hi,
Look
Here's my dilema. Our website runs a quarterly prize giveaway. Currently
we have an ASP form that gathers the inputed info into a database and
then sends us an e-mail confirmation of the entry. Our rules
specifically state that only one entry is allowed per quarter. As I am
not a programmer (just
Here's my dilema. Our website runs a quarterly prize giveaway. Currently
we have an ASP form that gathers the inputed info into a database and
then sends us an e-mail confirmation of the entry. Our rules
specifically state that only one entry is allowed per quarter. As I am
not a programmer (just
Hi.
On Mon, May 20, 2002 at 07:28:01PM +0300, [EMAIL PROTECTED] wrote:
[...]
> II> select
> II> o.orderid,
> II> o.shipping_date,
> II> o.cancel_date
> II> from orders o, member u
> II> where o.userid = u.userid;
[...]
> II> -
>
I would structure things differently. Have you thought about making each
question a record/row in a table? Then if you add or remove a question, you
don't have to change you table structure or your code if you do it right.
You could also then easily compile stats on a per question basis. Like how
How do you tell mysql what ip to listen on for connections? I'm remember
seeing a configuration file for this sort of thing somewhere, but the exact
file escapes me at the moment. Any help you could give would be great!
Thanks,
Chris Stefanick
-
Shouldn't this come up with a list of names from each table that matches?
SELECT * FROM table1,table2 WHERE table1.name = table2.name;
Does anyone see anything wrong with this query? It keeps giving me an empty
set - but there definitely matches. I even did a LIKE instead of =, takes
longe
Hello
FYI, here is a patch that was submitted through the Debian Bug Tracking
System for bug #145322.
(for those who don't like to upgrade etc.. it is fixed in the 3.23.50)
bye,
-christian-
On Mon, May 20, 2002 at 06:55:19PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> I had a similar problem
try using "which" instead of "whereis"
"Simon K. Chan" wrote:
> Gelu,
>
> Thanks for taking the time to respond. I did this:
>
> whereis mysqld
>
> and get this:
>
> mysqld:
>
> which is really weird, because mysqld is located in /usr/local/mysql/bin
>
> I would appreciate any advice you can off
> Hi,
>
> Firstly, how do i correct that error of BAD text coz i actually
> have a text file which has a HISTORY dump from IE.
>
> Secondly what about the Duplicate Entry stuff, its comming for
> all the URLs why??
>
> Regards
> Sameer
It's been my experience with loading data
Hi,
Please look at "2.4 Post-installation Setup and Testing" in documentation.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message
Hello.
On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote:
> Hello:
>
> I was trying isamchk on my tables. Found one table with deleted blocks.
You know, there would be no reason to repair, except to reclaim the
disk space of the deleted rows?
> Used this option to check:
> ./is
Hi.
I was able to reproduce the behaviour on MySQL 3.23.46. CC'ed to
[EMAIL PROTECTED]
Regards,
Benjamin.
On Mon, May 20, 2002 at 09:40:20PM +0900, [EMAIL PROTECTED] wrote:
> Description:
>
> Query returns an unexpected result.
>
> How-To-Repeat:
>
> run the script below:
> ---
try the command line version of the client first then a GUI based one
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Federico Coco" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 9:57 AM
Subject: Mysql Client
> I'm testing MySQL Client
Jeffrey,
Saturday, May 18, 2002, 5:12:15 PM, you wrote:
JC> Installed MySQL using Fink to the Mac X OS. When attempting to run, I
JC> am getting this error.
JC> ERROR 2002: Can't connect to local MySQL server through socket
JC> '/tmp/mysql.sock'
JC> Help in explaining this error and how to f
Ichinichi,
Monday, May 20, 2002, 3:40:20 PM, you wrote:
II> Description:
II> Query returns an unexpected result.
II> How-To-Repeat:
II> run the script below:
[skip]
II> select
II> o.orderid,
II> o.shipping_date,
II> o.cancel_date
II> from orders o, member u
II> where o.userid = u.userid;
II>
Michael,
Sunday, May 19, 2002, 12:56:00 PM, you wrote:
MBV> Description:
MBV> Possible Bug in UPDATE in MySQL 4.0.1
MBV> The following is the message in the error log...
MBV> Number of processes running now: 0
MBV> 020519 04:55:30 mysqld restarted
MBV> 020519 4:55:30 InnoDB:
Edilson,
Saturday, May 18, 2002, 9:29:38 PM, you wrote:
EVdMJ> I'm converting my tables from MyISAM to InnoDB. One of them returns an
EVdMJ> error
EVdMJ> "Error: 1114 - The table '#sql-7b67_321' is full" - How can i avoid this
EVdMJ> error?
EVdMJ> Table Structure->
EVdMJ> wmkt_client,CRE
I wouldn't know how likely it is to crash, but it will happen eventually,
nothing is perfect :(
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]>
To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[E
Gelu,
Thanks for taking the time to respond. I did this:
whereis mysqld
and get this:
mysqld:
which is really weird, because mysqld is located in /usr/local/mysql/bin
I would appreciate any advice you can offer me! thanks! :-)
--- Gelu Gogancea <[EMAIL PROTECTED]> wrote:
> ...sorry ... i
hi all,
i am working on Mysql to make a table to store following data
Varchar Semester,
Varchar Name,
Varcahr Course,
int Enroll,
int Responses,
int Question#22,
int Question#23,
int Question#24,
int Question#25,
int Question#26,
int Question#27,
int Question#28,
int Question#29,
Does anyone know where rollbacks are stored for innodb tables?
I assume memory since I keep getting a table full error when trying to drop an
index.
sql,query
Thanks for your help!
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
Egor,
I'm running mysql-3.23.36-sun-solaris2.7-sparc.
And yes, I'm pretty sure that the server is installed. I can still
query the database using a DBI script and get results back.
My mysqld is in /usr/local/mysql/bin
When I try running it, I get this error message:
mysqld: Can't change dir t
Hello everyone.
While you are on this subject, can I ask you a question?
Is it possible to store sound, or video in the mySQL database? If so, is it
wise? Are there any performance issues I should be aware of
I just want my users to be able to add their photo, and sound (or maybe a
short video) to
On Mon, 20 May 2002, Jeremy Zawodny wrote:
> On Mon, May 20, 2002 at 03:44:36PM +0200, Michal Ludvig wrote:
> > Hi all,
> > I have a master MySQL server running 3.23.49 on RedHat Linux 7.2 and want
> > to setup a slave on OpenBSD 3.0 (both are i386 archs). So I took the
> > source (3,23,49 as w
I'm testing MySQL Client on Win98, my Server on Suse Linux 7.0.
1- I select database test
2-Commands-->tables-->Choose Tables, I choose f0001, I can see info Found 3
columns in 1 tables
3-Commands-->Tables-->Edit Tables here nothing happens.
4-Commands-->Tables-->Create Tables here nothing happen
Hi Andrei
> well, let's just say if it crashes it will mean longer recovery time, you
> are adding extra processing to the SQL server to handle data it wasn't meant
> to handle, storing it in the file system has the main advantage that if any
Yeah, that "crash" thing really scares me. I guess y
In my experience, you rarely want to fully normalize your data (unless it's
something simple). City and country codes I wouldn't split up because they
never change. Well, alright, there have been quite a few new "countries"
popup in Europe recently. But you don't need to change hundreds or thousan
well, let's just say if it crashes it will mean longer recovery time, you
are adding extra processing to the SQL server to handle data it wasn't meant
to handle, storing it in the file system has the main advantage that if any
changes occurs you can change it faster + easier, besides a database is
I believe mySQL uses B-Trees (not binary trees), that's about all I know :)
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Jan Peuker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 2:59 AM
Subject: MyISAM internal algorithms
> Hi MySQL-Team,
>
are you null terminating the string?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sameer Maggon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:51 AM
Subject: Binary Data mysql_real_escape_
> Hi,
> Please see the code given below::
>
>
I figured it out ...
At 3:22 PM +0100 5/20/02, ds wrote:
>On Mon, 2002-05-20 at 13:34, Ray Zimmerman wrote:
>...
> > For example, given the following data ...
>>
>> CREATE TABLE Object (
>> id int(11) NOT NULL auto_increment,
>> PRIMARY KEY (id)
>> );
>>
>> INSERT INTO O
We have a Vision 4 database with an ODBC driver (AccuCobol), and then I have
a MySQL database that needs to be related to the Vision 4 DB. I need to be
able to do a query something like this; (pseudo-code)
SELECT a.btn, a.custName, b.agingStatus
FROM vision4.tblSubs a, mysql.tblSubscriber b
WHERE
Try:
/usr/bin/mysql -uroot
then when you're connected type:
grant all on *.* to root@localhost identified by 'newpassword';
flush privileges;
and that should work
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Suresh Pun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
Well how large is the BLOB field?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 2:51 AM
Subject: Performances with BLOB fields in mySql
> My application (C++, mySql++, WINNT) is very time-critical
If I were you I would not store a binary file into the database, I'd store
the information required to fetch it from somewhere else like the mySQL
manual suggests
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]>
To: "Sameer Maggon"
Hello,
I've just switched to InnoDB table from myISAM and it's been running pretty
smoothly except on this SQL statement it doesn't use any indexes when there
are, and therefore is very slow.
mysql> explain select
pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from
newsen
That was the answer and solution to my MySQL problem!! Many thanks
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please check:
http://w
/me uses mySQL-Front and PHPMyAdmin for all his Admin tasks
.b
> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2002 15:45
> To: Todd Cary
> Cc: David Ayliffe; 'MYSQL-List (E-mail)'
> Subject: Re: Remote admin of MySQL from Win 2K
>
>
> It is asking
Is it possible to embed MySQL in a stand alone java app? I know you can do
it in c++/vb but waswandering if it was possible to do so in Java.
Thanks for the help!
-Nick
-
Before posting, please check:
http://www.mysql.com/ma
On Mon, May 20, 2002 at 03:44:36PM +0200, Michal Ludvig wrote:
> Hi all,
> I have a master MySQL server running 3.23.49 on RedHat Linux 7.2 and want
> to setup a slave on OpenBSD 3.0 (both are i386 archs). So I took the
> source (3,23,49 as well), compiled natively and configured as a slave. The
* roger:
Try selecting FROM the cities table and JOIN with the recommendations
table.
* andy
SELECT count(DISTINCT user_recommending)
FROM geo.cities c
INNER JOIN recommendations AS t ON t.city_id = c.ID AND c.country_code
= 'gm'
same result. So do u think I would be better off
It is asking for myslq's root password, not the su password.
If you have not set it yet, skip the -p option.
Todd Cary wrote:
>YES! I was missing something: Telnet!! I can log in *BUT* I am unable to
>change the MySQL password.
>
>mysqladmin -h www.myhost.org -u root -p password 'new_password
Myisamchk returns an exit code.
if myisamchk myfile.MYI ; then
do something
else
do something else
fi
Mark wrote:
>Hello,
>
>Is there a way I can do a "CHECK TABLES" which will return an exit code of
>some sort, to use in a shell-script? Looking at the output of a myisamchk is
>fun, bu
Mon, 20 May 2002 08:26:31 -0500, tu as dit :
> [snip]
>> How many records do you have in each table? And just how fast do you want
>> this query to be? 1.5 seconds may be optimal for a query this large.
> Perhaps
>> the only thing you could do at this point is beef up your server.
> Not
Thank you Egor for you reply.
I did read about indexing text column on the mysql site. So I tryed to index
my column like described. After 1 hour, I had to reboot my machine because
there was no other way. All the cpu was bussy and it seemed to me to be an
endless loop. After rebooting I had to r
On Mon, 2002-05-20 at 13:34, Ray Zimmerman wrote:
...
> For example, given the following data ...
>
>CREATE TABLE Object (
> id int(11) NOT NULL auto_increment,
> PRIMARY KEY (id)
>);
>
>INSERT INTO Object (id) VALUES (1);
>INSERT INTO Object (id) VALUES (2);
>INSE
* Fabien Penso
[...]
> Not that large, I got about 8.000 records in each table. I did put the
> body out from the news table, so the news table could be small, and
> news_body which I don't request all the time would be the bigger one.
from your original post:
FROM news_body,news,
Try
* andy
> > > SELECT count(DISTINCT user_recommending)
> > > FROM recommendations t
> > > INNER JOIN geo.cities AS c ON t.city_id = c.ID AND
> > > c.country_code = 'gm'
> I guess this is not an issue on the index. Explain select says it is using
> the index. So I assume, that I did just write dow
.ben,
Monday, May 20, 2002, 3:15:11 PM, you wrote:
b> hi. i'm new to the list and have only been playing with mySQL for a few
b> weeks now, i have a question regrading the syntax of an UPDATE statement - i
b> hope nobody minds me asking.
b> i want to uopdate a table with the data from another,
sfsanchez,
Monday, May 20, 2002, 3:49:45 PM, you wrote:
s> I have the following problem:
s> When I rung the "safe_mysqld" script I got:
s> Starting mysqld daemon with databases from
/home/sanchez/mysql-3.23.49a-pc-linux-gnu-i686/data
s> 020520 14:46:44 mysqld ended
Take a look into host_nam
Mark,
Monday, May 20, 2002, 2:43:32 AM, you wrote:
M> If I want to repair a table, with the REPAIR TABLE syntax, can I do a "FLUSH
M> TABLES WITH READ LOCK" beforehand, or will that lock REPAIR out from writing
M> too?
REPAIR TABLE will lock your table automatically.
M> Thanks!
M> - Mark
--
andy,
Sunday, May 19, 2002, 7:06:00 PM, you wrote:
a> I am wondering if it would be anyhow possible to make a search on a mysql
a> textfield faster. Right now the table contains 294000 entries and takes
a> about 40 MB of space. Is there a way to apply a index with a resonable
a> amount of disk sp
babylonian,
Sunday, May 19, 2002, 10:04:00 PM, you wrote:
bgn> I have a question on license of MySQL C API or MySQL++ API, and
bgn> libmysql.
[hardly skipped]
bgn> Is there any good way, or any misconception in my understanding of
bgn> libmysql license? Any idea is welcome, but please don't sug
Carter,
Monday, May 20, 2002, 4:31:07 PM, you wrote:
C> Can anyone shed some light on this? Have found that others have
C> run into this (via Google) but no resolution and no hits at
C> www.mysql.com.
C> A count(*) query returns fine but trying to select the rows
C> fails (see log snippet below)
* andy <[EMAIL PROTECTED]>
> thank you roger for your reply.
>
> I am wondering how to form the stmt if I do already know the user_id
>
> I tryed this, but it does not work though. Anyhow there has to be a from
> field. But on which table?
>
> SELECT w.website, c.comment
>LEFT JOIN user_websit
Is there a binary package of Mysql-max for HPUX 11.0?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[
According to perror, error 127 = Record-file is crashed. This is a symptom
of a corrupted table.
Check out the MySQL manual, 4.4.6.9, How to Repair Tables. Specifically, try
running myisamchk on the table.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Carter, Robert L (MN65)
1 - 100 of 139 matches
Mail list logo
