Upgrade MySQL 5.6 to 5.7 -

-

i'm quite new mysql , learning fast. installed wamp on system , have been using month or so. i'm looking upgrade mysql 5.7 in need of new gis features can't find easy follow step step on need do.

i have been reading on @ mysql on how done find either confusing or incomplete, not sure which. have been reading last 6 hours , still no closer knowing how done.

i have backed databases, i'm not concerned @ point still in development , learning state , rebuilt anyways.

how upgrade 5.6 5.7 full instructions?

  1. download zip version of mysql want run ( not msi installer, because dont know may or assume when installs ) suggested source [www.mysql.com]

  2. from wamp manager, stop services.

  3. go c:\wamp\bin\mysql\ , create new folder named appropriately i.e mysql5.5.28

  4. unzip mysql , copy contents of mysql folder newly created folder. make sure directory levels same existing mysql folder.

  5. copy contents of previous mysql\mysql5.5.10\data folder new data folder under newly created version folder. thats not databases, including ibdata1, ib_logfile0, ib_logfile1 , mysql-bin.0000xx files. going use recommended mysql-upgrade tool ok do. ensure keep users , password , granted privilages intact when upgrade complete.

  6. copy c:\wamp\bin\mysql\mysql5.5.10\wampserver.conf c:\wamp\bin\mysql\mysql5.5.28\wampserver.conf folders in here relative file lives, nothing need changing in here.

  7. right click wampmanager -> refresh make wamp manager find new version. check left click wampmanager -> mysql -> versions new version should available in list.

  8. from wamp manager -> mysql -> version click on new version. have uninstall old wampmysql service , re-install new wampmysql service, wamp takes care of clicking new version number. should start new mysql service, new mysql running. dont yet!!!

  9. launch command window ( using run administrator ). cd c:\wamp\bin\mysql\mysql5.5.28\bin folder ( new releases bin folder ). , run mysql_upgrade -u[your mysql admin userid] -p > upgrade_results.txt

it ask password admin user provided on -u parameter. enter password.

wait while runs, if have large databases may take time take few seconds minute or two. @ databases , upgrades required , upgrades/maintenace of mysql database mysql uses internally. thats tables contain userids , password , privilages , other things.

  1. check errors in upgrade_results.txt file, fix if there any. can repeat like, refresh data old versions data folder each time.

  2. left click wamp manager -> mysql -> service -> stop service. again , start service. load changed mysql database new/changed config info.

  3. at point assuming staying on newly installed version of mysql idea run: wampmanager -> mysql -> mysql console , run a

    reset master;

to reset log files.

from here: http://forum.wampserver.com/read.php?2,111797,124054


Comments

Post a Comment

Popular posts from this blog

python - Healpy: From Data to Healpix map -

-
Image
i have data grid rows represent theta (0, pi) , columns represent phi (0, 2*pi) , f(theta,phi) density of dark matter @ location. wanted calculate power spectrum , have decided use healpy. what can not understand how format data healpy use. if provide code (in python obvious reasons) or point me tutorial, great! have tried hand @ doing following code: #grid dimensions nrows*ncols (subject change) theta = np.linspace(0, np.pi, num=grid.shape[0])[:, none] phi = np.linspace(0, 2*np.pi, num=grid.shape[1]) nside = 512 print "pixel area: %.2f square degrees" % hp.nside2pixarea(nside, degrees=true) pix = hp.ang2pix(nside, theta, phi) healpix_map = np.zeros(hp.nside2npix(nside), dtype=np.double) healpix_map[pix] = grid but, when try execute code power spectrum. specifically, : cl = hp.anafast(healpix_map[pix], lmax=1024) i error: typeerror: bad number of pixels if point me tutorial or edit code great. more specifications: data in 2d np array , can change numrows/
Read more

c - Bitwise operation with (signed) enum value -

-
i using enumerator values flags: typedef enum { = 0x00, b = 0x01u, // u has no influence, expected c = 0x02u, // u has no influence, expected ... } enum_name; volatile unsigned char* reg = someaddress; *reg |= b; according misra-c:2004 bitwise operations shall not done signed type. unfortunately, compiler iar use signed int (or short or char) underlying type of enums, , option can find relates size, not signedness ("--enum-is-int"). according iar c/c++ development guide arm , pages 169 , 211, can define type of enum s if enable iar language extensions ( -e command-line option, or project > options > c/c++ compiler > language > allow iar extensions in ide). in particular, should define "sentinel" value, make sure compiler chooses correct type. prefers signed types, , uses smallest possible integer type, sentinel should largest positive integer corresponding unsigned integer type can describe. example, typedef enum
Read more

xslt - Unnest parent nodes by child node -

-
in xml there items 0-n attributes , item should copied each attribute new item 1 attribute. given xml this: <?xml version="1.0" encoding="utf-8" ?> <items> <item> <name>a</name> <attributes> <attribute> <key>attribute1</key> <value>1</value> </attribute> </attributes> </item> <item> <name>b</name> </item> <item> <name>c</name> <attributes> <attribute> <key>attribute1</key> <value>5</value> </attribute> <attribute> <key>attribute2</key> <value>2</value> </attribute> <attribute> <key>attri
Read more