Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5.6]

42 questions
1
vote
1 answer

Foreign Key Constraint Error 1005 erno 121

I'm racking my brain trying to get this table created. Other tables create just fine in mariadb 10 with similar constraints. I've run it through debuggers with no success. ERROR 1005 (HY000) at line 401 in file:…
user417568
  • 11
  • 3
1
vote
1 answer

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 mysql-server 5.5. (using sudo yum remove…
Saqib Ali
  • 559
  • 1
  • 9
  • 18
1
vote
1 answer

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 other clients using MySQL server 5.5. The…
Daniel Klose
  • 135
  • 2
  • 6
1
vote
0 answers

How I can reduce disk IO in MySQL 5.6.26?

I was using MySQL version 5.1.52 for my application but recently I have updated it to 5.6.26, but now I am facing very high disk IO. Following are system configuration: OS : Linux 2.6.39.4 RAM : 2GB Disk : 30GB Compact Flash. My O.S is same just…
purvesh pardeshi
  • 11
  • 3
1
vote
1 answer

Mysql 5.6 client is unable show UTF8 characters

Mysql databases are hosted on AWS RDS Mysql 5.6 On one of the EC2 Cent OS 6.5 instance, I had Mysql Client 5.1. I used it to execute SELECT queries over the RDS-Mysql. There is one particular query that we do to generate a CSV file. The database…
anup
  • 717
  • 4
  • 9
  • 19
1
vote
1 answer

AWS RDS mysql.rds_set_external_master remains disabled after setting autocommit to 1

The goal is to create a master-master replication consisting of two RDS MySQL 5.6 instances, db0 and db1. I orientate myself by this article. So far, I have created db1 as a read-replica of db0 and set read_only = 0 and autocommit = 1 at db1's…
user540468
  • 162
  • 2
  • 3
  • 10
0
votes
0 answers

An specific timezone is not available on a RDS Aurora MySQL cluster

I have a database in RDS MySQL 5.7 instance and within the Parameters Groups I have defined the parameter "time_zone" as "America / Santiago", but now I want to migrate the database to an Aurora MySQL Serverless cluster (Running MySQL 5.6) but the…
FrancoVP
  • 101
  • 1
0
votes
1 answer

How do I configure postfix for Mysql 5.7

I made the appropriate changes to postfix to get mysql 5.7 working as the database instead fo Maria DB. I can run tests and all seems to work on the server. However, I cannot log into my account from my email client. I continue to get 'invalid…
Doug Wolfgram
  • 135
  • 2
  • 7
0
votes
0 answers

How do I determine what is causing MySQL (Percona server) to crash on Linux

I am running the Percona version of MySQL Server v5.6 and every few days the MySQL seems to crash and then automatically restart itself. How can I work out what the reason is for the crash? I've seen other people with MySQL stopping unexpectedly and…
Andy Castles
  • 98
  • 1
  • 9
0
votes
1 answer

mysql service suddenly stopped working

I am suddenly not able to start mysql service /etc/init.d/mysql start Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.pid). I have tried to do the following but still not working chmod -R 777…
all_techie
  • 101
  • 1
0
votes
1 answer

How can I set mysql connection charset to utf8 in apache mod_dbd?

How can I set connection charset to utf8 in apache mod_dbd with mysql driver? I could not find any corresponding parameter in DBDParams, something like this: DBDParams…
Ehsan Khodarahmi
  • 305
  • 1
  • 7
  • 18
0
votes
1 answer

AWS RDS mysql upgrade 5.5 to 5.6

What is the best/easiest way to upgrade and RDS instance running mysql 5.5 to 5.6. I have seen two potential methods: modifying the instance - this seems the easiest method - have people done it - did it work - what problems were there creating a…
matpol
  • 318
  • 1
  • 5
0
votes
0 answers

I cannot get data from the same database on different hosts with different versions of mysql-server

I have a web site that has moved to a new server. I moved the site to a web-server running apache24 and php56. It came from a server with apache24 and php55. When I use the old external (different host/server) database that runs mysql57 all goes…
Lexib0y
  • 227
  • 3
  • 14
0
votes
1 answer

No Match for argument: php5-mysql and No package php5-mysqlnd available

I came across the following warning : PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50550 Library:50631 in /var/www/html/web_app/test/browser/dbconn.php on line 31 After researching online, I came to…
Tan
  • 139
  • 1
  • 3
  • 8
0
votes
1 answer

mysql replication fail (no error)

I'm doing a replication on a mysql 5.6 server (master) to a slave in mixed mode. The thing is, i connect to mysql trought workbench, i execute querys and are replicated. But if another user connected through the same way, deletes a register, it is…
user362986
  • 11
  • 2
1
2
3