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

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 the

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

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 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't