mysql server

I‘m trying to set ‘thread_concurrency to 8 under Linux MySQL server. But when I try to restart the mysql server, I get the following error:

[ERROR] /usr/local/libexec/mysqld: unknown variable ‘thread_concurrency=8′

How do I fix this problem?

{ 0 comments }

MySQL Import Command [ Database Import ]

by Vivek Gite on December 7, 2009 · 0 comments

How do I import data stored in a .sql file (created by mysqldump command) under UNIX or Linux operating systems?

{ 0 comments }

When I run the following command at mysql> I get an error which read as follows:

mysql> use dbname;
mysql> show tables;
ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

How do I fix this problem under Debian Linux?

{ 0 comments }

Lost MySQL Admin Password

by Vivek Gite on March 17, 2009 · 2 comments

I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?

{ 2 comments }

MySQL Bin Files Eating Lots of Disk Space

by Vivek Gite on December 16, 2008 · 7 comments

Q. I get a large amount of bin files in the MySQL data directory called “server-bin.n” or mysql-bin.00000n, where n is a number that increments. What is MySQL Binary Log? How do I stop these files being created?

{ 7 comments }

How do I fix error – “Your PHP installation appears to be missing the MySQL extension which is required by WordPress” under Debian Linux Apache 2 server?

{ 19 comments }

MySQL List Databases

by Vivek Gite on April 12, 2008 · 3 comments

Q. How do I display a list of all databases under MySQL Server?

{ 3 comments }