Re: help with mysql db names

2013-04-18 Thread Keith Keller
On 2013-04-19, Doug wrote: > > why these db names created fail but the last one gets success? [snips] > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; > mysql> create database e1c6aa32; https://

Re: MySQL on RHEL4

2013-04-06 Thread Keith Keller
On 2013-04-05, Nitin Mehta wrote: > > However, i'm not sure which case it is because in the downloads, it says > "Platform: Oracle and Redhat 4&5" > Isn't it supposed to work? The downloads section is titled "Oracle and Red Hat 4 and 5", but each individual download is clearly marked as just 5.

Re: MySQL on RHEL4

2013-04-04 Thread Keith Keller
On 2013-04-05, Nitin Mehta wrote: > > We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the > installation gives error:libc.so.6(GLIBC_2.4) is needed by > MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by > MySQL-server-community-5.1.68-1.rhel5.i386 Now,

Re: console input

2012-06-15 Thread Keith Keller
On 2012-06-14, Gary Aitken wrote: > > So... I wanted to read the data line at a time and use a plain INSERT > statement. That way I could check for duplicate keys and discover where the > duplicate records are. However, I can't find a way to read input from the > console or a file. What am

Re: console input

2012-06-14 Thread Keith Keller
On 2012-06-14, Gary Aitken wrote: > > So... I wanted to read the data line at a time and use a plain INSERT > statement. That way I could check for duplicate keys and discover where the > duplicate records are. However, I can't find a way to read input from the > console or a file. What am

Re: Emergency backup from *.frm *.MYD *.MYI files

2012-06-08 Thread Keith Keller
On 2012-06-09, Miguel Cardenas wrote: > > My linux system died due a bad system driver and it does not boot > ANYMORE, I am backing up my data files to restore a previous worlking > backup of the whole system that DOES NOT INCLUDE THE DATABASES... I hope you will be correcting that in the future!

Re: delete syntax

2011-12-01 Thread Keith Keller
On 2011-12-02, Tim Dunphy wrote: > > Thanks but I probably should have noted that I only want to delete the > wildcard user. There are other users I would prefer to not delete. > > mysql> select user,host from mysql.user where user='mail_admin'; > ++---+ >| user

temp tables rights?

2004-03-30 Thread Keith Keller
Hi all, Suppose I have a user who has been granted select and create_tmp_table, but no other privileges, on a given database. When I attempt to insert into any temporary table, permission is denied, presumably due to the user not having insert on the database, and no entries in mysql.tables_priv

Re: server backups

2004-03-19 Thread Keith Keller
On Fri, Mar 19, 2004 at 11:50:43AM -0500, Charles Hauser wrote: > > I'm interested in writing a cron job to backup mysql that will: > - Backup all the global information first (users and groups, typically) This information is in the mysql database; unlike postgres, there's no concept of ''global