The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
65 views

Bugzilla migration from ubuntu 10.04 to 14.04 with Mysql 5.1 to Mysql 5.5

I am running Bugzilla 4.0 on Ubuntu 10.04.4 LTS running on physical server & thought of upgrading it to Ubuntu 14.04 on Hyper-V for testing. After migration of bugzilla webroot 4.0 to Ubuntu ...
0
votes
1answer
45 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and ...
0
votes
1answer
26 views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
0
votes
0answers
28 views

enabling ssl connection from wordpress to mysql

I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic my wordpress ...
0
votes
0answers
23 views

Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL

I get these error messages when logging in to phpmyadmin instance Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
0
votes
2answers
1k views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
0
votes
1answer
33 views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
1
vote
0answers
16 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
0
votes
0answers
32 views

WordPress site with no traffic; MySQL reporting 300-500 queries per second, frequently crashing

My server is running Debian 7.10 (Apache 2.2.22, MySQL 5.5.47, PHP5). It's a VPS. I've tried to summarise the issue in the title. I'm running a very small, private WordPress blog which is only ...
0
votes
0answers
19 views

mysqldump --databases option vs .my.cnf inconsistency

I had an issue which another serverfault issue solved, however, I'm trying to understand WHY. This issue is here: Mysqldump complains about chosen databases regardless of command line, and the ...
0
votes
1answer
148 views

Why can't I uninstall mysql-5.5 & install mysql-5.6 on Amazon Linux machine?

I'm on a 64-bit Amazon Linux machine. I had previously installed mysql-server 5.5. (using sudo yum install) However, I soon found out that my application requires MySql-serve 5.6. So I uninstalled ...
55
votes
17answers
64k views

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed ...
0
votes
0answers
124 views

Apache is using 100% CPU even with one user

Apache is using 100% CPU even with one user Apache (or should I say PHP through Apache?) is using 100% CPU for few seconds every time somebody search bugs at our bug tracker or just reload the search ...
2
votes
1answer
173 views

OpenShift/MySQL error: lower_case_table_names error when migrating from OS X to OpenShift

Ok, so I have dumped a MySQL 5.x database from an OS X instance, and am having problems importing the database into the OpenShift MySQL 5.5 container. My tables are Camel-case (eg "tblAccounts") but ...
1
vote
1answer
157 views

Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools

My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
0
votes
0answers
28 views

Mysql and HAproxy

Our java application hosting on jboss was connected directly to mysql server and it was working fine.As per new requirement HAProxy has been placed in front of MYSQL Server,It works but after few ...
0
votes
0answers
76 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...
0
votes
0answers
24 views

Debian Mysql 5.6 and MariaDB Instances on Same Server

I'm trying to have Mysql 5.6 and MariaDB to make comparison and track performance between each other. Everything i have found over the internet was this link: ...
2
votes
3answers
961 views

MySQL query cache is enabled but not being used

I've checked the query cache is enabled mysql> SHOW VARIABLES LIKE 'have_query_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | have_query_cache | ...
0
votes
1answer
30 views

Is MySQL using up all the memory? [duplicate]

I need help with reading this output of free -m. This server has a total of 32 GB of ram but it shows 9383 used and 290 free. The rest seems to be in the buff/cache. I am running mysql on this server ...
1
vote
2answers
457 views

Cannot upgrade mySql on a Debian 6 server using apt-get

I run a Debian 6 server and use it to host a dozen of LAMP based websites. I configured it to email me whenever a software update becomes available, and this morning I received the notification for 6 ...
0
votes
1answer
216 views

Accidentally delete ibdata1, ib_logfile1 and ib_logfile0

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
3
votes
1answer
7k 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 ...
0
votes
2answers
2k views

Create a super user in MySQL 5.5 not working: Permission denied for root@localhost

Using CentOS 6, logged in to MySQL as root, entering the command: create user 'user123' identified by 'pass123'; works fine. But when I try and give that user super user privileges with: grant ...
3
votes
0answers
37 views

script cannot connect to Mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Mysql server seems working properly and running also i can connect to the database via ssh command, here's the my.cnf file directives: [mysqld] #port=3306 datadir=/home/mysql ...
-5
votes
2answers
52 views

MySQL crashes running but not working [closed]

Mysql is running but it not responding when using phpmyadmin when i check mysqld.log it tells: [root@dc /]# tail /var/log/mysqld.log 151111 8:58:21 [Note] /usr/libexec/mysqld (mysqld 5.5.46) ...
2
votes
2answers
5k views

