≡ Menu

MySQL

mysqldump: Copy Database Using Shell Pipes

How do I use mysqldump command with Unix shell pipes?
[click to continue…]

Sysadmin because even developers need heroes!!!

MySQL: Connect From an Other System / Computer

How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?
[click to continue…]

Find Out MySQL Version

How do I find out mysql version under Linux or Unix operating systems?
[click to continue…]

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?
[click to continue…]

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.MYI’; try to repair it

How do I fix this error and repair my table under UNIX or Linux operating systems?
[click to continue…]

Ubuntu Linux: Install MySQL Server Version 5

How do I install Oracle (Sun) MySQL database server version 5.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?
[click to continue…]

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

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?
[click to continue…]

phpMyAdmin: Cannot load mysql extension. Please check your PHP configuration

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?
[click to continue…]

E: Archive directory /var/cache/apt/archives/partial is missing Error and Solution

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?
[click to continue…]

MySQL Import File / Database Command

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?
[click to continue…]