July 4, 2013 at 6:44 am #25744
I have managed successfully to use the enfold theme and design it. I did it on my own server.
Now I want to move the entire site to a new domain name and server. (of the client) So what I did is download the files of my FTP and uploaded them to the new server. (not at the root, but in a folder called wordpress)
I exported the database from my server, and made a new mysqldatabase+user at my clients server.
But then I want to import the database to this database I get an error:
jankedevries_nlDEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
#1044 – Access denied for user ‘measured’@’localhost’ to database ‘jankedevries_nl’
I have actually no idea what I’m doing (just following random step-by-step guide), but does it make sense to anyone here what goes wrong?
I hope someone can help.
JankeJuly 5, 2013 at 7:46 am #128046
Bad idea. Database has a lot of things hardcoded in there including your local domain name and other things.
1. There are a number of ways to do this. The easiest would be for you to move all the files. then you would need to go into Settings > General (this is on your local install) and change the WordPress Address (URL) and the Site Address (URL) to your live site. and save. The theme will immediately stop working (since its on your local computer) and that’s when you immediately export it as SQL and reimport it on your live site.
Allowing wordpress to change the url itself is much cleaner than messing around the database and counting the number of characters in domain names in multiple tables.
2. You need to use the exact same salts as you been using on your local development. What are salts? Those encrypted looking random keys inside your wp-config.php file since they are used everywhere in the database. In fact just take your entire wp-config.php , change the database, password to your live server, but leave the 8 salts as they were. This is important or you will get errors , in fact errors identical to the ones you are getting.
Also before doing that (which should be the very last thing you do), you should run some database optimizer plugins, as well as plugin for transient optimisation. Also remove every single revision. Basically cut the fat off the database and then change those urls save and go into phpmyadmin to export as sql (with insert commands overwrite)
NickJuly 7, 2013 at 11:53 pm #128047
Thank you Nick, I got it to working without the error. I wasn’t sure what you mean with the salts, but I haven’t touched it and it seems to work now!
Thanks a lot!
JankeJuly 8, 2013 at 1:42 am #128048
There are 8 lines in wp-config that you generate, 4 are keys and 4 are salts. They look like this
Glad you got everything working.
The topic ‘move site’ is closed to new replies.