Re: Rights required to run myisamcheck

Dan Nelson wrote: In the last episode (Jun 24), Jim Shea said: I'm setting up a cron job to run myisamcheck with the options "-Aacmorv". As I have to put in a username and password, for security I http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available priv

Rights required to run myisamcheck

I'm setting up a cron job to run myisamcheck with the options "-Aacmorv". As I have to put in a username and password, for security I want to create a special account that has the minimum required rights. In searching the docs I don't find this listed. http://dev.mysql.com/doc/mysql/en/GRANT.ht

Re: Minimum privileges required for mysqldump

At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: Give the use the lock option if you plan on using the --opt. How is that different than > Giving the "lock tables" permission as in: > grant select, lock tables on dbname.* to [EMAIL PROTECTED]; > results in the same mysqldump error. in the previous

Re: Minimum privileges required for mysqldump

On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Minimum privileges required for mysqldump: > I want to create a user that has the minimum rights to dump a database. I > can't find a discussion of the minimum required rights in the MySQL docs. At 2/27/2004

Minimum privileges required for mysqldump

I want to create a user that has the minimum rights to dump a database. I can't find a discussion of the minimum required rights in the MySQL docs. Included in my searching was: 5.4.3 Privileges Provided by MySQL and 8.7 mysqldump, Dumping T

installation and configuration!

Hi I am new to this group.I want to install MySQL on win 2000.Let me know from where we can get more information on Installation and Confugration. If some one has detailed list please send it. Thanks -Chris _ Get your FREE download

Re: SELECT, LEFT JOIN, and user variables

eft join source as sv2 on sv2.i=joinkeys.i and sv2.v=2 > >left join source as sv3 on sv3.i=joinkeys.i and sv3.v=3 > > ; > > > > >Fix: > >Sorry, I haven't a clue! In the SQL I'm attempting to > >optimize (inherited code) I don't a

SELECT, LEFT JOIN, and user variables

on't actually need the DISTINCT, but had tried using it and noticed this problem. >Submitter-Id: >Originator:Gary Shea >Organization: GTS Design Consulting >MySQL support: licence >Synopsis: Problem with variable-generated SELECT column with DISTINC

Re: Junction entities VS. JOIN

Benjamin, beautifully put. Thank you both so much. --Dylan Shea Benjamin Pflugmann wrote: > Hi. > > It's simply that you can look at (a_id,b_id) as a PRIMARY KEY. You > don't need an additional, aritificial sequence number ab_id. > > CREATE TABLE table_ab ( >

Back up procedure for Mysql

http://tips.pair.com/index.php3?page=php3mysql_backupmysqldatabase When use of the following examples replace $host with hostname/IP of your MySQL server. $user with your username $pass with your password $database with your databasename $table with your table

Re: ArabiaSoft and NuSphere

ckage. b.t.w. I was using the the RH7 Linux version. Installing Abriasoft SQL on top of a fresh RH7 install will solve you a lot of hassle due to bugs in key RH7 packages. --Dylan Shea "Frank J. Schmuck" wrote: > Any comments on the packages from ArabiaSoft

Re: Junction entities VS. JOIN

n record ids? Technically, it shouldn't, but does good db form require it? or is a junction entity normalization table exempt from that? thanks again --Dylan Shea "Carsten H. Pedersen" wrote: > > I'm afraid this borders on sql/db question material vs. specific mysql &g

Junction entities VS. JOIN

arches for b_id based on a a_id value are fast, and vice-versa? thanks --Dylan Shea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