mysql
I have a problem in using mysql in my server: Redhat 8.
when i use the database ,i get the err message:
mysql use db00010
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
I'd just like to say thanks to both Michael and Rocar for both solutions. I will be
giving them a go.
I now need to buy a more comprehensive manual for MySQL, as neither of these commands
are in the 2 books I currently have.
Many thanks
Ian
-Original Message-
From: Michael Stassen
Hi,
we got a little problem with a master-slave replication (both running
MySQL 4.0.18) eating up our complete bandwidth. The slave is connected
via a 2MBit-SDSL-Line which is also used to connect our Office-PCs with
the internet so I get complaints about the slow connection which is
caused by
g'day,
've had a good look through the manual and archives but can't find an answer. I'm
pulling, among other things, a field from the DB that holds description data (a few
paragrahps of text). I want to limit it so that it only pulls the first 50 words (or
characters if thats not possible)
Keith [EMAIL PROTECTED] wrote on 11/03/2004 09:50:35:
've had a good look through the manual and archives but can't find
an answer. I'm pulling, among other things, a field from the DB that
holds description data (a few paragrahps of text). I want to limit
it so that it only pulls the
look for SUBSTRING_INDEX(field,'\.',2)
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:51 PM
To: [EMAIL PROTECTED]
Subject: Limiting Return
g'day,
've had a good look through the manual and archives but can't find an
answer. I'm pulling, among
Hi,
I was wondering if anyone could point me to info on setting up https access
to the admin page on phpmyadmin?
Thanks anyone.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You've been perfectly clear. The MySQL permission system will not define this
level of security. You must design you application so that it will only give
access to the rows that pertain to the customer that is logged in. Create a
MySQL user which can read and write to your database. Then
Mr. Pendleton,
Exactly.
ps -aux | grep mysqld show several instances of the mysql_server running
at the same time. By now, I have 69!.
Thanks in advance.
Leandro M Neves
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Rocar Peças ' [EMAIL PROTECTED]; [EMAIL
VP Can you supply us with an example? Some explain plans to corroborate your
VP reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
I've made some experiments and can
Hi list,
I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
important and so, i'm asking your help :)
I'm using MySQL 4.0.15 under Linux.
Here's a test query :
mysql explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
LIMIT 234599,20;
Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL
database function. I tried and failed using up2date (following instructions
from RH), so downloaded the rpms and began to install by myself. My input
and the output is shown below:
# rpm -i
Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL
database function. I tried and failed using up2date (following instructions
from RH), so downloaded the rpms and began to install by myself. My input
and the output is shown below:
# rpm -i
Having just set up a RedHat Enterprise Server V.3 I am trying to add a
MySQL database function. I tried and failed using up2date (following
instructions from RH), so downloaded the rpms and began to install by
myself. My input and the output is shown below:
# rpm -i
Having just set up a RedHat Enterprise Server V.3 I am trying to add a
MySQL database function. I tried and failed using up2date (following
instructions from RH), so downloaded the rpms and began to install by
myself. My input and the output is shown below:
# rpm -i
Hi!
anyway, why dont you use the graphic install utility redhat uses to
install mysql?? it will resolve the dependencies for you =)
PS: i think it's called redhat-config-packages
Best Regards!
On Thu, 2004-03-11 at 09:05, Robert Ross wrote:
Having just set up a RedHat Enterprise Server V.3 I
I have 3 tables:
main(id int, type tinyint(1))
categories(id int, name varchar)
items(id int, name varchar)
I want to select the id and name.
If type is 1 then I want to select the name from categories,
if type is 0 I want to select the name from items, here is the query I'm
trying to use:
SELECT distinct main.id, etc. etc.
At 14:37 11-3-04, you wrote:
I have 3 tables:
main(id int, type tinyint(1))
categories(id int, name varchar)
items(id int, name varchar)
I want to select the id and name.
If type is 1 then I want to select the name from categories,
if type is 0 I want to select
Hi Victor,
I tried that initially and thought I had installed everything - RH
Enterprise has the option in the GUI to install mysql - what it doesn't tell
you is that it is the client and not the server. When you (eventually) find
this out and try to install the server, problems occur because
Thanks,
but this is just a nicer way to apply my second solution,
I'm looking for a more efficient solution (and if someone can than for an
explanation - why are the results getting duplicated?)
-Amir.
On Thursday 11 March 2004 15:40, Hans van Dalen wrote:
SELECT distinct main.id, etc.
Amir,
I don't know your table content but if you join two tables eg : table1(id,
desc) and table2(id, refid, desc) wich containts:
table1:
1 test1
2 test2
table2:
1 1 testbla
2 1 testbla
and you select: select id from table1 where table1.id = table2.refid
you got two rows (because if you show *
With respect to this problem, I am not running on Windows, but Redhat,
and seeing this problem often.
Which part of:
http://www.mysql.com/documentation/connector-j/index.html#id2803835
should i be looking at?
thanks
alan
--
MySQL General Mailing List
For list archives:
Hi,
I have a PHP script that is running 4 queries. If the 4th fails, ideally I would like
the other 3 queires to roll back and leave the database as if they were never run at
all.
Can anyone advise on any technique that would do this easily, as opposed to manually
writing and running queries
Is it the same database, same user? Does it follow any maintenance or large
import?
-Original Message-
From: Terence
To: [EMAIL PROTECTED]
Sent: 3/11/04 12:25 AM
Subject: Privilege to single database being revoked occasionally
Dear Lists,
We moved to 4.1.0 when it was first launched,
This display has been fixed in Red Hat 9.0. If you look at the list, the
children processes are not consuming memory, since the memory is shared.
-Original Message-
From: Rocar Peças
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 3/11/04 5:54 AM
Subject: Re: Serveral mysqld instances
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP
headers, we're able to let user download the PDFs without having to
store a
local copy on disk, directly from the database (content-disposition
header).
Hi
Any reason you can use a version of MySQL that contains transaction aware
tables?
-Original Message-
From: Andy Hall
To: [EMAIL PROTECTED]
Sent: 3/11/04 8:29 AM
Subject: Best practise roll-backs?
Hi,
I have a PHP script that is running 4 queries. If the 4th fails, ideally
I would like
??? [EMAIL PROTECTED] wrote:
I have a problem in using mysql in my server: Redhat 8.
when i use the database ,i get the err message:
mysql use db00010
Reading table information for completion of table and column=
names
You can turn off this feature to get a quicker startup with
Is there an advantage to storing the PDFs directly into the database?
I'm also curious how large this would make a database. Is there any space
saved through this method, or would they still be the same size as the
original PDF?
- Eve
--
MySQL General Mailing List
For list archives:
OK, a few things you can try
1.- I usually compile everything my server uses. I recomended you to use
the gui just because i tought rh installer would resolve the
dependencies by itself, big mistake here =) RH seems to prefer
PostgreSQL and considers MySQL a second hand choice =( S, I can
From: Mulugeta Maru [mailto:[EMAIL PROTECTED]
Hi Mike,
I am sorry for the confusion I might have caused. May be it
would help to give a clear example.
Table - Customers (CustomerID, CustomerName, Address, etc)
Table - Transaction(TransactionID,CustomerID,Date,Amount)
Note:
You have a previous version of MySQL installed, from the mysql.com RPM's.
To get rid of it, do:
rpm -e 'MySQL*'
first, then:
rpm -ivh perl-DBD-MySQL-2.1021-3.i386.rpm mysql-server-3.23.58-1.i386.rpm
mysql-3.23.58-1.i386.rpm
I tried 'locate' but could not find either file, so then tried
Erich Beyrent wrote:
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP
headers, we're able to let user download the PDFs without having to
store a
local copy on disk, directly from the
From: Amir Hardon [mailto:[EMAIL PROTECTED]
I have 3 tables:
main(id int, type tinyint(1))
categories(id int, name varchar)
items(id int, name varchar)
I want to select the id and name.
If type is 1 then I want to select the name from categories,
if type is 0 I want to select the name
Eve Atley wrote:
Is there an advantage to storing the PDFs directly into the database?
I'm also curious how large this would make a database. Is there any space
saved through this method, or would they still be the same size as the
original PDF?
- Eve
There's a percentage of disk space
Here is the file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Mike Johnson
SELECT main.id,
IF(main.type,categories.name,items.name),
IF(main.type,cat,item) AS type
FROM main, IF(main.type,items,categories) WHERE
IF(main.type,categories.id,items.id)=main.id;
Oh, my mistake. I just realized I reversed items and categories in the IF clause.
I am trying to split the results from a select query across several pages.
I have a contacts database and if someone searches for a contact who has a
name like %mith% I want it to return the results with a page across the
bottom, like google.
How do I do this with mySQL and ASP or PHP? I
Rocar Pe?as [EMAIL PROTECTED] wrote:
I get a MySQL 4.0.18 server running on a Conectiva Linux Kernel 2.4.5.
The MySQL server supports datum for a C apliccation which everybody in
the company uses.
The problem is that huge mysqld processes come up as people loads their
programs, which
Hi folks:
I would like to know if there are a perfomance loss using PEAR DB comparing with PHP
native Mysql functions, and if this is a significant issue.
Also I´m wondering if using persistent connections in PHP could lead to have many
connections at the same time slowing the server, and how
Keith Wilson (www.giraffedog.net) [EMAIL PROTECTED] wrote:
I am trying to split the results from a select query across several pages.
I have a contacts database and if someone searches for a contact who has a
name like %mith% I want it to return the results with a page across the
bottom,
Hello (first post)
I'm a noob to this group but I have an issue which I am hoping there is a
solution to.
I would like to have one instance of mysqld serving many databases, and
acting as a master server.
Each slave will only replicate one database, and it would be undesirable
for them to be
I store any kind of files, PDF/word/etc.. I just like not having
lots of directories with 1000's of files each in them... Seems
more organized to me..
On Thu, 11 Mar 2004, Erich Beyrent wrote:
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF
All - I've got a table that has an unsigned int that stores increasing
sequence numbers that are stored in UDP payloads. Occasionally, messages
get lost and we'll have missing numbers in the sequence. These are not
auto_incrementing columns, the sequence numbers are assigned by the
application
It does make the database larger.. as far as overhead... As you
can't just store the file as a blob.. You'll need some referencing data in order to
find it, and restore it back out of the database..
I just checked out my database (100's of files) which has:
Total file size: 1765.34MB
Mysql
If you are wanting each database to replicate only certain databases then
you should look over the replication commands.
http://www.mysql.com/doc/en/Replication_Options.html
--replicate-do-db=database_name
might be able to solve your issue.
-Original Message-
From: ron
To: [EMAIL
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated using
auto_increment.
My problem is that the id's
I don't think you can get a query which will return a row for each
missing result, because a query can only return data that's there, not
data that's missing. (although if you generated another table with all
the numbers 1 through 1,000,000 that would work).
Anyway, to get one result row per
If you have a reason not to use InnoDB tables (e.g., speed, licensing,
fulltext indexes), you can implement pretty good client-side rollback in
PHP. Just send all calls through a database class (insert(), update(),
delete()) and if a transaction flag is set then they store in a stack a
little
Hi,
before you start to make inserts/updates to the database you can put
$db-query(begin;) - this is to begin a transaction, in the end of the script
you put commit ($db-query(commit;) if all goes ok, otherwise rollback
($db-query(rollback;).
andré brás
Citando Andy Hall [EMAIL PROTECTED]:
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated
Hi,
I am running 4.0.4 using innodb tables on a linux box.
My innodb config is
innodb_data_file_path = ibdata1:1800M;ibdata2:1800M;...ibdata10:1800M
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=500M
set-variable =
ron [EMAIL PROTECTED] wrote:
Hello (first post)
I'm a noob to this group but I have an issue which I am hoping there is a
solution to.
I would like to have one instance of mysqld serving many databases, and
acting as a master server.
Each slave will only replicate one database, and it
Hi,
I'm trying to load an index into cache hot_cache, but it is not
working. Here is my step to step:
CREATE TABLE GEILSON (CPF VARCHAR(14) NOT NULL, NAME VARCHAR(75) NOT
NULL, PRIMARY KEY (CPF), FULLTEXT (NAME));
INSERT INTO GEILSON (CPF,NAME) VALUES (08238512786, DAVID ESCODINO);
INSERT
Mysqlians,
Does a low_priority behave like a DELAYED for insert and return
to the caller before the update has actually been executed? If not are
their plans for a DELAYED option with update?
Regards,
Trevor
--
MySQL General Mailing List
For list archives:
When I upgraded to the newer version of mySQL I got the same errors, but the
web site I down loaded the new rpms from had a rpm to put both versions of
the dependency files on the system. Go here
http://www.mysql.com/downloads/mysql-4.0.html then look in the Linux
downloads about 1/4 the way down,
John,
- Original Message -
From: John Thorpe [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 11, 2004 7:34 PM
Subject: Innodb logfiles timestamp question
Hi,
I am running 4.0.4 using innodb tables on a linux box.
My innodb config is
Zen,
the printout looks like the thread reading in the transaction system header
from the first data file would have stuck.
Please send to me the printouts from other crashes.
Maybe this is a bug in the trx system header handling. Though, my first
guess is that this is an OS/drivers/hardware
Hello,
I run into a problem where I need to get contents of BLOB to my php
script. I found out that I'm limited by max_packet_size (which i can't
change because of my ISP) and i tried to work around it by using SELECT
substring(column,x,1024) where x is number increasing in steps of 1024.
But
Christian,
do you mean that even if you recreate the whole tablespace, you will get
corruption on some data page rather quickly?
Please send to me the whole .err log for analysis.
The printout below shows that the start and the end of the page are ok, but
in the middle there is some change that
This may be more solaris related, but I need to compile mysql with
gcc because perl is compiled with gcc and I need DBD::mysql. It seems
the linker can't find the libs. I seem to have the same problem
linked dynamicaly expect the build completes and then can't load the
shared library when I
I have two tables that I want write one query that uses different where
clauses under conditions in the where clause. In the first table I have type
of document with document names. Through a third party program I am passing
a document name as a parameter. This table also has a key that is called
http://php.dreamwerx.net/forums/viewtopic.php?t=6
storage implementation that is not affected by max_packet_size.
On Thu, 11 Mar 2004, Tomas Zvala wrote:
Hello,
I run into a problem where I need to get contents of BLOB to my php
script. I found out that I'm limited by max_packet_size
I have a very simple query
SELECT ProblemReports.* FROM ProbelmReports;
If there is no data in the column 'Description' it returns 'x'. There
is no default value being used and there is no data in the field. Why
would it return 'x'? The field type is 'TEXT'. I have another 'TEXT'
field in
According to this page in the online manual
http://www.mysql.com/doc/en/C_API_Prepared_statement_datatypes.html, the
length element of the MYSQL_BIND structure when set to 0 will treat the
buffer element as a NULL terminated string.
If I do such a thing, prepare some query, bind some columns
Can you post some sample data and ddl?
-Original Message-
From: Jacque Scott
To: [EMAIL PROTECTED]
Sent: 3/11/04 3:12 PM
Subject: Mysterious 'x' when retrieving records
I have a very simple query
SELECT ProblemReports.* FROM ProbelmReports;
If there is no data in the column
Here is my code that retrieves the data. It's weird because I don't get
the 'x' when I run the same query in ControlCenter. It's only when
using the code below. Also this is the first time that I have seen
this. This code works perfect with all my other queries.
Dim cn As New
Ken Menzel wrote:
This may be more solaris related, but I need to compile mysql with
gcc because perl is compiled with gcc and I need DBD::mysql. It seems
the linker can't find the libs. I seem to have the same problem
linked dynamicaly expect the build completes and then can't load the
shared
Trevor Price wrote:
Mysqlians,
Does a low_priority behave like a DELAYED for insert and return to
the caller before the update has actually been executed? If not are
their plans for a DELAYED option with update?
No - low_priority means that if there is a lock contention for a table, the
Stefan Schuster [EMAIL PROTECTED] wrote:
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my online transactions, the other
one the offline transactions. Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated
codefit wrote:
Hi,
I was wondering if anyone could point me to info on setting up https access
to the admin page on phpmyadmin?
Use mod_ssl
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Lutz Maibach wrote:
Hi,
we got a little problem with a master-slave replication (both running
MySQL 4.0.18) eating up our complete bandwidth. The slave is connected
via a 2MBit-SDSL-Line which is also used to connect our Office-PCs with
the internet so I get complaints about the slow connection
Does Red Hat have some kind of userland address space hack that
we're not aware of?
Do you have any special kernel config options that you did not use before?
the thread stacks are 2MB apiece (bf601000-bf80 is
2093056 bytes, or 2044kB)! Yet:
# mysql -e 'show variables' | grep
Yes I have mod_ssl and have used it for a long time for other applications.
What I am looking for are phpmyadmin specific instructions as to how to
configure phpmyadmin to use mod_ssl and
and DISALLOW http logins and only allow https logins and use of phpmyadmin.
Thanks anyone.
-Original
Just set PHPMyAdmin under the directory tree of your https server, and not
under the directory tree of your http server. That way you have to connect
to the https server to log in.
j- k-
On Thursday 11 March 2004 02:15 pm, codefit wrote:
Yes I have mod_ssl and have used it for a long
Same database, and same user. Nope, it's a fairly low traffic application (a
helpdesk) and there's no large importing done.
When it happens again I will print out some SQL results. Anything I can look
out for or provide the next time it happens?
Thanks
- Original Message -
From: Victor
Hi Everyone,
Is there an easy way to update a field for the last record referenced by an ID number?
where that ID number is used on multiple rows?
At the moment I am doing this which works:
CREATE TEMPORARY TABLE tmp_user ( SELECT user_id, MAX(last_updated) AS
max_last_updated FROM employee
Hi,
Today I wanted to upgrade mysql-4.0.17 to mysql-4.0.18 in
FreeBSD-5.2-CURRENT and got error below.
I used following options to compile from ports collection:
make WITH_CHARSET=cp1251 WITH_LINUXTHREADS=yes BUILD_STATIC=yes install
Error message:
Here is the problem. I am getting random table locks in my databases on a new
server running Fedora 0.96 and Mysql 3.23.58-7.
It seems that different tables will lock -- what I mean by that is when I try
to execute a query on them, mysql just freezes up -- it doesn't crash or return
errors it
Now is on the list where it belongs :)
Em please help!
- Original Message -
From: Carl Karsten [EMAIL PROTECTED]
To: Stan Sebastian [EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 5:58 PM
Subject: Re: Load data + odbc
One of us (looks like me) replied directly instead of
80 matches
Mail list logo