0
votes
1answer
19 views

How can I move a MySQL database from 5.1 to 5.6?

I have pretty big database, like with 5 000 000 rows in total. It is located in a remote server. I want to copy this database to my personal computer, for testing purposes. However I don't know the ...
0
votes
1answer
40 views

MySQL: How index speed up query execution

I have read multiple articles about MySQL indexes. Some of the important pages are below: http://dev.mysql.com/doc/refman/5.6/en/mysql-indexes.html ...
0
votes
1answer
51 views

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

I have installed MySQL-5.6.x community edition on RHEL5. It was running fine. Since, it is my testing server. To find the differences in execution timing, I have to install the MySQL-5.1 community ...
0
votes
1answer
35 views

MySQL: How to find MySQL 5.1 (with built-in InnoDB) or MySQL 5.1 (with InnoDB-plugin)?

My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific purpose of improving my system performance and removing the bottleneck issue. So, I have gone ...
0
votes
2answers
66 views

MySQL: Moving Database from Windows to Linux

I have a Windows based dedicated server have below configuration: Windows edition: Windows Server 2008 R2 Standard Service Pack 1 Processor: Intel(R) Xeon(R) CPU X5460 @3.16GHZ 3.16 GHZ (2 ...