Upgrading MySQL 5.5 to 5.6

I've decided to do the update of MySQL from 5.5 to 5.6 on my CentOS server. How can I backup MySQL5.5 in case I want to downgrade, and how can I install MySQL 5.6? Is there a way to use yum for ...
0
votes
1answer
125 views

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night ...
1
vote
3answers
2k views

Replication issue with mysql 5.5.8 while restoring the dump on master server.

While restoring the Mysql dump file it throws the following error. ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one ...
0
votes
0answers
25 views

mysql keeps lossing user permisions

We have a mysql database on ubuntu 14.04 server. It was working really fine for months until some weeks ago, when it started with this thing. It suddenly losses all user permisions and we have to set ...
-1
votes
1answer
47 views

Ubuntu Mysql stop working after outofmemory in a clamscan, mysqld.sock

I'm having daily problems with postman with autentification througth mysql on my Ubuntu14LTS Server. I think the problem arrise after a clamscan scron that breaks in an Out of Memory. In some way ...
0
votes
1answer
59 views

Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?

My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
1
vote
2answers
228 views

MySQL 5.6 replicate live master WITHOUT down time

Following the steps to replicate an existing server, it seems most methods rely on the ability to either completely stop the master server or at least prevent it from writing using flush tables with ...
1
vote
1answer
19 views

Examine MySQL INNODB folder

Consider the following situation. I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it. Data for the mysql-server can be found under; ...
0
votes
0answers
11 views

import of mysql binary log stopped can I restart the import

I'm doing a two hourly import of binary logs, but nog during an import I had a crash. Can I restart this import without having duplicate data ? Thanks
3
votes
2answers
3k views

Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'

I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do: SET GLOBAL ...
0
votes
1answer
94 views

Warning while upgrading MySql 5.5 to 5.6

I'm trying to upgrade MySql from 5.5 to 5.6 in my Ubuntu machine. While running command sudo apt-get install mysql-server-5.6 we encountered with warning like : 2015-07-01 18:47:58 0 [Warning] ...
0
votes
1answer
184 views

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
-1
votes
2answers
619 views

MySQL keep crashing

So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
10
votes
3answers
14k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
1
vote
0answers
70 views

Possible have 2 php.ini file or 2 extension_dir in php.ini?

i got Fatal error: Class 'mysqli' not found in C:\apache2triad\htdocs\index.php on line 8 error. I checked php.ini file and saw extension=php_mysql.dll is uncommented.Everything is normal. But in ...
1
vote
1answer
612 views

Can't create/write to file '/mnt/temp/something' (Errcode: 13)

I changed the tmp directory of the mysql configuration to a mounted disk and on service mysql restart I get following error: Can't create/write to file '/mnt/temp/something' (Errcode: 13) To my ...
1
vote
1answer
356 views

Special characters in mysql password using mysqldump

I have the following ssh script: #Here I am getting the mysql password for the root user password=$(cat /root/.my.cnf | grep "password" | awk -F\" '{print $2}') #here I am trying to dump the ...
-2
votes
1answer
68 views

Moving data between drives CentOS 6 + cPanel [closed]

Recently, my server crashed. The hosting company has installed new CentOS on a replacement drive and attached the old drive to my server. I have installed and setup cPanel onto the new server and ...
0
votes
2answers
363 views

Replication server crash - > 18:39:32 UTC - mysqld got signal 11

Below you can see the part of the log showing the crash. The replication server is 5.6 and the master 5.5 but this setup has worked with warnings for the last week or so. Now, after trying to change ...
-1
votes
1answer
982 views

mysqltuner: Thread cache is disabled

Mysqltuner says " Thread cache is disabled" but according to my.cnf, it is not. Why is that? Here is the my.cnf content. [mysqld] log=/var/log/mysql.log datadir=/var/lib/mysql ...
1
vote
0answers
245 views

Mysql table doesnt exist error after trying run from lvm snapshot

I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave. The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
1
vote
1answer
149 views

Apache2 / tomcat / MySQL / PageSpeed Server hanging once a day

My server started to hang at least once a day. It remains so until I restart Tomcat. I'm not sure yet which part causes the problem, so I'm trying to work on several hypotheses: My website is served ...
3
votes
1answer
603 views

High CPU on MySql Fusion-io server

I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication. MySQL ...
0
votes
1answer
255 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...