Migrate MyISAM tables to INNODB using mysqldump

In this article you will find information how to convert MyISAM tables to INNODB.  The procedure here is an offline procedure, i.e, you cannot have changes on the SOURCE database, while you do this. A better way could be to setup replication between the SOURCE and the TARGET, but that is not described here. On the source database In this example we dump out the database...

Installation Mysql, php, apache

My environment: OS Red Hat Enterprise Linux Server release 6.5 (Santiago) MySQL Version 5.1.73-community MySQL Community Server (GPL) PHP PHP 5.6.10 (cli) Htdoc Directory /u01/qlts/public_html Apache Configuration ...

How to fix Error Vietnamese font on Xampp

[Describe]:  [FIXED] Step 1: Open Xampp Control Panel, Click Config on MySQL Module Step 2: Open my.ini Step 3: Uncomment rows following and save file my.ini collation_server=utf8_unicode_ci character_set_server=utf8 skip-character-set-client-handshake character_sets-dir="C:/xampp/mysql/share/charsets" Step...

How to change MySQL datadir

Step 1: Create new data folder for mysql (For example: /u01/mysql/data) [root@ptudvtg149 ~]# mkdir -p /u01/mysql/data Step 2: Copy all old data of mysql to new folder ( old folder: /var/lib/mysql) [root@ptudvtg149 mysql]# cp -r /var/lib/mysql /u01/mysql/data/ [root@ptudvtg149 mysql]#chown -R mysql:mysql /u01/myql Step 3: Edit /etc/my.cnf ...

MySQL - Resetting a lost MySQL root password

Not the Server root user A common issue is confusing the Server root user with the MySQL root user. The Server root user is the server's main user. The MySQL root user has complete control over MySQL only. The two 'root' users are not connected in any way. Stop MySQL The first thing to do is stop MySQL. If you are using Ubuntu or Debian the command is as follows: sudo...

Chapter 4: Dumping Applications Manager's data to MySQL 5.1

Prerequisites: It's very important, you have to backup Applications Manager data before you execute this task. We recommended take complete backup of everything in Applications Manager. ( see Chapter 3) Dumping Applications Manager's data to MySQL 5.1 When starting Applications Manager, MySQL Server 5.0.5, which is bundled with the product, is started. Applications...

Chapter 2: Installing and Upgrading MySQL 5.0 to MySQL 5.1

Prerequisites: Check your OS' version: [root@poller1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) Check your existing MySQL that came with the Linux: [root@poller1 mysql]# rpm -qa | grep -i mysql5.0.95-5.el5_9 perl-DBD-MySQL-3.0007-2.el5 mysql-5.0.95-5.el5_9 mysql-connector-odbc-3.51.30-0 mysql-5.0.95-5.el5_9 Login your...