Re: Administrative limitation

. -- David Fleming [EMAIL PROTECTED] If multiple databases are not an option, quite a few applications (phpbb, oscommerce, etc) support installations with prefixed table names (IE phpbb_thistable, phpbb_thattable) Dan Vande More -- MySQL General Mailing List For list archives: http

Auditing

for this? Thanks! Dan Vande More -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Auditing

can have a daemon get the information, but mysql doesn't support that either. (my.cnf:log=/var/log/mysql.fifo) Has anyone else found solutions for this? Thanks! Dan Vande More -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Cut Copy Paste

Mysqlfront works well, though I don't believe you can cut. -Original Message- From: Mark Herzog [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: Cut Copy Paste Cut, Copy, and Paste functions are not available in the SQL Query tool in my

FW: Automatic timestamping

Yes, just change the row in some way(or insert a row), and it will insert the date automatically. (be sure to insert null in the timestamp field, or leave it out of your update query) I use the feature for many things. Thanks dan -Original Message- From: [EMAIL PROTECTED]

RE: why does MySQL need to access the internet? my firewall wants to know

Yes, it is most certainly because mysql wants to open port 3306. If it's zone alarm, it probably says it's trying to access 127.0.0.1. -Original Message- From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:26 AM To: Matthew K. Gold; MySQL Subject: Re: why

RE: Lost root password

http://www.mysql.com/doc/C/o/Command-line_options.html See --skip-grant-tables -Original Message- From: michael johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:33 AM To: Support at Mysql; mysql@lists. mysql. com Subject: Lost root password We have a support

RE: help !

Do a telnet 10.10.10.250 3306 then a ctrl-] to end it. What do you see? -Original Message- From: Brett Whittaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:29 AM To: [EMAIL PROTECTED] Cc: Brett Whittaker Subject: help ! I was trying to connect into an MYSQL database,

Binary File in DB vs. File in directory --looking for archived discussion

I'm trying to find any and all thoughts on whether to store files in the db (PDF's, word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead because of new folders, each client having thier own folder(and subfolders) etc. And then htaccess'ing the dir's

Binary File in DB vs. File in directory --looking for archived discussion

I'm trying to find any and all thoughts on whether to store files in the db (PDF's, word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead because of new folders, each client having thier own folder(and subfolders) etc. And then htaccess'ing the dir's

multiple db, multiple table join

Good evening all, I have a strange situation which I cannot think myself out of. To make it simple my db looks like this (hr db, emp_master table) ++---+ | emp_id | last_name | ++---+ | 1 | smith | | 3 | wesson| |

RE: SubSelect Problem

Perhaps I am missing something right in front of me, or I have not been in the loop, but it is my understanding that MySQL does not support sub-selects, yet. http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html BTW, you may receive lots of replies of this very nature, because it is something

RE: problem running the mysql server!

A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I google it. Google turned up A LOT of results for a 1067, with tons of fixes. The query I used was mysqld-nt 1067 The first results it pulled were from mysql's site,

FW: problem running the mysql server

-Original Message- From: Dan Vande More Sent: Sunday, March 17, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: RE: problem running the mysql server! A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I

RE: Problem with using INSERT INTO [table] SQL string

Hey Don, I read the whitepaper and it have come to the conclusion that when MS used the words mySQL, they were not referring to MySQL, which is the list you are on. They were referring to mySQL as my SQL just the same as myconnection and Myemptywallet. You see, most of us come here to get away

RE: Delete User problem.

You would have a hard time removing the privileges using GRANT, I would suggest using revoke: http://www.mysql.com/doc/G/R/GRANT.html -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Delete User

FW: IS THIS BETTER?

Is there a way to spam control caps? Like if 75% or more of the content is Capitalized, them ditch it rather then having to delete it manually? Sql , query -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:19 PM To: [EMAIL

RE: sql help examining log table

I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from outgoing where auth='USER' group by subject order by timestamp desc limit 50 This would tell you each subject ever sent by the user, and how many times that subject has been sent.

RE: sql help examining log table

of coffee:) -Original Message- From: Dan Vande More [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:44 PM To: [EMAIL PROTECTED] Subject: RE: sql help examining log table I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from

RE: mysql.sock

That's because you get this: '020317 16:48:10 mysqld ended.' It means there was an error, and the database server is no longer running. Check your mysql log files to find out why. Does the user, 'mysql' have permissions to write into the directory mysql is using, normally /var/lib/mysql Who is

RE: Finding out whos using the database

SHOW PROCESSLIST -Original Message- From: Chip Wiegand [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 1:30 AM To: [EMAIL PROTECTED] Subject: Finding out whos using the database Is there a command that I can use to find out how many people, or more specifically, who, is using

RE: MySQL tables named 'column' cause problems.

Column is a mysql reserved word. Just like desc or asc or tons of others. See here: http://www.mysql.com/doc/R/e/Reserved_words.html Dan -Original Message- From: Tozz [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 8:58 PM To: [EMAIL PROTECTED] Subject: MySQL tables named

RE: Help with selects

Kacey, I used this, works great! http://www.netmechanic.com/news/vol3/javascript_no12.htm -Original Message- From: Kacey A. Murphy [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: RE: Help with selects I am doing a similar thing except I

RE: DBI installation

You should befriend a little program called webmin, available at www.webmin.com/webmin Once installed go to Other and perl modules, it does it all for you... Dan -Original Message- From: Andy Cheng [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 6:19 PM To: [EMAIL PROTECTED]

RE: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it?