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?
How do I import data stored in a .sql file (created by mysqldump command) under UNIX or Linux operating systems?
How do I find out mysql server version number under UNIX / Linux operating systems?
How do I install a module or extension for PHP applications that use MySQL databases under CentOS / Redhat / RHEL / Fedora Linux?
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?
How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?
Can you tell me where are MySQL error and other log files are located under Linux / UNIX / BSD operating systems?
