My blog was still running MT 2.661. I used Cpanel's backup wizard to save the blog database. When I unzipped it, its filename is mt.sql

I have gotten a new domain and have installed MT 4.1 open source. Created a new blog (FitNotes.net) and started blogging; created a separate new blog (FitNotes, the Prequel) to hold the import of the old blog.

Imported mt.sql using the MT interface, into the prequel blog. MT said all data was successfully imported, but there is nothing. From another thread here, I understand that MT requires *.txt file in the Unix LF format.

How can I convert my backed-up MySQL database to something MT 4 will import and read?

Thanks.

Fran

You have several issues to deal with.

First, you are trying to use MT to import a file that MT didn't generate. What you have is an SQL dump, *not* an MT import file. That's why you don't get anything. You need to use whatever MySQL interface your host provides (phpMyAdmin, cPanel, whatever) to import the file into your prequel DB.

Second, you have an SQL dump of an MT database that is 2 generations old, and trying to import it into a new database generated by MT 4.x. Since there have been a bunch of changes in the DB schema between MT 2.6x and MT 4.x, there's no guarantee that the import will work 100%.

if you still have your old MT blog around, use it to create an export file. The you should be able to use your MT 4.x to import that file into your blog.

I had no idea there was something in MT that would have exported my old blog. I don't have the old blog any more.

I created my prequel blog by going into my main blog's dashboard and using Create New Blog. cPanel still shows only one MySQL database (the one I had created for the main blog). Do multiple blogs created in this way typically share one DB? Is there a way in MT to point the prequel blog to a separate DB if I create a new one for it now? (I know how to create a new DB but not sure how I'd point the blog to it.)

Maybe if I can do that, I can try your suggestion of using PHPadmin to import my SQL dump into it and see what happens then. Thank you.

Each MT installation uses a single database. Blogs created by MT are identified by a unique blog_id, but they're all stored in the same database.

Here's a somewhat laborious procedure you can try but with no guarantees of success

*Create a new database and use phpMyAdmin (or whatever tool you have) to import the SQL dump
*Download and install a copy of MT 3.36 and configure it to use the database you just created
*Navigate to mt.cgi and let the upgrade process run
*Once the upgrade is finished, use MT to create an import/export file
*Import this file into your MT4 installation

http://www.movabletype.org/documentation/u...nd-earlier.html
http://wiki.movabletype.org/Community_Gene...d_Upgrade_Guide