{"id":2141,"date":"2017-03-18T07:24:58","date_gmt":"2017-03-18T07:24:58","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=2141"},"modified":"2017-03-18T10:25:40","modified_gmt":"2017-03-18T10:25:40","slug":"upgrade-mysql-v-5-5-54-to-v-5-7-17","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2017\/03\/18\/upgrade-mysql-v-5-5-54-to-v-5-7-17\/","title":{"rendered":"Upgrade MySQL v. 5.5.54 to v.5.7.17"},"content":{"rendered":"

Ref: http:\/\/askubuntu.com\/questions\/750498\/mysql-5-5-update-to-mysql-5-7<\/a><\/p>\n

Here is what I’ve done:
\nDON’T FORGET TO BACKUP YOUR DATABASE FIRST! Pls read : http:\/\/myprojects.advchaweb.com\/index.php\/2017\/03\/18\/script-to-backup-each-mysql-database-in-separate-files\/<\/span><\/p>\n

    \n
  1. Download MySQL Apt Repository from https:\/\/dev.mysql.com\/downloads\/repo\/apt\/<\/a>. Currently the file name is ‘mysql-apt-config_0.8.3-1_all.deb’.
    \nSORRY, ONLY ADMIN CAN SHOW THIS!<\/span><\/li>\n
  2. Install it:\n
    sudo dpkg -i mysql-apt-config_0.8.3-1_all.deb<\/pre>\n<\/li>\n
  3. Then I’d got this screen\"\"<\/a>Select ‘MySQL Server (Currently selected: mysql-5.7)’ then ‘ok’.
    \nThen I’d got the second screen.    \"\"<\/a>Select ‘mysql-5.7’ then ‘ok’. Then if you get to the first screen again, just select ‘Ok’ and ‘ok’. The screen would be closed.<\/li>\n
  4. Update my ubuntu system\n
    sudo apt-get update<\/pre>\n<\/li>\n
  5. install the MySQL-server package, which now contains MySQL 5.7\n
    sudo apt-get install mysql-server<\/pre>\n
     <\/li>\n
  6. Now upgrade all mysql databases\n
    sudo mysql_upgrade -u root -p<\/pre>\n
     <\/li>\n
  7. Now restart mysql server\n
    teddy@teddy-K43SJ:\/media\/data\/MASTER\/MySQL$ sudo service mysql restart\r\n * Stopping MySQL Community Server 5.7.17\r\n...\r\n * MySQL Community Server 5.7.17 is stopped\r\n * Re-starting MySQL Community Server 5.7.17\r\nNo directory, logging in with HOME=\/\r\n..\r\n * MySQL Community Server 5.7.17 is started<\/pre>\n
     <\/li>\n
  8. Check mysql server version\n
    teddy@teddy-K43SJ:\/media\/data\/MASTER\/MySQL$ mysql --versionmysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using  EditLine wrapper<\/pre>\n
     <\/li>\n
  9. Everything run well. At the phpmyadmin, I found the max upload size is 2M. I can modify this value in php.ini file (‘upload_max_filesize’).
    \nTo find out where is the configuration file location for mysql, pls do like this:<\/p>\n
    \/usr\/sbin\/mysqld --help --verbose<\/pre>\n
    It’d show pretty long output, but I can found the line like this:<\/p>\n
    Default options are read from the following files in the given order:\r\n\/etc\/my.cnf \/etc\/mysql\/my.cnf ~\/.my.cnf<\/pre>\n
    SORRY, ONLY ADMIN CAN SHOW THIS!<\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    Ref: http:\/\/askubuntu.com\/questions\/750498\/mysql-5-5-update-to-mysql-5-7 Here is what I’ve done: DON’T FORGET TO BACKUP YOUR DATABASE FIRST! Pls read : http:\/\/myprojects.advchaweb.com\/index.php\/2017\/03\/18\/script-to-backup-each-mysql-database-in-separate-files\/ Download MySQL Apt Repository from https:\/\/dev.mysql.com\/downloads\/repo\/apt\/. Currently the file name is ‘mysql-apt-config_0.8.3-1_all.deb’. Install it: sudo dpkg -i mysql-apt-config_0.8.3-1_all.deb Then I’d got this screenSelect ‘MySQL Server (Currently selected: mysql-5.7)’ then ‘ok’. Then I’d got the second screen.Select ‘mysql-5.7’ … Continue reading “Upgrade MySQL v. 5.5.54 to v.5.7.17”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72],"tags":[],"class_list":["post-2141","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/2141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/comments?post=2141"}],"version-history":[{"count":5,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/2141\/revisions"}],"predecessor-version":[{"id":2149,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/2141\/revisions\/2149"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=2141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=2141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=2141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}