Moving To Tch

[salguod]

Howdy,

 

I'm in the process of movingmy MT 3.2 blog to TCH. My old host does not have cPanel, so I'm having to re-install. I've got MT installed in my TCH webspace and all my plugins installed as well. I plan on doing a MySQL dump from the old host and importing it here.

 

Question:

 

The fresh MT install created a default blog, which I haven't configured at all.

 

Should I delete it prior to importing the MySQL dump?

Will the import create a new blog in addition to it or will it transmortify the default blog into my blog?

Or will I make a mess?

 

Can I do the MySQL import (if so how) or should I leave that up to TCH (and if so, how)

 

Thanks,

[TCH-Bruce]

The import will only be your entries and comments. You will also need to download your templates and upload them into the MT you just created.

 

I'd also make sure you have a complete backup from your current host.

 

Upload your mysql dump to the TCH server and open a ticket with the help desk and ask them to import it into your new DB here.

[TweezerMan]

The MySQL dump file will contain everything stored in your old database, including the templates, so those don't need to be backed up separately.

 

Rather than delete the default weblog, what you need to do first is drop all of the existing tables in your MySQL database. This will delete everything that MT set up in the new database, including the default weblog. Then you can import the MySQL dump file from the database at your old host.

 

If you don't drop the tables before doing the import, the import would most likely abort when it tries to create tables that already exist.

 

You can drop a database's existing tables and import a MySQL dump file from phpMyAdmin, which is accessible from your CPanel. Click on the "MySQL Databases" icon/link, then click the "phpMyAdmin" link near the bottom of the page.

 

If you have more than one database set up, you'll need to select the MT database from the drop-down on the left. You should then see a list of the table names within the database.

 

To drop all of the tables, scroll down to just below the last table name and click the "Check all" link, then select "Drop" in the "With selected:" drop down.

 

To import your MySQL dump file, click the "SQL" tab at the top of the page, and where it says "Or Location of the text file:", click the "Browse" and locate the MySQL dump file on your computer, then click the "Go" button to upload it and import it.

 

If your MySQL dump is large, you may have problems importing it yourself with phpMyAdmin. In that case, you can upload your MySQL dump to your account with an FTP program, then open a ticket to the Help Desk and ask them to perform the import for you.

 

Hope this helps...

[TCH-Bruce]

Thanks David for clearing it up. It's been a while since I've used MT.

[salguod]

Thanks a lot. You guys have all been very helpful as I do this transfer.

 

One last question:

 

So I should do everything that David mentions up to the import prior to opning my support ticket. In other works, all support will do is the import. Right?

[TCH-Tim]

I think David is saying you should do the import yourself, but if it hangs, then open a ticket.

[TweezerMan]

I was just answering the questions that salguod initially asked:

Should I delete it prior to importing the MySQL dump?

The existing tables in the database need to be dropped before doing the import. It's possible that the dump itself contains commands to drop any existing tables, but it's usually best not to assume that it does. You can drop them from phpMyAdmin, or you can ask the Help Desk to drop them for you.

 

Can I do the MySQL import (if so how) or should I leave that up to TCH (and if so, how)

Yes, you can do both the dump and the import yourself, or you can have TCH do both for you. It's not really a matter of "should" - it's more what you're most comfortable with.

 

If you want the Help Desk to do it for you, you need to specify in your Help Desk ticket to drop all existing tables in your database before doing the import. Prior to submitting your Help Desk ticket, you'll need to upload your MySQL dump file to the TCH server and provide the file name and location in your ticket so the Help Desk tech can find it.

[salguod]

Thanks guys, I was able to import my database just fine. We'll see how the rebuilding goes ...