Run backupwordpress on Linux server
Download .sql file to local Windows machine
Import .sql file into local database
Text widgets missing in imported site.
backupwordpress doesn't export strings with escape characters
so some of the serialised strings get corrupted when importing in a Windows environment.
The following example produces the correct results
but you get the incorrect results when the characters are not escaped.
Notes: backwpup did not exhibit the same problems.
PS. I noticed another problem
Timestamps would not import. ERROR 1064 (42000)
They were missing single quotes.