mt-db-convert.cgi: MT Database Converter
A CGI script for converting Movable Type Database between DB engines.
- Initial release.
- Bug fix for using BerkeleyDB.
This script allows you to mutually convert Movable Type Data between BerkeleyDB, MySQL, PostgreSQL, and SQLite. When you want to move your database from MySQL to SQLite, or move from a testing environment to a production, this script can help you.
This script is a kind of a derived work of Six Apart's mt-db2sql.cgi. So I may cease publishing this article and this script anytime as requested.
INSTALLATION
To install this script, upload or copy "mt-db-convert.cgi" into your Movable Type directory and set the permission of the script to 0755 (be executable).
To use it, just acccess it with your Web browser. (I have to write more)
After running this script, I strongly recommend to delete it, because it becomes a security hole of your MT. I mean anybody else could access it and read your DB configuration.
NOTE
- This script is compatible with Movable Type version 3.1x. I didn't test it at any other versions.
- This script may be stopped publishing anytime at Six Apart's request.
Comments
Hi
Thanks for the script, but I can't get it to work. I am trying to convert my Berkeley DB to MySQL. It just goes back to the starting page when I click convert. I am filling out the source (actually this comes filled out) and selecting Berkeley DB on the left box, on the right I select MySQL and fill out the db name, login, server and password. I can't figure out what I am doing wrong...
thanks
Leo
Posted by: lf777 | July 18, 2005 10:53 AM
Leo, thank you for telling me about this problem. Now I fixed it and released version 0.12. Please download it again, and try it.
Posted by: (o) | July 18, 2005 06:15 PM