MySQL DBA Tutorials & HowTos

MySQL tutorials and howtos for database admins, sysadmins, DBAs, webmasters, and Unix/Linux users who wish to improve their database skills such as backup, security, optimization, management and much more (rss feed).

I‘m trying to make backups using the mysqldump command and getting the following error or warning:

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

How do I fix this problem?

{ 7 comments }

I‘m getting the following error in my mysql.log file:

100630 2:03:39 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘./app2_db/aix_data_user_c.MYI’; try to repair it

How do I fix this error and repair my table under UNIX or Linux operating systems?

{ 1 comment }

How do I install Oracle (Sun) MySQL database server v5.x under Ubuntu Linux operating systems? How do I add a new user and database for Apache web server and php access under Ubuntu Linux?

{ 4 comments }

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 }

I got new server and installed phpMyAdmin. But whenever I visit the phpmyadmin url it says:

Cannot load mysql extension. Please check your PHP configuration

How do I fix this problem under CentOS / RHEL / Fedora Linux Apache web server?

{ 5 comments }

I‘m trying to install mysql-server package under Debian using the following command:

apt-get install mysql-server-5.0 mysql-common

But I’m getting an error which read as follows:

Reading package lists… Done
Building dependency tree
Reading state information… Done
The following packages were automatically installed and are no longer required:
libdevel-symdump-perl liburi-perl libhtml-parser-perl libapr1 libhtml-tree-perl libpq5 libhtml-tagset-perl libwww-perl
Use ‘apt-get autoremove’ to remove them.
The following extra packages will be installed:
libdbd-mysql-perl libmysqlclient15off mysql-client-5.0
Suggested packages:
tinyca
The following NEW packages will be installed:
libdbd-mysql-perl libmysqlclient15off mysql-client-5.0 mysql-common mysql-server-5.0
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
E: Archive directory /var/cache/apt/archives/partial is missing.

How do I fix the problem?

{ 1 comment }

How do I import data stored in a .sql file created by mysqldump command on Linux or UNIX like operating systems? How do I restore mysql database backup using bash shell based command line option?

{ 2 comments }