Moving Mysql Database To Tch

[Oneida]

Well, I took the plunge today and signed up for a TCH gold account. Gosh, they were fast - I could access the new site in less than an hour!

 

I got Movable Type installed and running pretty quickly, but I've run into a problem moving the MySQL database to TCH from the previous host. I used phpMyAdmin at the old site to create a gz dump, then used the cPanel backup/restore function to upload and restore it to the database at TCH. But it's quitting after creating the first table (mt_authors) and not putting any of the data into the table. I also tried creating separate dumps for each table, but the same problem happens with those, too - I get the TABLE CREATED message that lists all the fields, but none of the data gets inserted.

 

I noticed in one of the forum postings that another person was also having problems migrating their database to TCH and TCH said they could do it if the old site also used cPanel. Unfortunately, my old site uses PlusMail (a dinosaur compared to cPanel).

 

I'm wondering if there is some type of incompatibility between how phpMyAdmin and cPanel do MySql gz dumps? Do I need to delete the MT tables and let cPanel's restore function recreate them? Or is there some other way to move the database? (I know MT has an import/export function, but it doesn't preserve the entry ID, which totally messes up links to other entries and would be an awful mess to straighten out.)

 

Aside from that, everythings been fun so far at TCH.

 

Thanks,

Oneida

[TCH-Dick]

Did you try using phpmyadmin in cpanel to restore your backup? It is at the bottom, scroll down and it is the last section in cpanel.

[TCH-Rick]

I don't know how big your database is but if it is very large you should ftp the .sql file into your root directory and submit a Help Desk ticket asking that we import the data into your database. Just be sure to include the database name, username, and password along with the name of the sql file you have used.

[Oneida]

Did you try using phpmyadmin in cpanel to restore your backup? It is at the bottom, scroll down and it is the last section in cpanel.

Yes, I found phpMyAdmin right off the bat. The problem was that I really shouldn't try to do stuff like this at 3 in the morning. Last night when I was thinking about using phpMyAdmin to move the sql dump into the database at TCH, all I could think of is that I would have write a complicated INSERT script to do it. But your response triggered some clearer thinking now that I've had some sleep, so I tried having phpMyAdmin run the sql dump as a query and it worked like a charm. Thanks!!

 

Oneida

[TCH-Don]

Welcome Oneida to the family

 

and your new home

 

glad you got your database moved ok Thumbs Up