Is there some easier way to backup all databases and users and permissions etc in WAMP than to do each one manually via phpmyadmin. Apache is using a lot of CPU ( rather it jumps around a lot even when nothing is happening that I'm aware of ) so I would like to just uninstall it and reinstall.
I have about 10-15 databases each with it's own user and I want to keep most of them. ( unless that many databases is the cause of the problem in the first place, but I'd be surprised at that ).
I am using Windows 7.
From home page on phpmyadmin you can export all dbs, just click on tab export. The users are stored on Mysql DB table users
I suggest to chose only your dbs to export instead export all of them, because you will get troubles if you try to import system mysql dbs back via phpmyadmin
table users is stored in "mysql" db. user privileges are stored within table "USER_PRIVILEGES" in information_schema db and table "db" in "mysql" db
You should login as root to see system databases.
When export system tables use custom method, and on "Function to use when dumping data" dropdown use "REPLACE" instead "INSERT"