All Questions
20 questions
2
votes
2
answers
461
views
Table column length is fine in MySQL 5.5 and 5.6, but upgrading to 5.7 results in too many columns
So I have a CMS that is being upgraded from MySQL 5.5 -> 5.7. One table has a 1000+ columns, but it works fine in 5.5 and 5.6. When reaching 5.7, queries involving this table result in a 1117 error. (...
- 121
1
vote
0
answers
64
views
MySQL won't start after 5.5 security upgrade
I have the MySQL data directory running in a non-standard location on an Ubuntu 14.04 server. Last night it received a security upgrade and now will not start. The error message is
Can't find file: '...
- 11
0
votes
1
answer
544
views
How do correct mysqld.log error messages on start up? [duplicate]
I'm running Plesk and CentOS 6.7
Following is the excerpt of the log file mysqld.log when I restart mysqld service.
I normally don't check this log file, but I just noticed some errors messages. It ...
- 133
1
vote
1
answer
135
views
Installing MySQL from a noinstall Zip Archive - Should I Overwrite System Tables and Data?
I am performing a MySQL upgrade on a system that had MySQL installed using the noinstall Zip archive approach. (It's installed in c:\mysql). In order to keep with this approach, we are avoiding the ...
- 411
0
votes
0
answers
56
views
MySQL Upgrade query
I have 5.5.44-log MySQL Community Server (GPL) running in one of my RHEL 6.4 server. I need to upgrade the server to Percona Server-5.6.29-76.2. How to go about the upgrade? Should I completely remove ...
- 1,926
0
votes
1
answer
656
views
MySQL percona 5.6 to MySQL 5.5 replication
Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup.
Scenario ...
- 159
9
votes
2
answers
28k
views
Set sql_mode “blank” after upgrading to MySQL 5.6
After upgrading MySQL from 5.5 to 5.6, some our app face to problem and need set sql_mode to blank to solve this issue. I added sql_mode = '' to my.cnf but there was no effect on the mysql setting.
...
- 163
1
vote
1
answer
316
views
Unknown sticky Problem after MySQL upgrade
few weeks ago we upgraded mysql server from 5.5 to 5.6
on 1st server few days ago (5May) I reboot mysql server , after this customer reported that some database data table not load to their site . (...
- 163
0
votes
1
answer
3k
views
How to restore data after MySQL Upgrade?
I upgraded from MySQL 5.5 to 5.6 by uninstalling 5.5 and then installing MySQL 5.6. Now that MySQL 5.6 is running, none of my DBs or data is present/visible in MySQL Workbench.
I also see that I ...
AlexG
2
votes
1
answer
1k
views
Unable to run update_mysql in MySQL 5.5
I have recently taken over managing a MySQL database running on Windows Server 2008 R2. It is running 5.5.37 Community Edition. When it is started, it includes the following lines:
Thread, Type, ...
- 21
1
vote
1
answer
230
views
Migrating MyISAM tables from 5.5 => 5.6
I was wondering if anyone had any pointers on migrating MyIASM tables from mysql 5.5 to 5.6, specifically using Percona builds, via an rsync?
Is this safe?
I know we need to do a full mysqldump/...
- 5,263
1
vote
1
answer
501
views
Upgrading MySQL 5.1 to 5.5 - All tables gone [closed]
I'm trying to upgrade from MySQL 5.1 to MySQL 5.5.
I followed the instructions here:
http://dev.mysql.com/doc/refman/5.5/en/windows-upgrading.html
I also adjusted the Datadir.
But after the upgrade, ...
- 143
2
votes
1
answer
6k
views
Upgrading MySQL 5.1 to 5.5 on Centos 6 without removing dependencies
I'm trying to upgrade MySQL 5.1 to 5.5 using yum/rpm combo (yum to remove MySQL 5.1 and rpm to install MySQL 5.5). Most instructions I've found suggest to do first:
yum remove mysql mysql-server ...
- 203
2
votes
2
answers
3k
views
Changing the mysql.proc table directly after upgrade
Our host upgraded our mysql install without us knowing from roughly 5.1 to 5.5.
This caused a problem because the table definition of mysql.proc is different as discussed here:
http://bugs.mysql....
- 1,051
0
votes
1
answer
6k
views
In place upgrade from MySQL 5.5 to 5.6.11 removes all users from user table
On Windows, I upgraded from 5.1 to 5.5 no problem.
Copied my 5.1 data folder into my 5.5 instance
Started mysqld skipping grants
Ran mysql_upgrade
All good, but going from 5.5 to 5.6:
Copied 5.5 ...
1
vote
2
answers
5k
views
Steps to upgrade MySQL from version 5.0 to version 5.5
I have been developing under MySQL v5.0 for a while now and need to upgrade to v5.5 to be in step with the hosted production server.
After having searched for precise steps to do this migration, I am ...
- 111
6
votes
1
answer
9k
views
Unknown option '--no-beep'
I installed a new version of MySQL server (previously 5.0, now 5.5) and I copied the data folder in to the new one. Now I should perform mysql_upgrade. I opened the command prompt (server is located ...
- 163
0
votes
2
answers
3k
views
MySQL 5.5 Fail start Fedora 16
I installed mysql and mysql-server from the repos (MySQL version 5.5).
Then tried to start it, but got an error.
[root@server]# service mysqld start
Redirecting to /bin/systemctl start mysqld....
Almaron
1
vote
1
answer
1k
views
I am getting an error while trying to download binary for mysql 5.5.11
I am trying to upgrade MySQL 5.1 to 5.5.11 on Ubuntu 10.10. Everytime I try the wget command I get this error:
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.11-linux2.6-i686.tar.gz/from/...
- 565
7
votes
1
answer
1k
views
Yum update mysql from 5.1 to 5.5
I was just in the process of 'yum updating' a server. One of the updates its suggesting to carry out is an upgrade from mysql 5.1 to 5.5.
The mysql server operates in a master-master replication ...
- 141