move site

Hi,

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)

Thanks,

Nick

Hi,

There are 8 lines in wp-config that you generate, 4 are keys and 4 are salts. They look like this

define('AUTH_KEY',         'O-la1#lZ]~tL9;la2#+aOD-pH5]laOqH6]iXP.xqPD+pe6eTHymb3<fTI^ujIA;iX');

define('SECURE_AUTH_KEY',  ']WH[~pG9:ha1#-L9;mW;#+PH_xletE2iXP<yPI6+]*XPE+ui3<fXM,ynE7{qiX.y');

define('LOGGED_IN_KEY',    'O-l6]iWL.+pD2]pa5]~WL9xM,$rI7ncQ3<$UIBynE7{,UJ!vkF4>gYN}^zQF3rjY');

define('NONCE_KEY',        '<tH6]iX;.xI7{jX<$QI7$qf6{jXM.ym7}jYM,znF3yrf7{^UIByn7}!YNBzoF4>r');

define('AUTH_SALT',        '>R@sh8:kZO|-oRGzod4[!ZNCsdZOD-thG5slZ1[~WC5laWH5tiH5]hapH5;eT]*xP');

define('SECURE_AUTH_SALT', '6*XI^yjA3<YMBznF>gUJ<$vjY3>$NB4rg80,cRJ>@rNB0rgU}^vJ8}kdR[@wNC!v');

define('LOGGED_IN_SALT',   'k4>@VJ!vkC0|VK_-lC5[hVK[-VK8wkZ1|WK9xla5]eWK[~sK5:lZ1#-L9;ma2#+TH');

define('NONCE_SALT',       '.PAxma.yQE3qf7{^fTI*uMAqbT,ynF3rfU}^vUI^ujB<bUIvnF4>gUJ!vUJ7vj');

Glad you got everything working.

Thanks,

Nick