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 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 }

How do I install a module or extension for PHP applications that use MySQL databases under CentOS / Redhat / RHEL / Fedora Linux?

{ 3 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?

{ 8 comments }

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?

{ 0 comments }

Can you tell me where are MySQL error and other log files are located under Linux / UNIX / BSD operating systems?

{ 0 comments }