MySQL 5.6 : Latest Release of MySQL with improvements that enhance every functional area of the database kernel.
2
votes
2answers
37 views
MySQL version confusion
How is this possible:
I installed mysql-5.6.11-osx10.7-x86.dmg which is supposed to be version Mac OS X ver. 10.7 (x86, 32-bit), DMG Archive (32 bit!)
But upon SHOW VARIABLES LIKE "%version%"; I get ...
0
votes
1answer
14 views
General error 1651 after a mysql migration
I finished migration from 5.1 to 5.6, and (with the same queries as before) mysql complains right away about:
General error: 1651 Query cache is disabled; restart the server with
...
0
votes
0answers
25 views
Mysql 5.6 and install php5-mysql , mysql-common
I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 ...
1
vote
3answers
69 views
Issue on mysqldump in MySQL5.6
I did upgrade the MySQL server from 5.5 to 5.6
I am trying to take dump for a table like this
mysqldump -uroot -p dba admin > D:\admin.sql
But it gets following error
mysqldump: Couldn't ...
0
votes
1answer
31 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 ...
2
votes
2answers
50 views
Does MySQL 5.6 support fan-in replication?
I've known for quite awhile that Continuent's Tungsten Replicator supports fan-in replication (example).
By fan-in replication I mean combining multiple datasources into a single instance (like a ...
1
vote
1answer
51 views
Issues converting MyISAM table to InnoDB (auto column issue)
I'm having issues trying to convert a table from MyISAM to InnoDB in MySQL 5.6.
The following is the table dump:
--
-- Table structure for table `companies`
--
DROP TABLE IF EXISTS `companies`;
...
0
votes
1answer
45 views
MySQL: replicating to a different table engine type
According to the replication documentation from MySQL, it is possible to set up replication from InnoDB source tables to MyISAM destination tables. Unfortunately, the documentation has little to say ...
0
votes
1answer
112 views
Is using the alpha version of Percona 5.6 safe? [closed]
I'm really sorry if my question is kind of very basic, but is something that is really making me thinking a lot about it for a long time. As Percona has a lot of lines of optimizing codes, I run it ...
1
vote
1answer
167 views
MySQL 5.6 OS X 10.8: how tell if my.cnf read?
With mysqld running, I expect to see that /etc/my.cnf has been used by at least one of the commands
ps aux | grep mysql | grep -v grep
mysqladmin variables | grep defaults-file
showing the value ...
1
vote
1answer
371 views
MySQL 5.6 Failure
I have the following in RPM_UPGRADE_HISTORY in /var/lib/mysql
MySQL RPM upgrade to version 5.6.10-1.linux_glibc2.5
'pre' step running at Fri Mar 15 15:41:26 EDT 2013
ERR file(s):
-rw-r----- 1 mysql ...
1
vote
1answer
47 views
Can't query one view from another?
Okay, I'm moving a database from SQL Server (which I already miss) to MySql 5.6. I'm having a problem creating a list of valid dates. In SQL Server I just used CTEs to build up numbers, then months, ...
0
votes
1answer
173 views
MySQL5.6 on Mac OS X 10.6.8 problems when granting permissions to root
I'm having serious problems with a MySQL 5.6 instance on a Mac Server.
We had to upgrade MySQL to a newer version, but it turned to be a bad idea, as we lost control to it. We had a backup of the ...
0
votes
1answer
153 views
Cannot find MySQL Server Config Wizard for MySQL 5.6 build
Not sure if this is the right Stack Exchange site for this but...
I am trying to reconfigure my mySQL instance but cannot find the config wizard. I looked here:
...
0
votes
1answer
191 views
Unable to change engine to MyISAM in MySQL
I have installed MySQL 5.6.10 on Mac OS X 10.6.5. My issue is that MySQL is using InnoDB as its default engine.
I have checked following engines are supported in MySQL:
show engines\G
...
