On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote:
Hi,
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql UPDATE user SET Password=PASSWORD(testpassword)
- WHERE User='root';
ERROR 1046: No Database Selected
mysql
1) select the database with use mysql
-- Forwarded message --
Date: Tue, 2 Jul 2002 17:40:24 +0300 (EEST)
From: Nixarlidis Aris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: selected records retrieve
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice or in wrong
I would like to know regarding the cast and convert functions in
MySql4.0.1;.
Can nebody explain the usage(casting of strings to number/integer).
I was not able to use them properly
Regards
Harish Varandani
-
Grabbing a half-gig video segment out of any
database
I'm sure you're absolutely right about not putting half gig videos in a
database!
I was thinking more of an application like an access control system, where
there might be tens of thousands of photographs of people, each a jpeg of a
small
Hytham,
- Original Message -
From: Hytham Shehab [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 6:21 AM
Subject: Re: innodb is disabled, how can i make it yes?
hi Heikki,
i do what u said:
yourpathtomysqlbindir mysqld-max-nt --console
cannot
At 09:42 AM 7/3/02 +0100, Tim Ward wrote:
I was thinking more of an application like an access control system, where
there might be tens of thousands of photographs of people, each a jpeg of a
small number of K, or a catalogue, again with thousands of tiny photos.
The experiment I did with
Petre,
- Original Message -
From: Petre Agenbag [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 9:01 AM
Subject: Re: MAX vs plain vanilla mysql
Thanks,
So, just to be 100% sure, the BEST to do is to install max, as I can't
see any reason why NOT
From the manual :
Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though.
CB.
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Are you sure that you are starting mysqld-max-nt.exe for the server ?
If so, try mysqld-max-nt --print-defaults to see what parameters are set,
maybe that will give you a clue ...
CB.
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 00:19
Hello.
On Wed 2002-07-03 at 09:42:52 +0100, [EMAIL PROTECTED] wrote:
[...]
I was thinking more of an application like an access control system, where
there might be tens of thousands of photographs of people, each a jpeg of a
small number of K, or a catalogue, again with thousands of tiny
Hi.
I recently update my servers from 3.23.29 to 3.23.51 version.
Replication alwais works fine.
Now, when I send show processlist command to slave, this is the response:
+--+-+---+--+-+--+---+--+
| Id | User
Am Mittwoch, 3. Juli 2002 10:58 schrieb Elizabeth Mattijsen:
Not meaning to put down MySQL, but have you tried this also
with a ReiserFS filesystem? I had a similar number of files,
about 70 GByte worth on an ext2 filesystem. Moved them to a
ReiserFS filesystem and found I only needed 51
Hi,
I have 2 machine dual-processor Pentium III, with 1G of memory.
They have the same software, same architecture, with one-way replication
beetween. Versions:
[root@localhost tmp]# mysql -V
mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)
[root@localhost tmp]# cat /etc/redhat-release
Description:
Single quotes (') in comments may cause syntax errors.
How-To-Repeat:
Run this MySQL code from a file, including the comment
(running from the MySQL shell will also expose the bug,
but you will not be able to complete the command without
Mark Colvin wrote:
I have a php script that executes a query and depending on the results
builds a section of a table for each record returned in the query. Each
section has some fields and three buttons. My problem is this. When I want
to change the data in one particular section, how can I
Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.
TEST USER SYSTEM ELAPSEDRESULT
When I issue the following query from phpMyAdmin,
SELECT b.* FROM newblocks b LEFT JOIN groups_blocks_link l ON
l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND
b.visible=1 ORDER BY b.weight,b.bid
I get the following error
Can't create/write to file
Hi all,
I have a problem whith a very simple query.
My problem is: it doesn't use indexes. It does full table scans instead.
The only way I found to make it fast was using UNION.
Can somebody please tell me,
how I can make it fast (using indexes) without using UNION?
My query:
SELECT * FROM
I was wondering if anyone knows of a way to make a mysql server running
on red hat linux authenticate using nt pass through (something like
samba does it) or possibly ldap. I am new to mysql so this may be very
easy to do I just don't know how. It also might be impossible. Just
wondering if
Any clues? Anyone? I'm stumped here guys.
On 2 Jul 2002 at 18:00, [EMAIL PROTECTED] wrote:
Hi.
I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3.
Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat
387fbff
Ram: 128M
I configured using:
On Tue, Jul 02, 2002 at 10:55:25PM -0500, Paul DuBois [EMAIL PROTECTED] wrote:
At 21:41 -0400 7/2/02, Bob Bell wrote:
Pardon my posting as soon as I subscribed to this list, but I have
a problem that's really annoying me. I just installed MySQL on
a virtual server account that I have, and
Hello,
I have a bunch of text with Japanese in it that uses shift_jis encoding.
My initial tests show that this encoding has the same problems in MySQL
as it does in Perl: it gives false matches.
I have to convert the data to the EUC enconding (I think I've seen it
called ejis in a MySQL
Hello!
The subject says it all: What rights does a user need to have (minimal
rights of course) to be able to execute PURGE MASTER LOGS command?
Thanks in advance
Ralf
For the poor little filter: sql query
--
Ralf Narozny
SPLENDID Internet GmbH Co KG
Skandinaviendamm 212, 24109 Kiel,
Is there a command like perror for the Windows version of MySQL? I can't
seem to find anything to list error code descriptions in either MySQL 3 or
4.
TIA - Chris
-
Before posting, please check:
You can use the winmysqladmin tool located in the bin directory to install
it as a service.
(I'm not sure wether this also works on a '98SE machine)
CB
-Original Message-
From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:00
To: [EMAIL PROTECTED]
Yes there is:
perror.exe located in c:\yourmysqldir\bin\
:)
-Original Message-
From: Christopher A. Libby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:16
To: [EMAIL PROTECTED]
Subject: PERROR on Windows
Is there a command like perror for the Windows version of MySQL?
* Christopher A. Libby
Is there a command like perror for the Windows version of MySQL? I can't
seem to find anything to list error code descriptions in either MySQL 3 or
4.
It should be in the bin diretory:
C:\dir \mysql\bin\perror*
Volume in drive C has no label.
Volume Serial Number is
Well maybe I sould map this out more clearly...
members
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| rowid |
Okay:
FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel PIII
1Ghz with 1G of RAM. All from source.
Compiled okay and came through super-smack and crash-me tests okay. But a
few hours later, for no reason, MySQL decided to look at /var/tmp instead of
/usr/local/mysql/var for
I'm trying to import a 1 GB mysql database into oracle using a perl/dbd
interface written by a 3rd party software company. This is over a network,
but I've pinpointed my bottleneck as being the disks attached to the
target oracle db server. This process dies with a timeout on the mysql
server
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem occurs time to time ( during peac or idle time ).
In fact mysql seem not to answer all connections.
Netstat show several connections TIME_WAIT and show process_list only show
1 ou 2 queries running ...
But on
Diana,
Wednesday, July 03, 2002, 2:24:51 PM, you wrote:
DS I have 2 machine dual-processor Pentium III, with 1G of memory.
DS They have the same software, same architecture, with one-way replication
DS beetween. Versions:
DS [root@localhost tmp]# mysql -V
DS mysql Ver 11.18 Distrib 3.23.51,
Ralf,
Wednesday, July 03, 2002, 4:48:11 PM, you wrote:
RN The subject says it all: What rights does a user need to have (minimal
RN rights of course) to be able to execute PURGE MASTER LOGS command?
Since version 4.0.2 user must have SUPER privilege.
before 4.0.2 you must have PROCESS
Christopher,
Wednesday, July 03, 2002, 5:15:44 PM, you wrote:
CAL Is there a command like perror for the Windows version of MySQL? I can't
CAL seem to find anything to list error code descriptions in either MySQL 3 or
CAL 4.
Take a look at perror.exe program in /bin directory.
--
For
Does MySQL prevent updates from occurring when the values involved are the
same as the database's current state.
For instance, if I've got a table
create table updater(
id int not null primary key auto_increment,
is_active int not null default 1
};
insert into updater(is_active) values (1);
At 12:07 -0400 7/3/02, Paul Tomsic wrote:
Does MySQL prevent updates from occurring when the values involved
are the same as the database's current state.
I don't know if prevent is the word exactly. It doesn't bother to update
the row unless you actually change a value. The phenonenon you're
Hi,
I have installed mySql 3.23 max for NT and i'm getting the following error,
but I am not sure if it is ADO or MySQL at fault !
I need to list the tables,columns and indices of the DB and the last index
access statement is failing. I'm accessing MySql via a DSN connection from
within VB6.
What happens if you put third TIMESTAMP column.?. Will that be
updated?. Just curios.
Nilesh
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 12:42 PM
To: Paul Tomsic; [EMAIL PROTECTED]
Subject: Re: verification upon update, help, please
This is not specific to MySQL (probably) but I thought this wizened
community might have a definitive answer.
Take this simple grouped select:
SELECT Value1,Value2 FROM Table1 GROUP BY Value1,Value2
Value1 Value2
---
Joe Red
Joe Blue
Joe Green
Jim Red
Jim
Description:
when running a insert data infile command on a 500MB text file, I
get the error ERROR 1030: Got error 22 from table handler from
mysql. I did a listing of the database files and it looks like this:
-rw-rw 1 root root 2147397632 Jul 3 09:46
Hi,
What is written in err.log (/var/lib/mysql) ?
I think you have some problems with network (switch or hub).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
Newbie here...please be kind!
Sometimes when I try to execute some SQL statment MySQL throws an Error
7...(see below)
For example:
ALTER TABLE `categorias` RENAME `catAnimais`;
And here's the error
Error: 7 - Error on rename of '.\orniex\categorias.MYI' to
'.\orniex\#sql2-ffc-4.MYI'
Hi .
One table with three filed full-text indexed :
titlu,continut,descriere
qry :
SELECT autori.nume as autor,
ref_data.id as id_ref,
ref_data.marime as marime,
ref_data.clasa as clasa_ref,
ref_data.titlu,
ref_data.nota as nota
,materii.*,MATCH (titlu,continut,descriere) AGAINST ('conceptia')
From the manual 4.10.4
Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(),
and TIMESTAMP values.
I am somewhat fearful and curious about how this works. Say we have a
master web database that gets replicated back to the office slave over the
Internet. A person on the
Hi users and developers!
I deleted the in-reply-to header as everybody misunderstood my first mail.
Please give this a thought folks, especially developers, I can help developing
it if nessecary.
I want to do transparent encryption. Like being able to choose an encryption
scheme of a table or
Kristian,
Question: Can the MySQL BLOB API access and transfer partial
blobs. That is, if you want to do the equivalent of a file *
to a BLOB table, the first 10 bytes or so of each BLOB must be
read in order to guess the type of the BLOB. Is it possible to
implement this efficiently using the
[admin admin]$ mysql mysql
or once you have the mysql prompt type: use mysql
then issue the command
Curtis
Page Works Web Solutions said:
Hi,
any ideas on this one
[admin admin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server
hi
im getting the message :
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
when i try to connect to mysql
Then I tried to run daemon
[root /root]# /usr/sbin/mysqld
Fatal error: Please read Security section of the manual to find out
how to run
mysqld as
Heey There Folks,
Well, I hope that this message gets through finallly. First I got it back
from the deamon because I had send it in html format, then because of I was
suspected from spamming this list. Only for not having used the words query
or sql once ... well, I have now so it should come
hi
im getting the message :
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql
Then I tried to run daemon
[root /root]# /usr/sbin/mysqld
Fatal error: Please read Security section of the manual to find out
how to run
mysqld as
How did you install MySQL? Package, source, binary?
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:06 PM Rahadul Kabir wrote:
hi
im getting the message :
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
when i try to connect to mysql
Then I
Hi mysql wizards,
I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why (for I don't understand perl), could anyone help?
Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):
mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
Hi,
What is written in err.log (/var/lib/mysql) ?
nothing :(
something like
mysql started and ready for connection
I think you have some problems with network (switch or hub).
Euh network hardware i don't think, perhaps a problem with software but may
be strange 'cause ifconfig says that all
[root /root]# mysqladmin -u root password '30waverly'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' ex
ists!
[root
This are the few variables for mysql. Does anyone know how can I set the
current value to some other value. because whats happing now is when I
try to startup mysql, it starts and right after a second it ends. and I
think Its because of this current value: 0. can someone please tel me
in which
depending on your distro. You should have a dir named /etc/rc.d/init.d or
/etc/init.d in it should be a script named mysql for starting and stopping
mysql. Use it (as root) to start mysql.
/etc/init.d/mysql start
or
/etc/rc.d/init.d/mysql start
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
*
Salutations.
1:
I personally use InnoDB. I think Bdb tables were the first with
transactions but I don't see a lot of people talking about using them these
days. Also, InnoDB is being activly developed and between sleeping, eating
and coding, Heikki answers questions here! :)
2:
Signed
start the server before connecting to it.
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:24 PM Rahadul Kabir wrote:
[root /root]# mysqladmin -u root password '30waverly'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
looks like mysql is not running.
type ps ax
and see if you see any mysqld lines.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rahadul Kabir [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 2:24 PM
To: MySql Mailing List
Subject:
I have replication running successfully between two Linux boxes running
3.23.51. However, I'm getting the following error very frequently (every
30 - 60 seconds) in my slave error log:
-
020703 15:41:09 Error reading packet from server: (server_errno=1159)
020703
From: Harald Kleiner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: unexpected results using LEFT JOIN with more than one join_condition
Description:
I use LEFT JOIN to join together two tables. And (for some 'complex'
reason) I want to add additional conditions into the join_condition-part
at last,
i got an error 5 'Access Denied', then after some blah,blah, etc, etc,
it got started with InnoDB.
not InnoDB is yes.
now i can write a good SQL QUERY ;)
special thanks to Heikki and Bert
--
Hytham Shehab
On Wed, Jul 03, 2002 at 10:54:23AM -0700, Eric Frazier wrote:
From the manual 4.10.4
Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(),
and TIMESTAMP values.
I am somewhat fearful and curious about how this works. Say we have
a master web database that gets
Hello,
I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry
for that but I really need the solution...
I have 2 tables
table Client :
---
|ClientID | ClientName|
---
|1| Eric |
|2| Mark |
|3| Simon
On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote:
I want to do transparent encryption. Like being able to choose an encryption
scheme of a table or database when created so that the data on disk is
always encrypted.
Why don't you just put the tables on an encrypted
In the last episode (Jul 03), Mike Hall said:
FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel
PIII 1Ghz with 1G of RAM. All from source.
Compiled okay and came through super-smack and crash-me tests okay.
But a few hours later, for no reason, MySQL decided to look at
if you set it up so that the slaves occasionally update the master, you can
get around the
problem as follows.
For the *primary* table(s), when you update the master, get the data for 1
row to update from the
slave.
When you insert this row into the master, remove the auto_increment field
from
Well. Good to know. So I guess the only alternative would be to generate
keys by date/time?
I was hoping to avoid that. I am still worried about the timestamp type not
having good enough resolution. Seconds are pretty broad.
Thanks,
Eric
You're asking for trouble. :-)
AUTO_INCREMENTS are
Hi,
I'm making a CSV from a Mysql table, in which text is stored as is, with all
br to keep format etc (I need to keep line breaks because the same text
has to be printed out in a page taking care of the original fomatting);
The problem comes actually when Excell tries to read the CSV (;
Hello,
My perception of the InnoDB vs BDB question is that
although the BDB is very impressive and long standing,
it does not get the same level of attention that
InnoDB seems to get from the good folks at MySQL AB.
If I am not mistaken, BDB does not yet offer foreign
key support.
I have chosen
Hi mysql wizards,
I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why (for I don't understand perl), could anyone help?
Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):
mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
Hello All,
I'm using mysql version 3.23.47 as a database in an embedded device. In
the startup scripts for the database I have it run :
myisamchk -o -s /usr/local/var/data/*/*.MYI
(to fix any possible problems)
with safe_mysqld --datadir=/usr/local/var/data
(to start the database)
On one
I'm working on a search interface in MySQL for a series of items that
have titles and descriptions. I'd like to weight the results so that
matches in the title count for more than matches in the description.
Is there a recommended way of doing this?
So far, I've come up with three ways, two of
If 'text' is stored in the HTML format in the db, the only solution I can
think of is writing a perl/shell script to parse out the br and recreate
the files without it, that ways, the data in the DB is not disturbed and
Excel should be able to read it to (unless someone knows of a setting in
You can use the InnoDB table type which supports foreign keys.
http://www.mysql.com/doc/S/E/SEC446.html
If you want to use MyIsam table types, the only solution is to send a
specific request to delete records in both the tables.
Regards,
Bhavin.
- Original Message -
From: multivac [EMAIL
Pada Wed, 3 Jul 2002 16:39:03 -0700
Eric Mayers [EMAIL PROTECTED] menulis :
Hello All,
I'm using mysql version 3.23.47 as a database in an embedded device. In
the startup scripts for the database I have it run :
myisamchk -o -s /usr/local/var/data/*/*.MYI
(to fix any possible problems)
Hello,
I have a bunch of text with Japanese in it that uses shift_jis encoding.
My initial tests show that this encoding has the same problems in MySQL
as it does in Perl: it gives false matches.
I have to convert the data to the EUC enconding (I think I've seen it
called ejis in a
Pada Wed, 3 Jul 2002 12:56:30 -0700
Jeff Kilbride [EMAIL PROTECTED] menulis :
Is this just a normal timeout error, because there's currently very little
activity on these machines? Or is there some other problem? The
slave_net_timeout value is at it's default of 3600, so I would expect to
Hie there,
I'm having a potential problem with Load Data Infile function
where i'm unable to get the right no. of records to appear in the table. I
have a table created in MySQL with 2 fields region (char 1)-pkey and
regionname (char 30). The table name is called region. I've also
I can't login using root to mysql server from my pc-client...
I have tried to use this command but still have a problem...
mysql -u root -p -h 192.168.x.xxx
i already created one user which have all privileges
so, if i check into mysql database and user tables, i found two user, root
and
Hello all,
I have mysql running on a 2.4.18 kernel:
/usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386
and note that one started about 4 processes (threads?) began to handle the
various signal/table tasks and such. After several random queries the
process list grows accordingly.
81 matches
Mail list logo