MySQL Forums
Forum List  »  Install & Repo

Re: problems upgrading 5.7 -> 8.0.15
Posted by: Frederic Descamps
Date: April 02, 2019 06:12AM

Hi Hans,

Setting innodb_fast_shutdown to 0 doesn't need to be followed by a restart.

It seems you replaced the binaries without stopping mysqld.

So the procedure is:
1. run mysqld upgrade checker (you did that already)
2. set global innodb_fast_shutdown =0
3. stop mysqld
4. upgrade the binaries
5. start mysqld (it will take some time)
6. run mysql_upgrade (won't be needed in 8.0.16 and >)
7. restart mysqld

I've installed the WP Google Map pluging, I've the wpgmza tables and I didn't encountered any issue.
However I didn't get much data ofc.

wp.wp_wpgmza OK
wp.wp_wpgmza_categories OK
wp.wp_wpgmza_category_maps OK
wp.wp_wpgmza_circles OK
wp.wp_wpgmza_maps OK
wp.wp_wpgmza_polygon OK
wp.wp_wpgmza_polylines OK
wp.wp_wpgmza_rectangles OK

lefred.

Options: ReplyQuote


Subject
Written By
Posted
Re: problems upgrading 5.7 -> 8.0.15
April 02, 2019 06:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.