Copy a database from old WAMP installation folder to another

Question

I just install a fresh copy of WAMP, and I want to import couple of databases from the old one to the new one, so I entered to the old mysql data directory C:\wamp-old\bin\mysql\mysql5.7.14\data, and copy the relevant databases there to the new data directory. But when I try to access the tables in phpmyadmin, I get a message saying that the tables aren't exists, but they do:

What am I missing?

Answer 1

You forgot to copy the ibdata file.

Answer 2

I did it successfully just now:

1. make a copy of wamp folder (wamp-old)
2. uninstall the wamp
3. install the new wamp (overwrite all the files if u were asked)
4. start the wamp
5. ck the localhost and phpmyadmin
6. copy your databases from the old-wamp only from C:\wamp-old\bin\mysql\mysql5.7.14\data and paste to the same location in new wamp
7. then copy and paste ibdata file from the above path and replace in new one.

You are done!