Notes for compiling and upgrading mysql, such as php connection to mysqlnd phpmyadmin and mysqlndphpmyadmin

Notes for compiling and upgrading mysql, such as php connection to mysqlnd phpmyadmin and mysqlndphpmyadmin

For the InnoDB engine, copy the ib_logfile0, ib_logfile1, ibdata1, and database folders under the data Directory (only frm files are in it)

Don't be afraid of the version. What is wrong with my. cnf? Despite the cold backup, if it feels large, tar compression can be used to make compression more efficient.

For the myisam engine, copy the database folder (including MYD, MYI, frm) under the data Directory)

Of course, it is best to use the cp-pr command, p is to save the meaning of the attribute.

Compile and install mysql to specify the path. Of course, if you cannot set the sock file and pid file during compilation, you can also specify it in my. It is best to specify the path during Backup.

Run ps aux | grep mysql to check the original sock, pid, log, and data paths.

The connection to php seems to be a php issue now. There are no problems concerning the installation of mysql and php (mysq5.6.23, php5.6). The connection method uses mysqlnd.

Php is installed with the php56w source, because it is not very important, it does not matter in which directory (my service provider only provides weekly backup of the data disk)

Ps: At the beginning, php cannot connect to the database. It was found that the mysql client api in the phpinfo information table is of the old version, not mysqlnd. After php5.5, mysqlnd is provided by default.

Even though the pdo mysql method does not seem to provide