database - After WAMP update & migrate, mysql tables have no structure / primary keys -


we've moved wamp drive on our server - old version wamp 2.4, , new 1 wamp 2.5. installed 2.5 fresh on new drive, , copied www , mysql data folders old install.

it's 'working' - sites appear run fine - i've discovered database structure appears gone. database tables have no primary keys, , no visible structure in phpmyadmin.

this case databases brought new wamp install in mysql data folder new databases: can export database structure remote server, after importing local wamp server structure stripped.

two questions:

(how) can database structure restored?

how can create or import new databases structure?

curiously sorted out after attempting troubleshoot issue undoing changes. tried:

  • restarted wamp services, exited , reopened wamp - unsuccessful.
  • copied entire old mysql folder new wamp install, attempted run mysql service old mysql version - unsuccessful.
  • reverted newer version of mysql came wamp 2.5 (back initial state before troubleshooting), restarted services - unsuccessful.
  • waited 10 minutes - table structure returned, working correctly.

this leads me believe there interaction process or condition on server, rather misconfiguration of wamp.


Comments

Popular posts from this blog

Receive udp packets in android gstreamer -

php - Extract Text from HTTP referer -

c# - ASP.NET MVC Enumerable to delimited HTML in Razor -