Importing WP settings to another host

Follow the steps:

  1. Copy/Move all files to new location
  2. Export database from old mysql server and import data in new server (you can use phpmyadmin for that)
  3. Select wp_options table using phpmyadmin from new location.
  4. Edit 2 entry in option table with option name home and siteurl . set option value = new location url
  5. Login to wp-admin.
  6. Go to setting >> Permalink and update permalink structure if you were using that on old location
  7. And you’re done. Your new site is live now.

Source: http://wpeden.com/tipsntuts/moving-wordpress-to-new-locationserver-from-an-old-locationserver/

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)