WDCP Upgrading the Database mysql5.5

Using WDCP to upgrade the database is a very necessary thing, but many multi-server programs are not very familiar with the developers every time here complain incessantly, because many of the online a lot of self-think the detailed method for us is a bit of a bad operation, because we are unfamiliar with the program to save what button is not known.

So here I will give some rookie developers to share the complete Linux server WDCP upgrade MySQL novice complete solution:

"Upgrade MySQL version to 5.5"

wget http://down.wdlinux.cn/in/mysql_up55.sh
SH mysql_up55.sh

Wait patiently until "MySQL update is OK" appears. At this time although the script prompts the MySQL upgrade completed, but the site can not login WDCP backstage, ssh next check even MySQL process is not started, if the MySQL process manually: Service mysqld restart, start error:

Starting MySQL ... error!
Starting mysql.the server quit without updating PID file (/www/wdlinux/mysql-5.5
.27/data/unassigned.psychz.net.pid).

Workaround: Enter the command: vi/www/wdlinux/init.d/mysqld edit the MySQL configuration file via the VI command (press I to enter edit mode, press ESC to exit edit mode, enter: Wq save exit) and add the following configuration for the new two lines:

basedir=/www/wdlinux/mysql-5.5.27
Datadir=/www/wdlinux/mysql-5.5.27/var
Or the following two lines of code can also:

Basedir=/www/wdlinux/mysql
Datadir=/www/wdlinux/mysql/var

Save exit, restart the MySQL process, enter: Service mysqld start, start successfully! It is worth mentioning that the entire modification process requires the action, first I into the editing mode, after entering the editing mode to modify the above file content, and then to exit the editing mode, in the last line of editing content to write code: WQ, you can exit vim and then go back to root. You can complete this database upgrade by restarting MySQL after you return to the root command. The above tutorial believes that an ordinary novice can also complete the MySQL upgrade.

WDCP Upgrading the Database mysql5.5