UBUNTU16.XXX Installation mysql5.0 Project Migration Environment construction

Brief description: This is mainly because of the relocation of the computer room, originally a 09-year Ubuntu installed 9.x System, later upgraded the kernel for 10.x, the above service configuration confusion needs to be collated, the leader wants to upgrade the system, reinstall the same software as the previous server. Because of the age, now the system upgrade to 16.x more difficult to find the old version of Source.list source, try to offline their own local source, rely on the solution, and finally find a relatively full source abroad. After the installation is complete, MySQL does not have the configuration file, self-customization has the problem, finally after looking for help configuration file, resolved, as follows

[Client]port = 3306socket =/var/run/mysqld/mysqld.sockdefault-character-set=utf8[mysqld]port = 3306socket =/var/run/mysqld/mysqld.sock

#一, cannot create mysqld.pid

#与my-innodb-heavy-4g.cnf comparison, must be modified into the above or always error

#[error]/usr/sbin/mysqld:can ' t create/write to file '/var/run/mysqld/mysqld.pid ' (errcode:13)

#[error] Can ' t start server:can ' t create PID File:permission denied

skip-external-lockingdefault-character-set=utf8init_connect= ' Set names utf8 ' key_buffer               = 16Mmax_allowed_packet       = 4Mthread_stack             = 256kthread_cache_size       = 128table_cache             = 1024thread_concurrency      = 10sort_buffer_size = 6mread_buffer_size = 4mjoin_buffer_ Size = 8mmyisam_sort_buffer_size = 16mtmp_table_size = 128mquery_cache_limit        = 4Mquery_cache_size         =32mset-variable = innodb_buffer_pool_size= 4gset-variable = innodb_additional_ Mem_pool_size=64mmyisam-recover          = backupmax_connections         = 1000expire_logs_days        =  10max_binlog_size         = 100mskip-federated

#二, link file modification configuration file error

#另外注意这几个文件的连接情况

[Email protected]:/etc/mysql# ls-al/etc/mysql/my.cnf.fallback-rwxr-xr-x 1 root root 833 Jan 15:17/etc/mysql/my.cnf. Fallback[email protected]:/etc/mysql# ls-al/etc/alternatives/my.cnf.fallback lrwxrwxrwx 1 root root all Jan 14:56/etc /alternatives/my.cnf.fallback,/etc/mysql/my.cnf.fallback[email protected]:/etc/mysql# ls-al/etc/mysql/ my.cnflrwxrwxrwx 1 root root 13:43/etc/mysql/my.cnf-/etc/alternatives/my.cnf.fallback

#三 and Troubleshooting methods

#重要的排错方法

#systemctl Status Mysql.service #查看状态信息

#journalctl-xe #查看具体错误信息

#四, MySQL help document review, and finally find a workaround

#dpkg-L softname#dpkg-s softname#dpkg-s softname#aptitude#apt-file list softname#/usr/share/doc/mysql-server-5.0/ examples/my-large.cnf.gz#/usr/share/doc/mysql-server-5.0/examples/my-small.cnf#/usr/share/doc/mysql-server-5.0 /examples/ndb_mgmd.cnf#/usr/share/doc/mysql-server-5.0/examples/my-huge.cnf.gz#/usr/share/doc/mysql-server-5.0 /examples/my-innodb-heavy-4g.cnf.gz

#我是通过my-innodb-heavy-4g.cnf.gz This file to modify the

This article is from the "ends of the earth" blog, please be sure to keep this source http://1983939925.blog.51cto.com/8400375/1891103

UBUNTU16.XXX Installation mysql5.0 Project Migration Environment construction