Planned website maintenance Friday February 12, 2016 15:00 UTC through Friday February 12, 2016 22:00 UTC. No login or forums participation will be available during this time. Read more…

Microsoft WebMatrix: Database errors while publishing and downloading sites

By Bilal Aslam

January 9, 2011

Introduction

Microsoft WebMatrix includes the ability to transfer your site's database to and from a remote server. This article contains tips for when you encouter errors during a database transfer.

Tips

Check that the username and password in the database connection string in Publish Settings is correct. Click 'Validate Connection' to verify that WebMatrix can connect to the database.

If you are transferring a MySQL database, ensure that MySQL has default collation of UTF-8. WebMatrix automatically sets this collation if it installs MySQL. Further reading: http://dev.mysql.com/doc/refman/5.0/en/charset-server.html

If you are still stuck, we recommending posting a question on the WebMatrix Forum.