[EMAIL PROTECTED] wrote:
>
> 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:
>
> database,sql,query
>
> If you just reply to this message, and include th
Ok. Now you make more sense. This is from my personal point of view. In
general, I prefer speed, ease of use and ease of maintenance. What I like
about mysql is that you can choose which features to build into it when
compiling. For example, standard mysql does not come built with transaction
Hi,
Sorry for worrying U'll.
I want to know how can I get information about the Memory usage, can I get
details about Database Usage (How much space have used In each database).
Thanx.
--
Dilkushan Karunaratne,
# 50/1A, Sri Indrajothi Road,
Ratmalana,
Sri Lanka.
Tel 94 1 715716
Hello people,
Anyone know how can I _useful_ (without data loss) link
database with tables contains unsigned short columns
thru MyODBC for ugly systems like M$ Access ???
I send this message to MyODBS list, but have no answer...
--
Best regards,
Pedro mailto:[EMA
Sorry for the topic if if is off, but there are more uses for databases than
just in PCs. I don't mean writing an OS explicitly using/for databases
(like PalmOS), but rather, what features would better support modern
databases.
Ben Garvey
- Original Message -
From: "Rolf Hopkins" <[EMAI
Hi there,
Do a find command...:
%find / -name "mysql.sock"
Then when you start safe_mysqld do it with the switch :
%./safe_mysqld -S /whatever/the/path/mysql.sock
And it should work.
Alan
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 7:23
The reason I asked...
quote from another mail list I am on...
"IMO - mysql is just a disaster you are inviting on yourself.
you should see the responses to some recent bug reports - "we broke it
purposely because it made things faster..."
I looked over the code for the client libraries when we
[EMAIL PROTECTED] wrote:
>
> >Description:
>
> I can use the binary distributions of MySQL without any problems. I'm
> currently using the binary distribution I got from Slackware, and it
> works fine. (That's the version reported by mysqlbug.) Unfortunately,
> binary distributions don't cont
Hi All!
Has anyone got mySql running on PhatLinux? As I understand it, Phat is
designed to run on a Windows partition - intel machine.
If so, which binaries are used? (or which src file)I was thinking of
trying the following distribution:
Linux (Intel libc6 systems) [pc-linux-gnu-
This is rather off topic but for what it's worth, to me, it doesn't make
much sense in gearing OSs more towards databases. PCs do far more than just
databases.
- Original Message -
From: "Ben Garvey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 1:52
Subject: d
Don't know what the problem might be, but this is based on my experience.
I'm using MyODBC 2.50.36, my linux server is English, my development
platform is English but clients machines are Chinese OS. My program
supports multi-language. Users are able to type in Chinese and it goes into
the data
I don't think I can answer all your questions as I use Linux.
Are you sure it was the DB that went down or their whole system crashed? I
can believe the latter more than the first. Ever since I switched from
Windows to a unix based system, I have had far less troubles with the server
crashing.
>Description:
I can use the binary distributions of MySQL without any problems. I'm
currently using the binary distribution I got from Slackware, and it
works fine. (That's the version reported by mysqlbug.) Unfortunately,
binary distributions don't contain all the files necessary (such as
sha
Hi,
Are you guys going to start releasing RPMs built for the 2.4 kernel anytime
soon? We would prefer to use the RPM, but we've had some flakiness when we
run it with 2.4.
- Original Message -
From: "Keith Stokes" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 22:15
Subject: PROBLEMS UNDERSTANDING FLOAT/DOUBLE COLUMN TYPES
> PROBLEMS UNDERSTANDING FLOAT/DOUBLE COLUMN TYPES
>
> First could you clarify the contradictions
I'm a newbie and sorry if this is vague.
I'm running into more and more clients that would like to connect to another
database. Say there inventory tracking software. I was wondering if there
was a good book out there or a web site that might have some info that I can
use to start thinking about
This is an FAQ. Check that the mysql server is running and that the socket
file is in the right place with the correct permissions.
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail List" <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 7:56
Subject: Hmmm. Error
Hello,
First, sorry the lengthy post. I have a couple of questions that are very
important for me to get answered. I we moved from using MS Access to MySQL
for our Point of Sale app. We do the transaction rollbacks, commits in the
application layer so the fact that MySQL lacks this functiona
I'm in the process of moving SQL data from one server to another (Linux) -
The tables on the new DBase server are not identical to the old - Is there a
way to import only specified fields data from the old to the new ?
Thanks in advance,
Regards,
MB
---
Dear Kevin -
(I can't resist the obvious quip.)
Kevin Pratt writes:
> I have heard mysql is the access for unix...
Yes, like emacs is the notepad for unix.
Yours (in gentle jest) - Billy
-
Before posting, please c
Hey,
Hopefully this isn't a newbie question. I'm currently using MySQL 3.23.35a
and I'm looking how to get an "olympic" style average of values in a table
where the top and bottom n scores are dropped from the average calculation.
Example:
table: opinions
columns: id, score
values:
19
Hi.
On Thu, Apr 19, 2001 at 02:27:09PM -0700, [EMAIL PROTECTED] wrote:
> This may have been covered in the past; but, marc.theaimsgroup isn't
> responding so I can't run my normal search.
This is even covered in the fine manual ;-)
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutori
Hi.
On Thu, Apr 19, 2001 at 05:41:54PM +0200, [EMAIL PROTECTED] wrote:
> Hallo Leute,
>
> in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder
>||''.
> z.B.:
>
> SELECT *
> FROM tabelle
> WHERE eigenschaft||'' = 'text';
>
> SELECT *
> FROM tabelle
> WHERE id+0
The biggest help is from INSTALL-SOURCE in the source tarball.
==
The basic commands you must execute to install and use a *MySQL* binary
distribution are:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr
More like it has already started. Do "ps -ef | grep mysql" to find out.
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Steve Tuckner" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 0:21
Subject: Re: Newbie Linux 7 installation question
> c
At 3:29 PM -0500 4/19/01, Wade DeWerff wrote:
>Is the common way to index a site, then place that into a database? If so
>whats the best(easiest) way to index a site? Thanks
>
Well, that's a LONG answer to a short question, but two common places
to start are
http://www.mnogosearch.ru/
Hi Everybody!
Anyone with any idea what to do I get this error
message:
ERROR 2002: Can't connect to local MySQL server
through socket
'/usr/local/common/mysql-3.23.33/data/mysql.sock' (13)
H. Thanks for your time and advice.
Simon
Hello,
I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
I'll cut right to the chase - I've followed the directions in the manual for the
binary install on Linux. but every time I start up the mysql daemon and do a pstree
-laup, it's running as root.
This is on a develop
Why not change the sql documentation to say:
\my.ini (e.g., c:\windows\my.ini) Global options
instead of:
windows-system-directory\my.ini Global options
It's understandable why the author might have originally thought to
write it that way, but to defend it on the grounds tha
Hi Matthew,
- Original Message -
From: "Matthew P. Marino" <[EMAIL PROTECTED]>
> You've got a long way to go. "tar" is short for tape archive. It is an
> ancient unix utility that takes directory and file data and builds it into
a
> contiguous data base file. This is for portability
I'm sorry to write again, but I've gotten no response and I'm totally stuck.
I'm trying to install the latest version of MySQL on a P3 running Redhat
6.2. When I run mysql_install_db, it hangs after it reports "Installing all
prepared tables." I've tried setting different permissions and everyt
I have a very large table, where one of the columns is
color enum("red", "blue", "black")
The distribution of values is 90% black, 8% blue, and 2% red.
I want to be able to randomly select 10 rows matching a certain color from
the table.
Of course,
select * from my_table where color
Given the following table:
Name varchar(128),
CodePageEncoding varchar(32)
that a select like this could be done
select Name, CodePageEncoding
from table
group by CodePageEncoding
order by CODE_PAGE_SENSITIVE_FUNCTION(CodePageEncoding, Name);
This would produce a report/resultset like the foll
Hi,
We have noticed that some MySQL users are having problems to install the
MyODBC driver, receiving errors messages like this:
An error occurred while copying C:\windows\system\mfc30.dll.
Restart windows..
Generally this happens because the ODBC core stuff is ready installed
and the MyODB
John,
I don't think anyone can say for sure which is 'better'. MySQL is used in a
different kind of environment than Oracle. Oracle is designed for an
enterprise environment, where many different applications are used
simultaneously to add or retrieve data from a central data store. MySQL is
de
if you've downloaded the binary, then you don't need to configure, just like
the error says...
read this page,
http://www.mysql.com/doc/I/n/Installing_binary.html
then this one:
http://www.mysql.com/doc/P/o/Post-installation.html
hth.
(and don't forget to cc replies to the list [[EMAIL PROTECTED
Hi!
On Apr 19, Braxton Robbason wrote:
> Hi all,
>
> I'm creating a fulltext index on a 400MB table, and the creation process
> gets very slow. It's fast for the first 50MB of the index, and then it
> grinds to what seemed like a halt after days. My question is - is there
> anyone who's created
Kevin Pratt wrote:
>
> I have heard mysql is the access for unix... i would like to hear about
> comparisons with Mysql SqlServer and PostgresSQL
>
> Kevin
differences are in the archives for this list as well as on the mysql.com
list.
Mysql doesn't compare will to Access. access is simply a
Hi,
We will delevope web based applications to put the databases on MySQL instead of
Oracle.
We will have plateforms such as:
1). IBM desktop 400 mhz processor 256 MB RAM 6 GB plus 20 GB hard drives Win2000
Server installed; or
2). Digital UNIX 500 mhz Alpha processor 1 GB RAM 35 GB RAID
I tried using the sql_create_N macros, but my compiler crashes with an
"INTERNAL COMPILER ERROR". I'm using VC++ 6.0 sp5. I spent several days
trying to work around that and finally went back to the sql_create_basic_N.
Steve
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PR
On Thu, 19 Apr 2001, Agustin Eloy Barrios Arteaga wrote:
> I need translate this SQL to any SQL that work in MYSQL
>
> SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp where
> cons.id=cp.idc and cp.idp = 1);
>
I think it'd be:
SELECT * from cp LEFT JOIN cons ON cp.idc=cons.id WHERE cp.
This may have been covered in the past; but, marc.theaimsgroup isn't
responding so I can't run my normal search.
I'm trying to extract rows with max values within unique groups - NOT just
the max values. In very watered down terms:
Given:
CREATE TABLE test_table (
number tinyint(1) unsigned
Es gibt eine deutsche MySQL-Sendenliste:
There is a German MySQL mailing list:
[EMAIL PROTECTED]
"subscribe mysql-de [EMAIL PROTECTED]"
-Philip Mak ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/m
I have heard mysql is the access for unix... i would like to hear about
comparisons with Mysql SqlServer and PostgresSQL
Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Is the common way to index a site, then place that into a database? If so
whats the best(easiest) way to index a site? Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Usually you need to set your environment variable LD_LIBRARY_PATH to include
the libstdc++.so.2 location (/usr/local/lib maybe ?) when you start mysqld.
Ping Lu
Cable & Wireless Global
Network Tools and Analysis Group, USA
W: +1-703-292-2359
E: [EMAIL PROTECTED]
> -Original Message-
>
Request help getting myself setup with my website host. They offer mySQL
but do not know very much about it and we seem to be stuck.
the error I am getting is this:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
where "userid" is my userid and "xx.xxx.xxx.xxx" is my dynami
hi.
the easiest way would be to use the port.
otherwise ./configure (--with-some-options); make; make install and hope for
the best...
more realistically, do the commands one by one, and deal w/ the error
messages as they pop up.
is there specific information that is not on these pages
( http://
I need translate this SQL to any SQL that work in MYSQL
SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp where
cons.id=cp.idc and cp.idp = 1);
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
cd /usr/ports/databases/mysql323-server
make
make install
reboot
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Larry Caragay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19,
> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes:
MW> We are just now building the first MySQL-Max binaries with support for
MW> Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM
Does this imply that BDB tables are stable enough for production use,
or is it still con
I'll try to translate this as best I can. The sender can likely understand
the response in English, so fire away. If you send them English he'll
probably try (and probably can use) English. If anyone on the list can do
a better job of translating this, please feel free to correct me!
Keep in
Hi there,
I installed mysql 3.22.32 on Solaris 8 and everytime I am trying to run mysqld it
gives me the following error
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No
such file or directory
Please Advise,
My email address is [EMAIL PROTECTED]
Th
Hello, I have been looking into some Access Violations I am getting with a
client app accessing a MySQL database on an NT 4.0 box. I have read the
article 24.1.5 How to make a Thread Safe Client but I am still some what
confused. Is there a limit to the number of threads one database connectio
Are you running the version that came with Redhat 7.0? I had the same
problem and just downloaded a newer version from mysql.com and installed it.
That seemed to fix the problem.
> -Original Message-
> From: Goksel Misirli [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 10:24 AM
Hi, Dear Sir or Madam,
I like mySQL very much and today I tried to use mySQLGUI (win32 static binary
1.7.4-2), but I found edit table and create table in commands/tables menu have no
functions. is there any problem?
Sincerely
Edwin Zhang
Would anyone out there have the installation instruction for Mysql for a
FreeBSD 4.2 box???
Larry
P.S. Thanks in advance...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Sasha and Monty,
Nico had a problem in replication with InnoDB tables. Luckily
3.23.37 seems to solve his problems. But, meanwhile I was studying
'load table from master' and noticed that it uses a function
net_read_dump which is only defined for MyISAM tables.
The following printout is from 3.23
it is in the FAQ.
On Thu, 19 Apr 2001 20:23:39 +0300, Goksel Misirli wrote:
>I can't start mysqld . Can you help me?
>
>Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock"
>
>
-
Before posting
select word, count(word) as total
from search_words
where word is not null
group by word
order by total desc
limit 20
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Correct syntax?
Thanks for help
"select word, count(word) as total from search_words where word IS
NOT NULL group by word order by total desc limit 20"
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 19 Apr 2001, Graham Nichols wrote:
> Thanks for help from this group I'm using
>
> "sel
Believe me, it's not my first choice I hate working with M$ as much as
the next guy. Unfortunately, not every project leans in the direction I want
it to. As far as the LIMIT function goes I think MySQL has spoiled me. The
only easy way to do pagination in ASP is through the ADO Object. The p
Hello, my name is Ben Garvey and I'm doing a research paper on whether
operating systems should be rewritten to offer more support for databases.
What type of operating system features could benefit database implementors?
Thank you in advance.
Ben Garvey
American University
202-332-6218
---
The put the password immediately after the -p ( no space ).
Wade wrote:
>
> problem is I have to use mysqladmin variables -u root -p
> PASSWORD:x
>
> I tried piping the less command at the end of -p but it didnt work
>
> > Of course it does.
> >
> > mysqladmin variables | less
---
Hello,
When I am trying to install mySQL on a Solaris8 server I get the
following error:
# ./configure
.
.
.
checking return type of sprintf... configure: error: can not run test
program while cross compiling
Any idea what I need to do?
I have tried to add the
ac_cv_sys_restartable_syscalls=$
Why would you want to re-use the deleted ID?
That would be a poor design.
When you insert a new record with an autoinvcrement, last_insert_id()
will tell you what it
is so you can insert it in dependent tables.
Fates wrote:
>
> I am trying to understand references in tables and using primary ke
Check out some testimonials at this web site
http://netgraft.com/~mbac/research/mysqlmyths.html
---
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "johnd" <[EMAIL PROTECT
Hi all,
I'm creating a fulltext index on a 400MB table, and the creation process
gets very slow. It's fast for the first 50MB of the index, and then it
grinds to what seemed like a halt after days. My question is - is there
anyone who's created fulltext indexes on this much data who can assure m
Hello again
here send al SQL to generate the database to test in MYSQL,
for example in case that I Question in the query that a Productor
TECUN (1) no cant be return, pepe(2), lolo(1)
CEIS (2) no cant be return lolo(1)
PCMAX (3) no cant be return pepe(2)
A Numbres are the ID In the table cp th
You see I have written a small chat server is perl where when a user wants
to chat he simply types the message it gets recorded into mysql and another
program keeps reading the mysql databse and shows the messages. Now, the
same is not yet deployed; but, I fear when I deploy it the program will
co
Well,
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists.
Neil Mussett wrote:
>
> >Description:
> I cannot use the application because of socket problems. This
> problem occurs with both the binary and source versions. I get the
> following error:
>
>
I just loaded MySQL 3.23.37 binary on my IBM PowerPC based RS6000 computer running AIX
4.3.3.0. When I started MySQL server daemon by executing "safe_mysqld", I got
following error message:
mysqld started on Thu Apr 19 10:58:40 CDT 2001
exec(): 0509-036 Cannot load program /usr/local/mysql/li
Thanks for help from this group I'm using
"select word, count(word) as total from search_words group by word order by
total
desc limit 20"
to locate the top 20 words in a database of website search engine words.
The database had been altered to include an extra column, other than the
'word' col
>We are planning to move on to MySQL.
>Could you send us your opinions about MtSQL. It will greatly help us to
>make decision and to use MySQL.
I love MySQL.. but there are others too. I think their are still some pros
and cons.. given time I think the pros will increase..
Although other datab
Hi,
I am using SuSe 7.0 with glibc-2.2-9 installed and installed mySql from
SuSe's ftp server with yast. Contrarily to my normal experience this did not
work:
All errors I detect (by making mysql_install_db or by starting the daemon
with mysqld --skip-grant &) come down to the following error me
I can't start mysqld . Can you help me?
Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock"
problem is I have to use mysqladmin variables -u root -p
PASSWORD:x
I tried piping the less command at the end of -p but it didnt work
> Of course it does.
>
> mysqladmin variables | less
-
Before posting, p
Wade wrote:
>
> when I run the command, (in linux) it serves up the variables. But the
> variables seem to be much more than what is listed in Paul Dubois' book. So
> I am unable to view all of it in terminal. The less command doesnt work with
> it either so how can I view mysqladmin variable inf
My sugesstion is that you get yourself a decent old workstation, one that you would
probably consider ready
for retirement if it were to still be running MS something...Like say a p200ish
machine with a couple of
gig on the disk and say 32 but prefereably 64M of ram. Slap a cheap NIC, like the
Hi,
Sorry for worrying U'll.
I want to know how can I get information about the Memory usage, can I get
details about Database Usage (How much space have used In each database).
Thanx.
--
Dilkushan Karunaratne,
# 50/1A, Sri Indrajothi Road,
Ratmalana,
Sri Lanka.
Tel 94 1 715716
I am trying to understand references in tables and using primary keys with
auto increment option as a reference to all tables:
What is the best way to reference other tables? I have three tables:
menus, categories, and links. I also have an ID field in each table that
uses the autoincrement opt
Up the number of connects that MySQL allows, or use persistent connections.
At 06:00 PM 4/19/2001 +0200, Jacob Friis Larsen wrote:
>We often get a message from MySQL that there are too many connections.
>
>What can we do ?
>
>Should we use connect rather than pconnect ?
>
>We use Php 4.04pl1, Lin
>Description:
I cannot use the application because of socket problems. This
problem occurs with both the binary and source versions. I get the
following error:
[localhost:/usr/local/mysql] root# ./bin/mysqladmin -u root -p
password 'g7ioyhe'
Enter password:
I'll try to translate:
in oracle one can turn off indexes within a query (full-table-scan) by
using: +0 or ||''.
for example:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
can one do this with mysql?
- Original Message -
From: "Hagen Schmied
> We often get a message from MySQL that there are too many connections.
>
> What can we do ?
>
> Should we use connect rather than pconnect ?
>
> We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Yes, you should.
That, or increade the amount of allowed connections, or decrease t
when I run the command, (in linux) it serves up the variables. But the
variables seem to be much more than what is listed in Paul Dubois' book. So
I am unable to view all of it in terminal. The less command doesnt work with
it either so how can I view mysqladmin variable info?
--
You're posting to the mysql list asking us how it is? Come on... that's
like asking MS how good Windows 2000 is.
MySQL ROCKS!
At 11:40 AM 4/19/2001 -0400, johnd wrote:
>Hi,
>
>We are planning to move on to MySQL.
>Could you send us your opinions about MtSQL. It will greatly help us to
>make
chown -R mysql /var/mysql
Steve Tuckner wrote:
>
> When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in
> /var/log it has the following:
>
> 010418 21:19:47 mysqld started
> 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errno: 13)
> 010418
Well it is exactly depends on who you are , what are you doing ,
on which platform , for which purposes etc...
- Original Message -
From: johnd <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 6:40 PM
Subject: Run time version of MySQL
Hi,
We are planning to
We often get a message from MySQL that there are too many connections.
What can we do ?
Should we use connect rather than pconnect ?
We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Regards Jacob
-
Before posting,
Hallo Leute,
in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder
||''.
z.B.:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
Geht das bei mySQL auch?
Hi,
We are planning to move on to MySQL.
Could you send us your opinions about MtSQL. It will greatly help us to make decision
and to use MySQL.
Thanks.
Regards,
John Ding
On Thu, Apr 19, 2001 at 11:12:23PM +0800, john1 wrote:
>
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x14):undefined reference to 'open64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> mf_format.o(.text+0x201):undef
>seems redundant and I really hate the fact that LIMIT is not supported.
>Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0
>are both appreciated.
M$??.. thought this was about MySQL :-)
I wouldn't know.. I do know you can find a few newsgroups somewhere at
news.microso
When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in
/var/log it has the following:
010418 21:19:47 mysqld started
010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010418 21:19:47 mysqld ended
Below is the my.cnf file
[mysqld]
datadi
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
Make sure the directory /var/lib/mysql is world readable and searchable.
Craig Pickup wrote:
>
> I have MySQL running on our server with Apache and php4.
>
> If I try connecting to MySQL server via php I get the error:
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL serv
SQL Server will allow you to limit a SELECT to the first n rows, but not (to my
knowledge) to skip a number of rows before returning the desired rows.
The mechanism used is SET ROWCOUNT (6.5 and 7.0) or TOP (7.0). The difference is that
SET ROWCOUNT limits the output rows before applying an OR
"Sica, Bill" wrote:
> For instance, say the book price is
> $19.44. You also have a base cost of $18, and 8% tax. You can always write a
> query to find out the total cost of any book, and get rid of anything to do
> with the total cost in your tables.
For all the people who've never designed lo
Nico,
it came to my mind that possibly 'load table from master' uses
LOCK TABLES to speed up processing in the slave. In 3.23.36
there was a bug with LOCK TABLES in connection with InnoDB
(named the Wisconsin bug).
It might help if you download and compile the new 3.23.37
from the MySQL website.
1 - 100 of 127 matches
Mail list logo
