WordPress character set issue

To move a site from localhost i usually do the following:

1, Install adminer plugin on your localhost (lets you download the database file)

2, Use an FTP to upload all files

3, Change the php config files details to work on host

4, Open the mysql file saved from Adminer and then edit the wp_options section change both “siteurl” & “home” to point to your url for site.

5, Go to your url and then run the install of wordpress and after this activate Adminer then just import the admirer file you download or if you know mysql import the file from the mysql panel on your hosts cpanel.

6, You should now be able to see the wordless site but the last thing you will need to do is go to settings -> permalinks and change them to “plain” then back to “post name” and you can view the sites sub pages correctly as this recreates the .htacccess file.

Related Posts:

  1. WordPress Database Huge wp_usermeta Table
  2. How to migrate a database from a server to another
  3. DB prefix not updating
  4. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  5. How to retrieve user data based on role using SQL?
  6. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  7. Deleting WordPress posts and media files based on author via MYSQL database
  8. Database table prefix different between wp-config.php and in database
  9. What is “Advanced” SQL?
  10. Oracle SQL query for Date format
  11. WPDB Insert or if exists Update
  12. Please explain how WordPress works with MySQL character set and collation at a low level
  13. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  14. Where are image paths to product category images stored in WordPress database
  15. Special characters in WordPress UTF-8 [closed]
  16. Sharing database for collaborative development
  17. Display data from a non wordpress database on a page template
  18. Organizing WP Pages based on old website database
  19. Inserting Post Meta From SQL
  20. Bulk Update of Custom Post Type Post Status through SQL
  21. How do I add indexes to WordPress Database?
  22. Moving an entire wordpress site from one domain to a new domain and database
  23. Change SQL get_results to search for posts with custom term in custom taxonomy
  24. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  25. Delete all post meta except featured image
  26. Custom DB_COLLATE (collation) value not working on fresh install?
  27. Block search SQL from happening
  28. wpdb query on custom table not working [closed]
  29. How to execute mulitple statement SQL queries using $wpdb->query?
  30. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  31. Database with mixed collation (utf8mb4 & utf8_general_ci)
  32. Query WordPress database by registered date and role
  33. Using table lock with wp_insert_post?
  34. How to Move Local Singlesite Database to Remote Multsite Database?
  35. Scheduling posts in database
  36. Set Display Name to first and last name (phpmyadmin SQL Query)
  37. Size article thumbnails and retrieve them directly from database
  38. Emojis getting converted to “?”
  39. How to replace values in WordPress DB using phpMyAdmin
  40. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  41. Delete all post meta except featured image Using SQL
  42. Search and replace special characters (å,ä,ö) for image attachments only in database
  43. wpdb_prepare with multiple or condition
  44. Accidentally deleted active_plugins portion of the wp_options DB table
  45. Uppercase to sentence case for post titles
  46. SQL Error wp_commentmeta – incorrect table definition
  47. phpMyAdmin displays error when importing database
  48. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  49. How do I get the posts within a certain year/date(with sql query)?
  50. WordPress database import: Row size too large
  51. Export / import WordPress database
  52. WordPress is not creating table in database after activating plugin,
  53. Bulk-create posts from SQL database
  54. Difficulty importing my live site to local
  55. Create table from array with prepare
  56. Setup private content for specific users with daily updates [closed]
  57. Connection refused on locahost after importing database?
  58. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  59. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  60. Insert Query not working in the form
  61. WPDB SQL query with prepare() returning variable, not db value
  62. Problems with moving my WordPress site to another domain/server
  63. Changing root password in PHPMyAdmin for WordPress Database when going live
  64. Can’t update WordFence Options, clear data manually
  65. Post Views / Hit Counter Problem?
  66. Why this query is not showing any result on wordpresss home page?
  67. Is it possible to have more than 1 MySQL database in my WordPress blog?
  68. pull data from a remote wordpress database
  69. Clear Terms from Taxonomy for Specific Post IDs?
  70. Is my way to change WordPress server is correct?
  71. Why does changing Database Table Prefixes result in loss of content?
  72. Options on how to Display member specific data from a MS SQL database
  73. Delete/Replace words from X to Y in post content
  74. SQL query to set posts in bulk based on the post content
  75. How to delete a particular row in a database table
  76. Delete all posts that do NOT have a specific tag
  77. Location of WP default mySQL tables creation file?
  78. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  79. Files on Localhost, Database on Server
  80. Backing up WordPress database and files
  81. $wpdb->get_var – What value is returned when zero records are found?
  82. How to display data from db in select list [closed]
  83. wp_option table error while importing
  84. Installing local to live WP into subdirectory
  85. WordPress SQL – How to Check for Category?
  86. Getting value from database table depending on field value
  87. Delete user with only subscriber role
  88. custom tables in wordpress Database? (can i just create them with sql?)
  89. Search Character Set Problem
  90. Can’t log into wordpress site – I have made a new user and still cant access
  91. Is there any way to monitor a MySQL db and check what has changed?
  92. Accidently changed the GUID
  93. Deleting empty meta key values
  94. Sql query to get all metadata for a post
  95. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  96. Job and Employee Performance Tracking with Product Safety
  97. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  98. Is there any defects for using same database prefix in WordPress for multiple sites?
  99. Migrating meta_key and meta_value from old theme to new one
  100. SQL database import #1046 error
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)