Upgrading MT to MYSQL

Micah and I have been dealing with the nastyness of MT trying to bring this up to a MYSQL backend so that it can be moved to another server. Here's some tips:

1) Make sure that you've got the latest DB schema in your schemas directory
2) If you encouter the following error while running the mt-db2mysql.cgi, if you're getting this error:

Column 'entry_author_id' cannot be null

Go into MT (after setting it back to use the Berkley DB) edit any entry, and replace the entry ID in the URL with the entry that it failed the import on. I had several of these.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote> <pre>
  • Lines and paragraphs break automatically.

More information about formatting options