Re: New to MySQL

2014-03-04 Thread Andrew Moore
Percona, MariaDB and Oracle provide YUM repos now. Remove all traces of MySQL before starting install using ; rpm -e {package} --nodeps then grab your YUM packages. A On Tue, Mar 4, 2014 at 7:01 PM, Brian Van der Westhuizen [DATACOM] < brian.vanderwesthui...@datacom.co.nz> wrote: > Why don'

Waiting for table metadata lock

2014-03-04 Thread Basil Daoust
InnoDB question So I have a rename table command that sometimes locks up with the waiting message. We have tried a few things, and nothing has worked well yet. So I was wondering is their a method in reducing the time this lock last for? Can I change any MySQL settings, increase space, get faster

RE: New to MySQL

2014-03-04 Thread Brian Van der Westhuizen [DATACOM]
Why don't you just use yum install . Should sort out most if not all your problems regarding installation of mysql. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Wednesday, 5 March 2014 1:21 a.m. To: geetanjali mehra Cc: Johan De Me

Re: New to MySQL

2014-03-04 Thread Reindl Harald
Am 04.03.2014 13:20, schrieb Asma rabe: > I have checked before installation if mysql is installed using which mysql > i found no mysql is installed. which is pointless rpm -qa | grep mysql > next i did rpm installation and got the errors > rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm > > I got

Re: New to MySQL

2014-03-04 Thread Asma rabe
Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.s