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.
Responses to this post » (9 Total)
Comment Meta:RSS Feed for comments
TrackBack URI
Pages 
Categories 
Tag Cloud 
Entries RSS 
Seven 
City 
Characters 
Landscape 
Nature 
Shapes ![[-]](http://www.inanis.net/blog/wp-content/uploads/2010/06/happymac.png)
![[-]](http://www.inanis.net/blog/wp-content/themes/seven/images/st_link.png)
It’s been a while since I’ve done one, but if I remember correctly, users and permissions are all stored in a separate database that all MySQL installs have. In the schema “mysql” you’ll see a table called “user”. I believe that is the one that contains all users and user permissions. If you back up that table and recover it into your new database, I believe that will do what you need. Keep in mind that the other schemas on the server have to be the same, but that sounds like it won’t be an issue.
Hope that helps you.
Mate, trying to contact you via your contact form, but its not working…. cant get the answer thing to work.
Heres my question anyway.
Hey fella,
Loving the theme, although i have 2 issues I’m trying to work out.
1 – i would like to make the defualt page layout expand to the full width of the uesrs screen (the button at the top of the header)
2 – i would like to set a default page background colour image, how?
Been looking in the editor, but i got bored and wondered if you could give me a quicker answer.
Thanks
Dan
Wrong place to put this comment, but I understand because apparently my contact page isn’t working so… (EDIT. but I just tested it and it IS working… just that no one knows the answer to the secret question. HA! Look it up people!)
Having the default page width set to something other than “small” is a feature I added in (or was working on, I don’t remember right now) for the next bugfix. It’s minor on the grand scale, but I don’t think the theme editor is going to help you out with that because changes to the Javascript file need to be made to grab the width setting from useroptions.php and reset the page size to “middle” or “large” upon page load.
Changing the default page background color is done through the stylesheet. Look for the BODY descriptor on line 11 of style.css. You can set the background picture and color both on that line.
Hey Mate,
You haven’t brought over the mysql database called mysql that is for users, etc. What you should do is just bring the users part of that database over. Then everything should work!
I thought about that, and read something to the effect of “you shouldn’t do that because it will break your MySQL installation.” Since I am doing this on a development-like basis to determine a procedure so when I am ready I can just pop it over, it might not hurt to actually try. Just gotta find time and energy to get back to it. Thanks for the suggestion!
It just sounds like your MySQL username and password combination on the new machine have changed. Double check this and change the username and password combination respectively for your web applications.
Example: Wordpress MySQL username and password should be stored in a file called wp-config.php in the Wordpress root directory.
I agree, generally. The username and password don’t match because the wp-config.php points to a MySQL user that doens’t exist because Wordpress has not been installed on the new server, rather it’s been copied. My focus is to move the whole kit-n-kaboodle from the old server to the new one, pop some files in place, and just boot the thing up so I don’t have to go through the process of actually reinstalling Wordpress and my content, and doing the XML export/import thing, and installing and reconfiguring all my plugins and widgets. I think I may have to do what Rohan above said and copy the usernames database from the old box to the new one.
Make the same mysql user on the new site, create the same name database (like the name on the original) server with that user!Then export the database from the original server and delete the line “CREATE DATABASE `db_name` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;.After this import the “db_name.sql” into ur new server.
I just installed ur wp theme its cool, and saw ur blog.
Good Luck
Thanks for the suggestion. I did create the same user on the new box, but the permissions (i.e. the links in the database that say xyz user has abc access to table 123) didn’t copy – so while I was able to get rid of unknown user problems, I began to have invalid permission problems.
I’ll look into this again eventually, because I want to get the system running a more up to date version of the OS and SQL, additionally converted from 32-bit to 64-bit…