0
votes
1answer
20 views

Dovecot MySQL Authentication SlowDown

I have an IMAP/POP3/Webmail server with Dovecot1 2.2.10 with a MySQL backend located on another server. The server runs with default configuration. ... driver = mysql default_pass_scheme = plain ... ...
1
vote
2answers
30 views

run second mysqld instance for backup restore

I am trying to start a second mysqld instance to restore data from backup (innoDB). Following the manual I put together this: P="/var/lib/reoback/backups/2014-06-30/var/lib/mysql" cd $P mkdir tmp ...
1
vote
2answers
36 views

start mysql service after syncing data dir to tmpfs

hej there! I'm maintaining a network of 8 Pandaboards. One of them is acting as server to host a php-based browser game, others are clients running that game. The server runs Debian Wheezy from SD ...
-1
votes
0answers
31 views

MySQL Server Is Slow

I have two MySQL servers and one was just recently setup. The one I just recently setup is a bit slower than my older one, which kind of bothers me because I don't want my clients to be upset with the ...
0
votes
0answers
226 views

Mysql not starting after upgrading debian squeeze to wheezy

I recently bought a VPS box with Debian Squeeze pre-installed as the OS. I upgraded to Debian Wheezy and most things work fine (e.g. apache). The problem I'm having relates to MySQL - which is just ...
1
vote
1answer
635 views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
1
vote
1answer
299 views

Can't start mysql server

I'm facing problems installing a software package that depends on MySQL. During the installation it installs a MySQL server, but for some reason starting the services fails and thus the installation ...
2
votes
1answer
135 views

monit mysql server blocked because of too many bad connections

Is there any tweak for monit or another way to monitor whether one server can access mysql on another server? I tried it with monit but as you probably know, after 10 attempts, mysql blocks the ...
0
votes
1answer
364 views

Updating php5-mysql for MySQL 5.6 under Debian 7

