TweezerMan

Try uploading the file I attached in my last post with Internet Explorer and see if MT will import your posts. Don't worry about the ASCII/BINARY thing for this one file. You really should have an FTP program - it comes in handy for a number of things when working with files on the server. Take a look at TCH's FTP page on the TCH Help web site.

You can't use CPanel to literally copy a cron job from one site to another, but cron jobs do have to be set up in CPanel. What you'd need to do is make a note of the cron job settings in the first site's CPanel, then go into the second site's CPanel and set up a new cron job with those settings.

Try going to the "Weblog Config" page, make sure the settings for Local Site Path, Site URL, Local Archive Path, and Archive URL are correct, then click the "Save Changes" button at the bottom of the page (even if you don't change anything on the page). Then try to rebuild your site again.

The "Current working directory" displayed by mt-check.cgi should give you a good idea of what the Local Site Path should be. I haven't encountered any TCH servers with paths that start with "/home3" - they all start with just "/home". If you want your MT weblog to be built at the root of your domain, yes, you'd set the Local Site Path to "/home/cpanelName/public_html". While you're on that page (Weblog Config), you should set all of the settings on that page at the same time - Local Site Path, Site URL, Local Archive Path, and Archive URL.

I'm not sure what you mean by "went to the FTP site". What you need to do is use an FTP program to transfer the file from your computer to the server. In most every FTP program, there is an option for setting the transfer mode to the server to either "ASCII" or "BINARY" mode (and this file needs to be uploaded to the server in "ASCII" mode). Attached to this post is a copy of your file that already has the line endings converted from Windows format to Linux format. I don't know how you're uploading the file from your computer to the server, so this may or may not work, but you can give it a try anyway. julesofwisdom1.blogspot.txt

It sounds like the CGIPath setting in the mt.cfg file isn't quite right. It should look like this: >CGIPath http://67.15.16.5/~cpanelName/mt/ Be sure the CGIPath has a trailing slash on the end of it.

Welcome to the forums, Paul!

Welcome to the TCH family and forums, JM!

In your script, the hostname can be specified as 'domain1.com' - I don't see any problems with this. Granting permission for the script to access the MySQL server at domain1.com - If 'domain2.com' does not work in "Access Hosts", I'd suggest trying one of the following: 1) %.domain2.com 2) serverXX.totalchoicehosting.com (where "XX" is your domain2.com server number) 3) IP address of domain2.com server You should be getting an error message in your script indicating what hostname your script is using to connect with. That host name has to match what is in the "Access Hosts" list on the domain1.com server if you're not specifying the "Access Host" by IP address. In addition, you should make sure you are trying to access the MySQL with correct database name, username, and password, The database name and username should be specified as 'cpanelName_database' and 'cpanelName_username' in your script. Hope this helps...

The page is trying to open "/mt/mt.cgi/mt-upgrade.cgi" - both "mt.cgi" and "mt-upgrade.cgi" appear in the URL. In your mt-config.cgi file, is 'mt.cgi' appended to the end of the CGIPath URL? Your CGIPath setting should look like the following, with no 'mt.cgi' at the end: >CGIPath http://my-TCH-domain.com/mt/

Welcome to the forums, awstewar!

It sounds like you need to go into CPanel / MySQL Databases and add your computer's IP address under "Access Hosts" (near the bottom of the page) to grant your PC permission to access the MySQL server.

Assuming the two domains are on different servers, you would need to go into your CPanel / MySQL Databases page for the first domain and authorize access from the second domain's server by adding it under "Access Hosts" (near the bottom of the page).

The file itself now appears okay to me, but the line endings are still in Windows format, not Linux format. When you upload the file to the server, make sure that it is uploaded to the server in ASCII mode and not BINARY mode. You need to use FTP to transfer the file and not CPanel's File Manager, as the CPanel File Manager will not convert the file's line ending format for you. I dropped the export file in a test install of MT 3.2 I have that is running on Windows, and MT was able to read it and import all of the entries and comments successfully. I think the line ending format issue is the only one remaining for you.

Can we see what the latest version of your export file looks like?

Your file has the page as it is. Step 5 (the Blog Filename) should be located under Settings / Publishing. I can't explain why you have only 2 date/time formats, but your export file has the correct date format, so that doesn't appear to be an issue here. Considering the size of your file, it would take a *long* time of manual, tedious editing. It appears that you are still using "View Page" to see the export file in your browser instead of publishing it. Assuming this is true, before saving the file, you would need to do a "View Source" of that page, then save *that* as your export file. On my Blogger account, Blogger is adding 2 lines of HTML code at the beginning of the output page, and 1 line of HTML at the end of the output page, and these lines would need to be removed from your export file.

Publish your Blogger weblog using the Blogger export template. I'm not sure what that means - all of the steps listed in my post are done on your Blogger account.

- The import file has Windows-style line endings instead of Linux style line endings, which will prevent the server from reading where each line ends correctly. Usually, this occurs because the file was not uploaded to the server in ASCII mode. - The file has a number of format problems. This is the first line in the import file: 1) The "BlogThis!" should not be present at all. 2) Each field of an entry is supposed to begin on a new line. 3) BODY text needs to end with '-----' (5 dashes, without the quotes). 4) Each entry is supposed to end with '--------' (8 dashes, without the quotes). 5) The import file has been line-wrapped at 80 characters. This should not be done on a file you intend to import into MT. An entry should actually appear like this in the import file: I'm not sure what you're using for a Blogger export template or how you're performing it - you might want to check out my forum post here and see how it compares with what you're doing.

It looks to me what you'd need is an intermediate (third) table (I'll call it 'cast') that would actually store the relationship between the movie and actor tables - which actors were actually in what movies. The cast table could have just three columns - its own ID column, and columns for movieID and actorID. A separate record is created in the cast table for each actor who was in a movie. movie table: >id title 1 Batman Begins actor table: >id name 1 Christian Bale 2 Liam Neeson 3 Katie Holmes 4 Gary Oldman 5 Morgan Freeman 6 Michael Caine cast table: >id movieID actorID 1 1 1 2 1 2 3 1 3 4 1 4 5 1 5 6 1 6 Here's an example of a MySQL query that returns the list of actors in a particular movie, starting with the movie table and going through the cast table to retrieve the appropriate records in the actor table: >SELECT actor.name AS Actors FROM movie JOIN cast ON movie.id = cast.movieID JOIN actor ON cast.actorID = actor.id WHERE movie.title = 'Batman Returns' The query yields this result: >Actors Christian Bale Liam Neeson Katie Holmes Gary Oldman Morgan Freeman Michael Caine Using this table setup, you can also run queries which return a list of movies that a particular actor was in. Hope this helps...

Welcome to the forums, ictus!

Welcome to the forums, Jules! The only thing the "import successful" message indicates is that the import script made it to the end without crashing. It does not indicate whether any entries were imported successfully. Usually, if no entries are being imported, there is a problem with the import file. If you can put a copy of the import file somewhere on your site and post a link to it, I can look at it and tell you what's wrong with it.

Welcome to the forums, Secret Agent Man!

Welcome to the forums, dchaffey! Assuming you're running the shopping cart on a TCH-hosted account, the proper value for $servername is "localhost".

Welcome to the forums, thebigtimer!

Welcome to the forums, Ana!