www.hkvforums.com

I'm moving my DB to a new server and having trouble getting connected. My old DB was named 'fishriv_FKMainestay' and my new one 'fortkent_VFC'. I would prefer of course to keep the same name, but you must go with the hostname as a prefix, so the DB name will be different, though it will be otherwise identical to the old one. Imported the SQL with no problem. So now the only difference between the two is the name. The problem is that for some reason, PHPMaker will not see this new DB in the 'Database' dropdown. There is another DB there that I suppose has to do with the system called 'information_schema' and it sees this fine and imports it fine. But it will not look at any new DB that I make, even though in PHPmyAdmin, they show up together. Is there some setting on the server that might hide that particular DB from PHPMaker? That's issue number one.
Then there's the issue that, once I get this first problem resolved and the DB is visible in the Connection tab and I can load it, will all my settings remain the same in PHPMaker for this 'new' DB, identical to the old one, even though the name of the DB is changed? Thanks for help.

Problem solved. It was the fact that although I had set up 'Remote Access' for my local IP, I had forgotten to 'add the user', 'fortkent_****' and set permissions. Once that was configured, it worked like a charm to 'import' the new database with the new name and preserve all my project's settings. As I read in a previous post, it's important to 'Synchronize' rather than 'Connect' when you do this to keep your project intact. Ura!