On 15-Aug-2001 Stephen VanDyke wrote:
> Ok here's the current method I'm using to find non-distinct records in a
> table:
>
> 1) SELECT DISTINCT column1 FROM table WHERE column2='something'
>
> 2) I get an array and mash it together [PHP: $biglist =
> "'".implode("','",$column)."'";]
>
> 3) SE
On 15-Aug-2001 Michael Bellears wrote:
> Hi,
>
> I have a table with approx 500 encrypted users passwords, and I need to
> insert {crypt} at the beginning of each one ->
>
> eg..
>
> Sample password:
>
> $dfij98unoc8jew9048urf
>
> would become:
>
> {crypt}$dfij98unoc8jew9048urf
>
Hi everybody ...
I need ur help urgently in this: how can we make imigration of database from
server to localhost as backups... Where can I find help in this, plz I need
ur help.
Thanks in Advance:
Hanan M. Khader
_
Get your FRE
On Wed, Aug 15, 2001 at 04:37:15PM +1000, Michael Bellears wrote:
> Hi,
>
> I have a table with approx 500 encrypted users passwords, and I need
> to insert {crypt} at the beginning of each one ->
>
> eg..
>
> Sample password:
>
> $dfij98unoc8jew9048urf
>
> would become:
>
> {crypt}$df
Perl.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 15 August 2001 5:04 PM
> To: Michael Bellears
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: insert(append) text to multiple fields..
>
>
> On Wed, Aug 15, 2001 at 04:37:15PM +1000, Michael Bellear
>
> Incredibly difficult.
>
> select foo,count(*) as cnt from da_table group by foo having cnt >1;
>
ahh, I'd be slapping my forehead right now, except I've never used "having"
Thanks for helping out. :)
Stephen
-
Before po
On Mon, Aug 13, 2001 at 05:23:44AM +0200, Steve Rapaport wrote:
>
> Has anyone successfully resynchronized two replicated Mysql's (most
> recent version)?
>
> I had a big glitch so I followed the directions in the manual: shut
> down the servers, checked the my.cfg settings, copied over the whole
>> How about a UNION query...?
>Too bad MySQL doesn't support them yet ;)
Oops...sorry...I see it is on the TODO list.
Would a MERGE table not achieve the same result as a UNION query? It
appears that a MERGE table acts like a VIEW.
Eric if your Current and Temporary tables have identical str
On Wed, Aug 15, 2001 at 02:00:31AM -0500, Don Read wrote:
>
> update da_table set password=concat('{crypt}', password);
Duh... That's the smart way to do it. :-) No programming required.
I should probably sleep now.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo F
Hi!
I just downloaded the 2.23.41 version of mysql on Solaris 8/Intel/gcc and
installation went well. I can start the mysqld and it works (checked with
mysqladmin status).
The problem is mysql. It reports the following:
#./mysql
ld.so.1: ./mysql: fatal: libcurses.so.5: open failed: No such file
hey guys
I need something similar:
first and foremost, i need all the info about evry customeri have, and then
a count of how may order then have for me. (never got it working)
im guessing something like this
select *,count(*) as orders from C,O group by O.domain having orders>-1
however, this
Date |Wed, 15 Aug 2001 09:53:17 +0200
>From |"Ales Vaupotic" <[EMAIL PROTECTED]>
Hello!
AV> Hi!
AV> I just downloaded the 2.23.41 version of mysql on Solaris 8/Intel/gcc and
AV> installation went well. I can start the mysqld and it works (checked with
AV> mysqladmin status).
AV> The problem is
Hi,
I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1
I'm planning on whiping the HD's completely and start from scratch
and then install the latest RPM's from MySQL's site.
The question is what would be the best way to port my existing
MySQL databases? do a data dump? or just
> simrad_4# safe_mysqld --skip-grant-tables &
> [1] 57953
> simrad_4# Starting mysqld daemon with databases from /var/db/mysql
> simrad_4# mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.38
> Type 'help;' or '\h' for help.
hi,
i have the following table
username | permission
admin | view
testuser | view
user2 | write
admin| write
admin| change
... | ...
i want to select all the permissions from admin. the normal query will
output the following:
admin - vie
In regards to building the source distribution of MySQL on a Solaris/Intel system
(i.e. Solaris 8 for Intel), I have successfully 'built' and installed MySQL 3.23.40,
and found the following tasks need to be performed:
As Phil Dibowitz stated:
You need to have your LD_LIBRARY_PATH set. F
Hi,
When I install mysql that occur something error on solaris.
attachments for you reference:
Hardware Spec.
Generic_105181-19 sun4u sparc SUNW,Ultra-60
CPU: 450Mhz *2
RAM: Memory: 2048M
H.D: 18G *2
Soft Spc.
SunOS i2dev 5.6
Mysql 3.23.41
error message as below:
---
Date |Wed, 15 Aug 2001 03:26:55 -0700
>From |"Ralf R. Kotowski" <[EMAIL PROTECTED]>
Hello!
RRK> Hi,
RRK> I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1
RRK> I'm planning on whiping the HD's completely and start from scratch
RRK> and then install the latest RPM's from MySQL'
I am also in a similar upgrade situation, but I was thinking that all we
need to do to TRANSFER a db is just zip up the db files *.MYD, *.MYI, and
*.frm? This method worked for me transporting my db's from one mysql server
to another. Is this an "ok" method of transfering db? Or are there some
f
Hi,
if you use the fulltext to search for words like "internet.com" my
search allways fails. The reason for is as far as I know that the
dot (".") is used by the parser as a word separator at least when
making the index.
The easy way to solve this would be to split the query in 2 words
"interne
The db files are just like any othere. The only problmes you should have are
if you try to copy the files when thay are beeing used. We have used tar
and gzip with no problmes at all.
I hope this helps a bit.
Simon
-Original Message-
From: Jon Cheng [mailto:[EMAIL PROTECTED]]
Sent: 15
Off the top of me balding head I can think of two things...
One is just leave the dot out and add it in later. Just look for com or couk
netetc
I also know there is a way of telling SQL that . it a char by putting it in
some kind of "" but I can not remember how
I hope this helps a bit..
Ryan Shrout writes:
> This just happened a second time today... that is the most frequent yet.
>
> Please, you have got to help me on this!
>
> Ryan Shrout
> Owner - Amdmb.com
> http://www.amdmb.com/
> [EMAIL PROTECTED]
>
This definitely looks like thread related problem.
Upgrade to kernel 2
Date |Wed, 15 Aug 2001 06:42:30 -0400
>From |"Jon Cheng" <[EMAIL PROTECTED]>
Hello!
JC> I am also in a similar upgrade situation, but I was thinking that all we
JC> need to do to TRANSFER a db is just zip up the db files *.MYD, *.MYI, and
JC> *.frm? This method worked for me transporting my db'
Faine, Mark writes:
> Anybody seen this before:
>
> gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
> -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H
> -I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog
> mysqlbinlog.o mini_client.o
Trond,
sorry, the inline assembly does not compile in gcc-2.96, though it
compiles on an earlier version of gcc, which I use. I forgot to
comment out the offending functions. They are really not needed
in current code.
Below is a patch which defines them out.
Regards,
Heikki
http://www.innodb.
Trond Eivind Glomsrod writes:
> >Description:
>
> mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled.
> 3.23.40 didn't have this problem
>
> Configure statement in spec file ("%configure" is a standard rpm macro, specifying
> CFLAGS and CXXFLAGS and various prefixes
Am Mittwoch, 15. August 2001 12:26 schrieb Ralf R. Kotowski:
> Hi,
>
> I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1
> I'm planning on whiping the HD's completely and start from scratch
> and then install the latest RPM's from MySQL's site.
>
> The question is what would be th
Hi!
On Aug 15, Martin Kjeldsen wrote:
> Hi,
>
> if you use the fulltext to search for words like "internet.com" my
> search allways fails. The reason for is as far as I know that the
> dot (".") is used by the parser as a word separator at least when
> making the index.
>
> The easy way to sol
HI there,
Iam looking for an answer for this problem, I want to imigrate database as
backups from the server to localhost, how can this be accomplished ?
Yours:
Hanan M. Khader
_
Get your FREE download of MSN Explorer at http://e
[EMAIL PROTECTED] writes:
> >Description:
>
> I am using the recommended ./configure options as specified by:
> http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to
> specifiy the GNU ld - the output from ./configure shows that I am
> using the Solaris ld. Perha
Hi,
I have the table:
CREATE TABLE WI_TEXTLISTUS (
TEXTID VARCHAR(50) NOT NULL,
COUNTRY VARCHAR(2) NOT NULL,
LANGUAGEVARCHAR(3) NOT NULL,
TEXTVARCHAR(250),
PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE),
INDEX TEXTLISTUS_X1 (TEXT)
);
and when
Hi,
When I install mysql that occur something error on solaris.
attachments for you reference:
Hardware Spec.
Generic_105181-19 sun4u sparc SUNW,Ultra-60
CPU: 450Mhz *2
RAM: Memory: 2048M
H.D: 18G *2
Soft Spc.
SunOS i2dev 5.6
Mysql 3.23.41
error message as below:
---
Hello all,
I reinstalled mysql3.23.40 server twice on freebsd 4.3, and I am still
having the problem that mysqld would not load up just after booting. I ran
safe_mysqld& as root, and then it loaded fine.
I checked that /usr/local/etc/rc.d/mysql-server.sh exists, but it is not
loading for some re
> >> How about a UNION query...?
>
> >Too bad MySQL doesn't support them yet ;)
>
> Oops...sorry...I see it is on the TODO list.
>
> Would a MERGE table not achieve the same result as a UNION query? It
> appears that a MERGE table acts like a VIEW.
>
> Eric if your Current and Temporary tables ha
Hi Jon,
My guess is you installed from the freebsd ports, which should have
setup your ( ' /usr/local/mysql_install_db') but since this is a
fresh install try running is again to make sure. The at the command
line enter:
/usr/local/bin/safe_mysqld&
If it gives and error message check the 'my-
> > And I was thinking, since a socket is a socket (just a file descriptor)
> NO - a socket is not a file descriptor,
> something like a communication end/handshake point
> read more
> http://orkinos.cmpe.boun.edu.tr/netlab/courses/cmpe476/netprog/SocketsFAQ.txt
>
Sure they are file descriptors,
Hey folks,
I'm new to the list and already have a problem. if you go to
http://www.acnsnet.com/czc/show.php?state=Bayern You can see my problem
with this query. This thing is killin me so if you have any ideas just
shout.
thanks,
chuck
Chuck's Top 10 Things to Remember and Think about!
=
Hello,
I will like to present you, very quickly, with a new Internet
service that i will be putting on line in a few days.
Do you want an account Mail independent of your FAI or ISP ?
What ever your reasons, Avenger Mail System is for you.
Avenger mail System is like Msn, Hotmail, etc . . .
ht
use mysqldump, i.e. if you are in your data dir
/usr/local/mysql/bin/mysqldump -c -h localhost -u user_name -p
db_name | gzip -9 > db_name.sql.gz
hanan khader schrieb am Mittwoch, 15. August 2001, 09:02:49:
> Hi everybody ...
> I need ur help urgently in this: how can we make imigration of da
How easy/hard is it install and run mySQL on a unix server?
-
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
I try to execute mySQL query from VB:
strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order
by Date ASC LIMIT 1;"
strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID=" & GameID &
" Order by Date DESC LIMIT 1;"
strSQL = strSQL & "SELECT @BF as BF, @BL as BL;"
Set R
On 15-Aug-2001 Järkeborn Joacim wrote:
> Hi,
>
> I have the table:
>
> CREATE TABLE WI_TEXTLISTUS (
> TEXTID VARCHAR(50) NOT NULL,
> COUNTRY VARCHAR(2) NOT NULL,
> LANGUAGEVARCHAR(3) NOT NULL,
> TEXTVARCHAR(250),
> PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE)
I just installed mysql-3.23.36-1.i386.rpm, mysqlclient9-3.23.22-4.i386rpm
and mysql-server-3.23.36-1.i386rpm over Redhat 7.1. I followed instructions
both in Redhat's manual and www.mysql.com/doc/P/o/Post-installation.html.
following links to and reading 2.4.2 Problems Starting the MySQL Server
I am running MySQL 3.23.39, and I just installed MySQL GUI 1.7.5-1, running
on Windows 2000. I have several databases already loaded, and have a table
chosen. In the GUI, when I go to the menu commands or hotkeys to create
tables or edit tables, I get no response. Am I missing a step? Or is it
Hi !
MySQL doesn't support sub-queries/selects yet, will be supported from 4.x
version onwards.
Please read the following link for more information about the missing
functionality and how you can make it up.
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#
Missing_Sub
I've had an ongoing problem where the SQL statements in my perl programs
come out rather messily.
Does anyone have specific and general suggestions on how to write embedded
SQL code cleanly in perl programs? Here's an example of an ugly piece of
SQL statement I wrote recently:
$dbh->do
("REPLA
my question was not about subqueries
Mariusz Muszalski
> -Original Message-
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: 15 August 2001 16:29
> To: Mariusz Muszalski; [EMAIL PROTECTED]
> Subject: RE: MySQL + VB problem
>
>
> Hi !
>
> MySQL doesn't support sub-queries/selects y
Hi.
On Tue, Aug 14, 2001 at 10:41:16PM +0930, [EMAIL PROTECTED] wrote:
> Hi Heitzso,
>
> Thanks for your suggestion, and in the absence of feedback from anybody else
> I suspect you're probably right. The system this thing is running on is a
> vastly outdated P150 with 128MB.
With 128MB, you t
Hi.
On Tue, Aug 14, 2001 at 01:31:04PM -0700, [EMAIL PROTECTED] wrote:
> I am trying to do a nested if, but it appears to break my query...
> Here is a sample of what I am trying to, basically validating email
> addresses out of a db:
>
> select IF( (LENGTH( emailaddr ) <= 1 ||
> NOT LOCATE( "
To the contributing party of the following builds:
3.23.33 - DEC OSF (Alpha) [dec-osf5.1-alphaev6]
3.23.38 - DEC OSF (Alpha) [dec-osf5.1-alphaev6]
Have you or anyone else used these versions for replication? I
cannot seem to start the mysql server for the slave after setting up
everything acco
While attempting to build MySQL from the source distribution, I have
received the following message from the configuration utility.
checking for BerkeleyDB... supplied
configure: error: didn't find valid BerkeleyDB: invalid version 3.3.11
(must be
version 3.2.3h or )
We
What is the difference between the 2 UnixWare binary distributions,
mysql-3.23.41-sco-sysv5uw7.1.0-i386-lcudk70.tar.gz and
mysql-3.23.41-sco-sysv5uw7.1.0-i386.tar.gz ? Which one is recommended? I
have tried both and find no obvious operational difference.
Thanks,
Steve
[EMAIL PROTECTED]
-
News from NuSphere -- #8This came from the NuSphere newsletter sent today.
I would like hear from MySQL AB on this issue again since nothing has been
said since the two company meet.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 1
Most likely very hard, if you don't RTFM first :)
d
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 15, 2001 11:40 PM
Subject: Setting up and running mySQL on a unix server
> How easy/hard is it install and run mySQL on a unix server?
>
>
Hello:
I'd like to know how good MySQL is, also what SQL
extension it uses (like T-SQL, PL-SQL or something
else?).
Any comment will be appreciated
_
Do You Yahoo!?
Obtenga su dirección de correo-e gratis @yahoo.com
en http://correo.espano
On Wed, 15 Aug 2001 [EMAIL PROTECTED] wrote:
> How easy/hard is it install and run mySQL on a unix server?
Depends on how you would answer this question:
"How easy/hard is it to run a Unix server?" ;->
If you're confortable using Unix and installing software then I think
you'll find the basic i
I have a table that holds a lot of information. I tried to INSERT something
into it, and received...
DBD::mysql::st execute failed: The table 'fancy_big_table' is full at
./tom_to_mutt.pl line 156.
The table is 4G is size. The table's Max_data_length = 4294967295 (4G)
I'm running the MySQL
On Wed, Aug 15, 2001 at 11:30:44AM -0400, Philip Mak wrote:
> I've had an ongoing problem where the SQL statements in my perl programs
> come out rather messily.
>
> Does anyone have specific and general suggestions on how to write embedded
> SQL code cleanly in perl programs? Here's an example o
I'm researching whether it is possible to store large amounts (30-70MB
files) into mysql columns. It looks as if a LONG BLOB could handle this,
however I read that the communications buffer size can only support up to 16
MB transfers. It also said that you could increase the size of the buffer,
> trademarks. In May, MySQL AB unilaterally decided the contract was no
longer
> valid, and started proceedings to take away our trademark rights. After
Actually, the rights would belong to MySQL AB unless the contract was
drawn up horribly.
> past June, to give us back the trademark rights we h
hi!
> "Venu" == Venu <[EMAIL PROTECTED]> writes:
Venu> Hi !
Venu> MySQL doesn't support sub-queries/selects yet, will be supported from 4.x
Venu> version onwards.
Venu> Please read the following link for more information about the missing
Venu> functionality and how you can make it up.
Ve
Does MySQL running on Solaris take advantage of multiple CPUs?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this threa
I'm having trouble with what appears to be a case sensitivity issue.
Essentially, when I use the "right" case for a table name, the query fails,
but when I use the wrong case, the query succeeds.
Here's my table list:
mysql> show tables\g
++
| Tables_in_ac |
++
I'm not an SQL expert but if FreeBSD supports > 4GB files than you should
check your "MAX_DATA_LENGTH" properties on the table you're using. You can
do this by running SHOW TABLE STATUS on the table. I believe you can use
ALTER (or on create table statements) to change this value.
Hope this helps
Look into MAX_ROWS... ie:
alter table mytable max_rows = 1
ryan
- Original Message -
From: "Nathanial Hendler" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, August 15, 2001 12:19 PM
Subject: Table size limitations...
>
> I have a table that holds a lot o
I'm attempting a source installation of mysql-3.23.40 on a Solaris 7 SPARC
server. the compile process completed without any errors. After reading
the various docs, I located the mysql_install_db script and executed it.
When running the mysql_install_db script, I recieve the following error
MySQL 3.23.36
Using the LOAD DATA command, I was able to read the first field of user.MYD. I think
I should
be able to load the rest of the table with a little bit of playing around...
I think with a little bit of ingenious delimeter specification, etc, anybody should be
able to
load any tabl
Ray Gurganus writes:
> I am running MySQL 3.23.39, and I just installed MySQL GUI 1.7.5-1, running
> on Windows 2000. I have several databases already loaded, and have a table
> chosen. In the GUI, when I go to the menu commands or hotkeys to create
> tables or edit tables, I get no response. A
hey Mariusz
what i usually do is like this:
Set SQL1 = conn.execute("select * from tbl_blah")
Set SQL2 = conn.execute("select count(*) as hops from tbl_pong where
row_poof='&SQL1("blah")&'")
and so forth
- Doc
" database sql query table < -- as requested "
> I try to execute mySQL query f
Trevor Linton writes:
> I'm researching whether it is possible to store large amounts (30-70MB
> files) into mysql columns. It looks as if a LONG BLOB could handle this,
> however I read that the communications buffer size can only support up to 16
> MB transfers. It also said that you could inc
Kevin writes:
>
> Does MySQL running on Solaris take advantage of multiple CPUs?
>
Yes, automatically ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/
Ryan Shrout ([EMAIL PROTECTED]) writes:
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND=
> =20
> 24424 mysql 18 0 6116 6116 2196 R99.9 0.5 4:05 mysqld =
> This is after a mysqld restart -- It restarted, but didn't work because =
> this single
In the last episode (Aug 15), Nathanial Hendler said:
> I have a table that holds a lot of information. I tried to INSERT
> something into it, and received...
>
> DBD::mysql::st execute failed: The table 'fancy_big_table' is full at
> ./tom_to_mutt.pl line 156.
>
> The table is 4G is size. Th
On Wednesday 15 August 2001 11:30, Dan Nelson wrote:
> In the last episode (Aug 15), Nathanial Hendler said:
> > I have a table that holds a lot of information. I tried to INSERT
> > something into it, and received...
> >
> > DBD::mysql::st execute failed: The table 'fancy_big_table' is full at
>
I'm not sure how you were able to do that. Especially since you didn't
provide exactly what you did.
But here's what I get as ROOT (all privileges):
mysql> load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table
t;
ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must
This is what I did:
load data local infile '/var/lib/mysql/mysql/user.MYD' into table data;
At first I did it without the 'local' keyword. But with 'local' keyword it works.
==
On Wed, 15 Aug 2001 14:51:44 -0400
"Andrew Schmidt" <[EMAIL PROTECTED]> wrote:
Here are the perms on the mysql db files /var/lib/mysql/mysql
Also, I was logged into mysql with a plain user 'jose' that had access to only his
db, 'jose'
grant select,insert,create,drop,delete,alter on jose.* to jose@localhost identified by
'jose';
-rw-rw1 mysqlroot
What are the permission in your /var/lib/mysql/mysql directory?
here's what I get:
mysql> load data local infile '/usr/local/var/db/mysql/mysql/user.MYD' into
table t;
ERROR:
File '/usr/local/var/db/mysql/mysql/user.MYD' not found (Errcode: 13)
mysql>
and here is the file
[dev-405:andrew] ...
Hello all,
Recently I made an attempt at setting up phpMyAdmin to allow my colleagues to
interface with mySQL easily. In doing so I set a password for the root user, and
placed the settings in my config file. When a new version of phpMyAdmin was released,
I upgraded without backing up my old co
Hi
i have successfully installed the 3.23.39 version of mysql. but the
3.23.41 version throws the following error when the mysqld daemon is
started
010815 15:14:42 mysqld started
010815 15:14:42 Warning: setrlimit couldn't increase number of open files
to more than 64
010815 15:14:42 Warning:
how do you make a connection in C?
On Wed, 15 Aug 2001, Steve Rickard wrote:
> What is the difference between the 2 UnixWare binary distributions,
> mysql-3.23.41-sco-sysv5uw7.1.0-i386-lcudk70.tar.gz and
> mysql-3.23.41-sco-sysv5uw7.1.0-i386.tar.gz ? Which one is recommended? I
> have tried both and find no obvious operational diff
I have 2 questions:
1.How to enable log and update log with MySQL rpm installation?
In /etc/my.cnf? The default installation disable them, as shown
with "mysqladmin -u root -p variables"
2.In rpm installation, there is a mysqld under /etc/init.d. And
to start MySQL server at booting ti
My humble response to NuSphere, sent this morning to various and sundry of
their email addresses. Please make your opinions known to NuSphere, it
can't hurt.
Dear Sirs:
I believe that your decision to sue MySql AB, the creators of one of the
most popular products to come from the Open Sour
Try it like this --
SELECT @BF:=Date FROM Results WHERE GameID=1 ORDER BY Date ASC LIMIT
1;
SELECT @BL:=Date FROM Results WHERE GameID=1 ORDER BY Date DESC LIMIT
1;
SELECT @BF AS BF, @BL AS BL;
"Mariusz Muszalski" <[EMAIL PROTECTED]> wrote:
Look at this MS SQL:
Declare @BF ch
MySQL is pretty fast and very reliable. It's also simple to use. It
supports standard ANSI-92 SQL, as far as I can tell, and the standard
distribution does not have certain features such as:
- triggers
- stored procedures
- referential integrity
- transaction support (this may have been implemen
Dear Chris,
1. Stop the MySQL server and restart mysqld with the --skip-grant-tables
option.
2. Use the GRANT command to set up a new root user / superuser.
3. Stop the MySQL server and restart it.
Manual pages: http://www.mysql.com/doc/R/e/Resetting_permissions.html
and http://www.mysql.com/doc
www.mysql.com
click on documentation
scroll down to the C interface documentation.
- Original Message -
From: "Tobias Wennerberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 15, 2001 3:44 PM
Subject: C and mySQL
how do you make a connection in C?
> That agreement also allows NuSphere to release MySQL
> under the GPL license forever and print and distribute the
> manual.
It doesn't seem that this is what is at stake, however.
Would you say that MySQL AB wishes Nusphere to stop
distributing the official GPL'd distribution of MySQL?
Would
mySql.org's position (whomever they are)
***
Dear Philippe:
mySQL.org is a not for profit organization dedicated to promoting
and further enhancing the mySQL database engine. Like all open
source projects we welcome community input to help enhance the
product.
The MySQL AB company is a commerc
> - transaction support (this may have been implemented through Gemini, but
> the legal status of this contribution appears to be in question now)
Transactions are also supported with BDB and InnoDB tables afaik ...
> If you want to embed a lot of the business logic in stored or needb other
of
>
Can somebody running redhat using the mysql rpm provided by redhat, version 3.23.36-1,
please try
this and verify if it exists as a bug for you too?
Thanks,
Jose
==
On Thu, 16 Aug 2001 03:01:20 -0700
Jose de Leon <[EMAIL PROTECTED]> wrote:
> This is what I
At 01:38 PM 8/15/2001 -0400, Michael T. Babcock wrote:
>> trademarks. In May, MySQL AB unilaterally decided the contract was no
>longer
>> valid, and started proceedings to take away our trademark rights. After
>
>Actually, the rights would belong to MySQL AB unless the contract was
>drawn up hor
> I'm having trouble with what appears to be a case sensitivity issue.
> Essentially, when I use the "right" case for a table name, the query fails,
> but when I use the wrong case, the query succeeds.
Well, it seems to depend on the system you are using. I noticed
that when I created tables thro
Jose--
Are you running mysqld as 'root'?
Run it as 'mysql' and change the group membership of the data directory and
its contents to 'mysql'.
Vadim.
Jose de Leon wrote:
>
> Here are the perms on the mysql db files /var/lib/mysql/mysql
>
> Also, I was logged into mysql with a plain user 'jos
Hello,
I'm very new to MySQL and have posted a few mails regarding replication in
mySQL. I'm still having problems ! Can someone please send me a step by
step guide on how I can setup replication between my ISPs MySQL database and
one I wish to have and use locally. I have already a database c
Also regarding this matter, is it possible that I would on a local copy of
the data on my own computer and it is then replicated automatically back to
the ISP database ?
Thanks
Neil
- Original Message -
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, A
Everyone, please: Let's not have another round of "Let's
all go bash NuSphere".
Yes, I too, am interested in the case -- but let's have
the details - and not least *facts* - from the people who
are actually involved in this dispute.
I think some of Justin Farnsworth wise words from July 18
bea
1 - 100 of 127 matches
Mail list logo