After a lot of troubles installing MySQL 5.6 for Debian 7 (with ISPConfig) (FYI, I followed this tutorial : http://xmodulo.com/2013/12/upgrade-mysql-server-debian-ubuntu.html) my PHPMyAdmin shows me ...
0
votes
0answers
19 views

Extremely weird proftpd behavior

I have configured proftpd + mysql and it is working Its working perfectly despite the overcomplicated queries. However when I enable DefaultRoot ~ It stops working and somehow reverts to some ...
0
votes
0answers
27 views

MySQL Service allow local connections through hosts.allow

I have my hosts.deny set up as ALL: ALL but when I do this I can't seem to allow MySQL in hosts.allow. I need it just on the local network. I've tried: mysql: LOCAL mysqld: LOCAL and as a last ...
0
votes
1answer
195 views

Dovecot handshake failure, on Postfix success

I am trying to setup a Dovecot/Postfix structure, relying on a MySQL backend. I came across a problem with SSL configuration, and it's really tearing my hair out... Situation Dovecot listens on port ...
0
votes
0answers
24 views

pureftpd per domain mysql

I am trying to configure PureFTPd with mysql for a multiuser hosting. What i would like to accomplish is that each "client" is an account on the system, but each of those clients can have multiple ...
0
votes
3answers
81 views

Remote access forbidden (HY000) to specific mysql client

A MySQL server is located at central.hwcharts.com; it is the master of a basic master-slave replication which replicates toward host0.hwcharts.com, located on a different physical machine which ...
1
vote
2answers
113 views

MySQL shut down it self periodically

I recently bought 512MB, 2.2GHz, 20GB SSD - VPS Server and installed Debian Wheezy 64-bit and it is used as WEB Server. I have installed Apache2, PHP, MySQL, ClamAV, Anti-DDoS, Spam Assain, Postfix, ...
1
vote
0answers
71 views

LVS-DR and OpenVPN: returning packets not being routed into the vpn

i've set up a load balancer with ldirectord, and an active-passive mysql service managed by it, on two additional real servers. LVS is running in Direct Routing mode, so the client requests are ...
0
votes
0answers
185 views

MySQL from Deb changing configuration after installing perl packages?

This will sound silly, I'm sure. Here goes. I have a new installation of Debian Wheezy (Debian7). Instead of going with the aptitude installation of MySQL that right now holds v5.5.31 I went with the ...
0
votes
2answers
134 views

Apache2 Debian server falls. Out of memory

help me please with my apache problem. I got an droplet at DigitalOcean with 512mb of RAM (Debian). There are 3 sites on MODX CMS (works on php). Today morning as i think system discovered an out of ...
-1
votes
2answers
117 views

How to add support of bcrypt to mysql?

Following this answer mysql does not support bcrypt because system does not support them either. How to add support of bcrypt to Debian to MySQL?
0
votes
1answer
20 views

syscp cron_traffic.php needs 10 minutes to execute

I use syscp on debian and i noticed that this script is taking more than 10 minutes to execute: date ; /usr/bin/php5 -q /var/www/syscp/scripts/cron_traffic.php; date Do 5. Dez 12:09:09 CET 2013 Do ...
0
votes
2answers
58 views

freebsd-like jail with debian for mysql (updating db schema)

I have debian box with big database. I want to do a lot of risky operation with this database. Its about updating the sofware which works with this db. I can stop database for 5 min, but not for ...
0
votes
0answers
34 views

Pinpointing PHP performance problems after upgrade

I have done an upgrade of my server from debian 6 to 7.2, along with moving from PHP 5.4 with APC to PHP 5.5 with OpCache and APCu (both running as php-fpm). MySQL and Apache are still the same ...
0
votes
2answers
112 views

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | ...
0
votes
1answer
68 views

Debian mysql-proxy reserved connections

I was looking in too the mysql-proxy configuration, and decied to install it in order to make an access point to my servers whenever they reach high peak, however i want to have 5-10 reserved ...
0
votes
0answers
95 views

postfixadmin doesn't create table but create database

Already i downloaded and installed postfixadmin ,But for version compatibily, i' forced to install from debian repository. I prevent to wonderful thing, It is installed successfully , creates ...
0
votes
2answers
201 views

autossh -> private key without passphrase

I would like to tunnel a mysql database. So I thought I use a private key without a passphrase to make it reboot friendly. The problem is, openssh still asks me for a passphrase and if I leave it ...
0
votes
1answer
190 views

Mysql remote connections very slow - host lookups already disabled

I followed every instruction about this issue and nothing helped. Remote communication with MySQL server takes 4-30 seconds on simple query like select 1 from table_name and connection attempt often ...
-1
votes
1answer
72 views

Python cant connect to local MySQL server through socket [closed]

I have a python script which is designed to add things to a MYSQL database. The error I get is this: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock I've checked the ...
2
votes
2answers
2k views

How to reinstall broken mysql package

Trying to fix a broken mysql installation, this happened after upgrading from debian 6.0 to 7.0. I have the dotdeb.org packages in my /etc/apt/sources.list. root@ginger:/var/log/mysql# apt-get ...
0
votes
2answers
938 views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
1
vote
2answers
580 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
1
vote
5answers
4k views

After installing Mysql 5.6 the server can't start

The mysql server is installed on a clean install of Debian 7 Have tried this serveral times each time on a clean install of Debian installation # apt-get update && apt-get upgrade # ...
3
votes
2answers
8k views

How to install Mysql 5.6 on Debian 7 wheezy

I'm trying to install Mysql 5.6 on Debian 7 Wheezy.. After installing the mysql database/folder /var/lib/mysql/mysql is empty # groupadd mysql # useradd -r -g mysql mysql # apt-get install libaio1 # ...
0
votes
0answers
102 views

Performance drop after hours of runtime - how to detecting bottleneck

I am running a local database server for 1 client machine. My DB server runs redis (version 2.6.13) and mysql (5.5.31-30.3-log Percona Server (GPL), Release 30.3). I have 1 Client machine that runs a ...
-1
votes
2answers
224 views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
-1
votes
3answers
115 views

Reinstall mysql and keep mysql data [closed]

In Debian, /root/bin folder was deleted. The biggest problem is that mysql is missing. When I type: > mysql -bash: mysql: command not found I have all data in /var/lib/mysql. How do I install ...
0
votes
3answers
3k views

Failed mysql upgrade to 5.5 on debian wheezy

When upgrading debian squeeze to wheezy, the upgrade of mysql to mysql-server-5.5 fails: # apt-get dist-upgrade -u ... Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ... [ ok ] Stopping MySQL ...
-1
votes
3answers
2k views

How to install MySQL 5.6 on Debian (wheezy or squeeze) and make it work

How to install MySQL 5.6 on Debian (wheezy or squeeze)? The package is on mysql site but what's next? Thanks for first answers. I actually installed it but it won't work.
0
votes
1answer
158 views

PHP processes keep overwhelming my server, eating up the CPU and making it lock up :(

I have a Debian Squeeze Lighttpd server with PHP and MySQL, and also with XCache and Varnish set up. I am quite new to this, but have tried as hard as I can to resolve this problem with no success. ...
1
vote
2answers
618 views

PHP mysqlnd on Debian 6

I've installed php5-mysqlnd via: apt-get install php5-mysqlnd This is a brand new virgin Debian install with just apache2 and php5 via: apt-get install apache2 echo "deb ...
0
votes
2answers
358 views

Apache and MySQL doesn't start at boot

I am running Debian 6 on a server. On this server I want to have an instance of Apache2 and MySQL started when the system boots. For this purpose I know there are the init.d script and the symbolic ...
-1
votes
1answer
115 views

Can't install anymore MySQL on debian after deletion of various folders [closed]

So here is my story: I've been thinking "Why am I using MySQL 5.1, if there is already 5.6 out?", therefore I wanted to install 5.6 on my debian root server(it is a playground/testserver, not a ...
1
vote
3answers
8k views

MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11

I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
1
vote
3answers
937 views

Error installing mysql, any way to fix it?

I was installing mysql with apt-get install mysql-server (like I always did) before that I had done an apt-get update (I am using Debian 6), and when I installed I found this problem, pretty common as ...
2
votes
1answer
138 views

How can I isolate my Apache and MySQL installations on the same server? [closed]

I have a 8GB RAM Linux server which will be running Apache and mysql. First I was thinking of chrooting mysql (and apache) but then thought of putting mysql in a virtual machine on the same server, ...
4
votes
1answer
278 views

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that ...
0
votes
1answer
61 views

MySQL table records changes every second

I was using a PHP script running on background to grab data and insert them into the mysql database... i stopped the PHP from logging and checked the table records, i found that its being changed ...
0
votes
2answers
123 views

MySql: how to empty the database

So, until today we were testing our website. Now we want to switch to the next level and we need to empty the db in order to do that. This means that we would like to be at the starting point, with ...
-1
votes
1answer
814 views

MySQL partition “full”? [closed]

I have a server that runs Debian 6.2, with Apache, PHP5, and MySQL. Well, I hadn't done anything with MySQL at all so far, just Apache and PHP; I must have installed it (mysql-server) at some point ...
0
votes
1answer
32 views

mysql client binary size zero

I was using the openpanel-mod-mysql module when I kept getting weird error messages. Then I set out to execute the commands manually and got no response from mysql. I mean, when I typed in mysql, ...