wordmove: Invalid byte sequence in UTF-8 on db synchronize

Hi, i have take old wordpress site, and i want sync it on my localhost.

Files are correctly synchronized, but when push (or pull) db, terminal write “adapt dump /Users/luca/.rvm/gems/ruby-2.0.0-p247/gems/wordmove-1.1.0/lib/wordmove/sql_adapter.rb:44:in `gsub!': invalid byte sequence in UTF-8 (ArgumentError)” and view a lot of error.

with other site from this remote server and on this localhost, wordmove work properly

an you help me?

About this issue

Original URL
State: closed
Created 10 years ago
Comments: 17 (6 by maintainers)

Most upvoted comments

@eivindml you have to put exclusions in both local and production sections 😃

alessandro-fazzi on Feb 13, 2017

if you don’t want to uninstall the Wordfence plugin, but don’t need to wordmove the Wordfence config / database tables, try adding this to the Movefile (nested under environment -> database):

mysqldump_options: "--ignore-table=DATABASENAME.wp_wfVulnScanners --ignore-table=DATABASENAME.wp_wfThrottleLog --ignore-table=DATABASENAME.wp_wfStatus --ignore-table=DATABASENAME.wp_wfSNIPCache --ignore-table=DATABASENAME.wp_wfScanners --ignore-table=DATABASENAME.wp_wfReverseCache --ignore-table=DATABASENAME.wp_wfNet404s --ignore-table=DATABASENAME.wp_wfLogins --ignore-table=DATABASENAME.wp_wfLocs --ignore-table=DATABASENAME.wp_wfLockedOut --ignore-table=DATABASENAME.wp_wfLeechers --ignore-table=DATABASENAME.wp_wfKnownFileList --ignore-table=DATABASENAME.wp_wfIssues --ignore-table=DATABASENAME.wp_wfHoover --ignore-table=DATABASENAME.wp_wfHits --ignore-table=DATABASENAME.wp_wfFileMods --ignore-table=DATABASENAME.wp_wfCrawlers --ignore-table=DATABASENAME.wp_wfConfig --ignore-table=DATABASENAME.wp_wfBlocksAdv --ignore-table=DATABASENAME.wp_wfBlocks --ignore-table=DATABASENAME.wp_wfBlockedIPLog --ignore-table=DATABASENAME.wp_wfBadLeechers"

It’s not pretty, and might break if Worfence adds new tables, but it works for now. Hopefully Wordfence will fix their tables, I told them about this issue here: https://wordpress.org/support/topic/different-collations-after-installation/#post-8742910

ul8 on Feb 6, 2017