Migrating from 7LOG to movable Type

Source: Internet
Author: User
Tags date insert modify sort movable type

I've had a lot of trouble with modifying the 7LOG program recently. The code change is not very good modification, and the author seems to be also suppressed to find traces, disappeared, and even its homepage have been killed, watching the need to add more and more trouble, really want to go to another blog program movable type.

There are many reasons why you should migrate to movable Type. One, MT is the world's most used blog, rich in resources. Second, the MT is a static file, consuming less system resources, the server load is small. Third, although word Press also has permalink emulation static files, but does not reduce the system load, and in the IIS environment can not use the rewrite function, and not all hosts are open rewrite features.

From 7LOG you can migrate smoothly to the movable Type 3.17 version, and you can guarantee the continuity of the URL. Of course, the default configuration of movable type is not complete, first modify Lib/mt/util. PM File 684 lines, the "%06d" removed, modify 745 rows of "cat" can change the directory name. Use Old-style Archive Links and then publish again to see if the file name and address are the same as the 7LOG. Exclamation: The code of movable type is really very robust, and maintainability is very good.

The following is a SQL statement that converts from 7LOG to movable type:

--Import Articles

INSERT into Mt_entry (entry_id, ntry_blog_id, Entry_status, entry_author_id, entry_allow_comments, Entry_allow_pings, Entry_convert_breaks, entry_category_id, Entry_title, Entry_excerpt, Entry_text, Entry_text_more, Entry_to_ping_urls , Entry_pinged_urls, Entry_keywords, Entry_tangent_cache, entry_created_on, entry_modified_on, entry_created_by, entry_modified_by, entry_basename) Select ID, ' 1 ', ' 2 ', ' 1 ', ' 1 ', ' 0 ', ' __default__ ', Sort,title, ', Resume,content,null, NULL, null,null, date, ' 20050622034340 ', NULL, null,id from Blog_topic order by ID

--Import Directory Index

INSERT into Mt_placement (placement_entry_id, placement_blog_id, placement_category_id, placement_is_primary) Select ID, ' 1 ', sort, ' 1 ' from Blog_topic ORDER by ID

--Import comments

INSERT into Mt_comment (comment_id, comment_blog_id, comment_entry_id, Comment_ip, Comment_author, Comment_email, Comment_url, comment_commenter_id, comment_visible, Comment_text, comment_created_on, comment_modified_on, Comment_ created_by, comment_modified_by) Select ID, ' 1 ', topic_id, IP, author, email, ', ', ' 1 ', content, date, ' 20050622061716 ' , NULL, NULL from Blog_comment ORDER by ID

The final release of the font in the Chinese environment is not very good-looking, you can modify the Styles-site.css file, the Font-size:x-small modified to font-size:12px.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.