Nestor:
You might not have entered the SQL > FLUSH PRIVILEGES;
command after you changed the password. Without it, the old
data can remain in effect.
Cheers,
Kent Hoover
-
Before posting, please check:
h
by the same user with the same password.
Please, someone, tell me that these 2 problems are both
load related, were found and corrected by a later release
than the one I have.
Thanks,
Kent Hoover
-
Before posting, pleas
On Wed, 11 Sep 2002, Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
> On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote:
> > Version: MySQL.3.22.32-log
> >
> > Does this problem ring a bell with anyone?
> > I'm seeing two undesired behaviors, both, *
I would use this query:
SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
Cheers,
Kent
sql, query, y'hear
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
This works for me:
> mv /mysql/log /mysql/Oldlog
> mysqladmin flush-logs
MySQL follows the oldlog, keeps writing to it until the flush, when it
closes its Oldlog,
and open/create-s its logfile.
Cheers,
Kent
-
Before posti
Kevin:
A database is, in some sense, a container for your tables. It sounds
like you want
to compose a new container. Thus,
To list your databases (containers):
mysql> show databases;
... it seems that the list should contain your dbb and mysql, probably
also "test".
To create a new database (co
I believe the answer will be for you to create a single index on *just*
the cust column. (I assume that a specific cust id occurs only once or a
few times in the
whole table.) This will allow MySQL to use that index to find the small
set of records (quickly) where cust=1,
then to screen the email
Doc:
Try this...
SELECT C.domain, email, telephone, count(*)
FROM Customers AS C LEFT JOIN
Orders AS O ON O.domain=C.domain
GROUP BY C.domain, email, telephone ;
Cheers,
Kent
[fodder=SQL]
-
Before posting,
Read all about Join in the manual -- it includes hints like this query:
SELECT DISTINCT(PersonID) FROM PersonProject AS P1
LEFT JOIN PersonProject AS P2 ON P2.PersonID=P1.PersonID AND
P2.ProjectID=2
WHERE P2.PersonID IS NULL;
Cheers,
Kent
E;
Cheers,
Kent Hoover
-
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 <[EMAIL PROTECTED]>
To unsubscribe
You didn't show the code where the mysql_query() is done.
Further, you have "RAND as r" coded in your select statement,
not "RAND( ) as r". Is this live code?
Cheers,
Kent
(filter feeder: database)
-
Before posting, please ch
The excess space could've come from the very long column name
of the first field.
Shrink that with an alias:
select if(substring) AS shortname, sec_to_time( ) AS
session ...
Cheers,
Kent Hoover
filter fodder:databas
The excess space could've come from the very long column name
of the
first field.
Shrink that with an alias:
select if(substring) AS shortname, sec_to_time( ) AS
session ...
Cheers,
Kent Hoover
filter fodder:databas
The GET_LOCK() and RELEASE_LOCK() functions might help you,
if
you need this feature enough to build it yourself.
Cheers,
Kent Hoover
Feed the filter: database, query
-
Before posting, please check:
http://www.mysql.com
Does the mysql user have write-permission in the directory where core
would be
written?
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
You can update the "first" row by adding LIMIT 1 to your update query.
If the rows are identical, "first" vs. "third" doesn't matter. If it
does matter,
you should probably add a unique, tiebreaking field (sequence or
DateTime, if
you can assure there will never be 2 identical records inserted per
Joel:
I'll take another shot. Do you have spaces in your command? Remove
them.
Change : socket = /var/run/mysqld/mysqld.sock
To: socket=/var/run/mysqld/mysqld.sock
Cheers,
Kent
-
Before posting, please chec
Sorry. Sent the last message before I was done
If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their
contents will override what you have set in /etc/my.cnf.
Cheers,
Kent
-
Before posting, please check:
http://
Tried /etc/my.cnf in place of /etc/mysql/my.cnf ?
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Your table bb is not indexed in a way that helps this query. Creating an
index on min_number may help somewhat.
If your intervals DON'T overlap each other, there's probably a much
better
algorithm for you to use than an SQL join. (e.g., select each number
from aa
in sequence, form a query for ea
I would try running multiple MySQL servers on your backup host machine,
where
each one is a slave to its own respective master DB. I think that keeps
maintenance
of replication/recovery/restore scenarios much cleaner. If your Master
DB A
breaks, what you have to do to recover it from Slave A is si
You could very well shorten the overall elapsed time if you can
configure your
script into 2 (or more) scripts, each doing 1/2 of your updates, and run
them
in parallel.
Cheers,
Kent
-
Before posting, please check:
http://w
I see in your 'Explain's, the 2 queries use different indexes, the fast
one uses soc_date_idx, and the slower one uses q_idx. The trick,
perhaps is to force
soc_date_idx to be used in the 2nd case. (Adding ORDER BY soc_date might
do it, 'soc_date=X and (queue_id=Y and server_id=Z) ) might do it.
$ myisamchk --set-autoincrement-value=1 YourTable.MYI
would reset the number to 1 for you. If you do not remove existing
records from
your table, your MySQL could generate errors as the new value collides
with
an existing record.
Cheers,
Kent
-
I think the -q option (quick, do not buffer output, but write it
directly to stdout)
is what you need.
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Tom,
Read about the MERGE TABLE type, which might satisfy your needs. It
allows
you do partitioning, and to index across partitions, but it does have
some
limitations.
Cheers,
Kent
-
Before posting, please check:
http://www
running 'top' 'ps -ef' or whatever
command is
available for your machine.
Cheers,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
That log rotation script smells like the culprit to me. Exactly what is
it doing?
If it is clipping the file in a way that doesn't let MySQL reset the
file pointer
when you do the flush logs command, you could be max-ing the file out
to its ulimit.
Cheers,
Kent
would give you the cache "miss rate".
Cheers,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thre
You can create a "MERGE TABLE" (read all about it in the manual)...
CREATE MERGE TABLE everything ( animalname varchar(25)) TYPE=MERGE
UNION=(table_1,table_2);
Thereafter, you can select * from everything;
Cheers,
K
Outside of MySQL, use a native OS command to rename or remove the
directory named '#Muffin' . If you rename it 'foobar', you should be
able to DROP it with
MySQL.
Cheers,
Kent Hoover
-
Before posting, p
Can I add, activate, and use a new UDF function to an already existing
udf_.so library without restarting MySQL server?
Thanks,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Because it may update the table, it could compromise other processes
reading it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
one.
The other solution is to not connect via 'localhost', but via your
server's IP address,
for which port 3400 should work.
Cheers,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/man
34 matches
Mail list logo
