tai huijia wrote:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
You need to log in (to MySQL) as root if you want to see the mysql
database. It contains sensitive information
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
+--+
Rakki wrote:
Hi,
Can anybody give me the optimized query for full-text searching?
User will be entering one or more words in a text box and I wanted to
display the records which has atleast one word of the user input.
Assume that my table has two fields USER and DESCRIPTION.
I wanted to
Hi,
Can anybody give me the optimized query for full-text searching?
User will be entering one or more words in a text box and I wanted to
display the records which has atleast one word of the user input.
Assume that my table has two fields USER and DESCRIPTION.
I wanted to search the DES
hi Friends,
I have a WAP portal which is running based on mysql database. That's meant that
contents has been stored in the data base.
wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now
now problems with the content retrieving. WAP site hosted in REDHAT Linux BOX.
I
check the permissions on the mysql data dir, may be the user mysql or
who ever runs mysql does not have sufficient privileges
Kishore Jalleda
On 8/19/05, John Gonzales <[EMAIL PROTECTED]> wrote:
> i am creating my own little blog and i am trying to create a comments table
> that uses the primary
i am creating my own little blog and i am trying to create a comments table
that uses the primary key of my blog table as a foreign key. i've tried the
only two ways that i know how and both ways yielded the same error:
#1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150)
i orginal
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I'm working in a project in C++ using MySQL C API (Win98/Dev-C++
4.9.9.8/MySQL DevPak/MySQL 4.1.13) and I want to know if it's possible
to setup the server environment language (--language) via
mysql_options() function.
Also, I want to know if it
Steven Altsman wrote:
cp /usr/local/mysql/lib/mysql/* /usr/lib
No no no! There are several better options:
1. Add /usr/local/mysql/lib/mysql to your system's dynamic loader
configuration. On Linux, for instance, this is /etc/ld.so.conf; you
need to run ldconfig after changing that file.
Robert Crowell wrote:
I have data from two different sources that I would like to store in a mysql
database. Dataset_1 has pieces of information A, B, and C (let's say first,
middle, and last name) and Dataset_2 has pieces of information A, B, C, and D
(first, middle, last names and a DOUBLE val
Steven Altsman wrote:
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
Read through config.log to see what test was tried, and how it failed.
I've looked at the PureFTP archives and they aren't particularly helpful
I take i
Not Apache, Mysql-4.1.13. I did look in the Mysql acinclude.m4 and it is
looking for ssl.h in the includes folder (which does exist) and it's
looking for libssl.a in the libs folder which does exist.
So, I'm kinda confused as to why it says it's not found.
Peter J Milanese wrote:
My bad. The
Aren't the openssl dev libraries in a separate rpm?
--Original Message--
From: RedRed!com IT Department
To: mysql
Sent: Aug 19, 2005 4:52 PM
Subject: mysql-4.1.13 and openssl-0.9.8 configuration issue
I'm running Red Hat Enterprise v4 and I have installed OpenSSL-0.9.8 and
am trying to ins
I'm running Red Hat Enterprise v4 and I have installed OpenSSL-0.9.8 and
am trying to install MySQL-4.1.13 but am receiving an error during
configuration. The actual error is as follows:
checking for OpenSSL... Could not find an installation of OpenSSL
Looks like you've forgotten to install Ope
Robert Crowell wrote:
However, if the table was created with columns A, B, C, and D, most of the
entries in the D column will be NULL. Is this considered 'good form'? Even
though these entries are all NULL, they will still consume the disk space that
a DOUBLE will, correct?
I can't find it i
On Thursday 18 August 2005 17:52, Gleb Paharenko wrote:
> Hello.
>
> I've modified your source code, and it works now. Use diff to see the
> changes.
>
Thank you, but I made the changes and I still get no returned data. Below is
the contents of the logfile when I run my program. It appears tha
I have data from two different sources that I would like to store in a mysql
database. Dataset_1 has pieces of information A, B, and C (let's say first,
middle, and last name) and Dataset_2 has pieces of information A, B, C, and D
(first, middle, last names and a DOUBLE value).
Dataset_1 has 9.5
On Thursday 18 August 2005 16:37, Gleb Paharenko wrote:
> Hello.
>
> These links might be helpful:
> http://dev.mysql.com/doc/mysql/en/query-log.html
> http://dev.mysql.com/doc/mysql/en/debugging-client.html
> http://dev.mysql.com/doc/mysql/en/debugging-server.html
>
> Use a fresh ver
Thomas Spahni wrote:
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
CREATE TEMPORARY TABLE duptemp SELECT * FROM duprows WHERE id = 2;
ALTER TABLE duptemp CHANGE id id INT NULL;
UPDATE duptemp SET id = NULL;
INSERT INTO duprows SELECT * F
Argh.. I'm stupid.
http://64.233.161.104/search?q=cache:hzZrZNEtu6wJ:jim.3tchina.com/tech/ftp/0
40607_pureftpd_mysql.php+%22Your+MySQL+client+libraries+aren%27t+properly+in
stalled%22&hl=en%20target=nw
cp /usr/local/mysql/lib/mysql/* /usr/lib
Please disregard.
<3 For China :D
-Original Me
Terry Riley wrote:
I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
house test setup).
This vaguely duplicates what is set up on the live servers, except that
the slave is 4.1.3 on NT4.
On the test setup, if the logs are flushed on the master, the bin log is
rotated to
checking for mysql_init in -lmysqlclient... yes
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
-
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
USE test;
CREATE TABLE duprows (
id INT NULL AUTO_INCREMENT PRIMARY KEY,
content VARCHAR(255)
) TYPE=MyISAM;
INSERT INTO duprows VALUES(NULL, 'some text'),(NULL, 'some other text
I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
house test setup).
This vaguely duplicates what is set up on the live servers, except that
the slave is 4.1.3 on NT4.
On the test setup, if the logs are flushed on the master, the bin log is
rotated to the next number, after
Dan,
See http://dev.mysql.com/doc/mysql/en/declare-handlers.html. Here's a
wee example...
USE test ;
SET @err = 0 ;
SELECT 'Before running errhandlerdemo:', @err ;
CREATE TABLE IF NOT EXISTS testhandler (i INT, PRIMARY KEY(i)) ;
SET GLOBAL log_bin_trust_routine_creators=TRUE
DROP PROCEDURE IF
Hi Mark,
Thanks for your reply.
> MySQL itself doesn't generate UDP traffic (the protocol runs
> over TCP/IP). However, MySQL relies on DNS unless you've specified
> - --skip-name-resolve when you started the server. DNS
> travels over UDP.
I did not specify --skip-name-resolve.
> You also m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn van den Burg wrote:
> Hi,
>
> While I was on holiday our production MySQL 4.1.10 (Solaris 8) had to be
> restarted due to a filesystem upgrade (NetApp). After the restart, when
> I came back from my holiday, I noticed that INSERT performance h
If you want to have all values except the primary key be the same and
say your is foo_ID
You can simply do
INSERT INTO foo
(foo_ID... {rest of columns list})
SELECT new primary key value,
{rest of columns list}
FROM foo
WHERE foo_ID = {primary key value of row you want to copy}
If
The ideal setup is based on your data and access patterns to that
data. Read these two pages to get a start:
http://dev.mysql.com/doc/mysql/en/server-parameters.html
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
By understanding what each variable does, you'll know which one to
Hi listers
I once asked if there is an SQL syntax permitting to copy a row in the
same table. I got no answer, so there is no such syntax.
now i meant to have found a work-around using (see subject).
problem is, that when i do a SELECT * ... INTO OUTFILE .. i will also
catch the PRIMARY KEY c
Hi,
While I was on holiday our production MySQL 4.1.10 (Solaris 8) had to be
restarted due to a filesystem upgrade (NetApp). After the restart, when
I came back from my holiday, I noticed that INSERT performance has
dropped dramatically and that the machine generates a lot more UDP
traffic seeming
Hello.
I've modified your source code, and it works now. Use diff to see the
changes.
My test table is:
mysql> show create table lth\G;
*** 1. row ***
Table: lth
Create Table: CREATE TABLE `lth` (
`product` char(255) default NULL,
`faci
Hello.
These links might be helpful:
http://dev.mysql.com/doc/mysql/en/query-log.html
http://dev.mysql.com/doc/mysql/en/debugging-client.html
http://dev.mysql.com/doc/mysql/en/debugging-server.html
Use a fresh version of MySQL, because old couldn't
log queries from prep
Thanks a lot Philippe. Its working. :)
sujay
-Original Message-
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 12:43 PM
To: 'mysql@lists.mysql.com '
Subject: Re: Commit needed even after a select statement ??
HI,
n(say session 2) and updated the entr
You should be asking the snort people whether it works with mysql version 4.
Alternatively you should provide more information if you are getting
errors from mysql.
[EMAIL PROTECTED] wrote:
Could you let me know if
mysql-standard-4.1.13-sun-solaris2.9-sparc works with snort-2.4.0.
I was not
HI,
n(say session 2) and updated the entries in the table. Did a
commit.
* Now i issued the second select statement on session 1, but still it
is showing the old results. Idealy it should show the new results, which are
a result of updations done using session 2.
But when i issue a commit
36 matches
Mail list logo
