So, does anyone out there who follows my blog know how to take the ENITRE OPERATIONAL STATE, including GRANTS (or permissions, or whatever you call them), usernames and associated passwords and all the table/db data and move it from one MySQL server to another and get it to work?
I am trying to move Inanis.net to a new platform and I can’t seem to get the MySQL permissions to work correctly. I use the command mysqldump -u root --all-databases > filename.sql to dump the data from the old box and something similar to pop it into the new box. I then copy my entire web directory (all the php apps like wordpress and mediawiki sit there) into the same location on the new box. I navigate to any of the web apps and get complaints about the webapps’ permission being denied because my damn SQL username/password combos are invalid.
So, isn’t this -all-databases trick supposed to dump the entire frigging system state, or does it do everything but users and permissions? If the case is the latter, that is the most asinine, inane thing I have seen in a while.
Or maybe I’m just dumb, tired, old, inexperienced or a mix of them all. Maybe I just forgot to do a FLUSH PRIVILEGES after my import- I dunno.
Leave ideas in the comments. Right now, I must go to sleep and dream about another day sitting behind a desk making money, all the while desiring just to get home to the SO and watch Jeopardy.