default userpic

Import from a .sql file

Vote 0 Votes

Hello to all.

In the Import appliance, there’s a support for a dump file from a postresql DB (with custom field names, but with a title and body)? I guess not, but maybe…

thanks

Luciano

Reported on Movable Type 4.2

5 Replies

| Add a Reply
  • Movable Type doesn't handle imports from raw SQL dumps. If you want to import from SQL, what you should do is load the SQL dump into a new PostgreSQL database, configure Movable Type to point to that for that moment, run the export command and reconfigure Movable Type to point to your original database so you can import the content back in.

    • Right. Ok, but the custom fields name can be a problem? Doesn't MT create its own fields and table to handle the data? What happen when it finds other model. Is there a mapping way?

      thanks

      • Rob has a good point. You'll have to tweak some of the ID fields to do a clean SQL merge. Familiarize yourself with all of the table layouts before you update everything.

  • The dump from the database should have the necessary CREATE TABLE commands that will include any additional columns created by the CF plugin.

  • Are you trying to merge or move an installation?

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

64 196

Last Topic: movable type 5 custom fields by kljx on Mar 17, 2010

1006 3225

Last Topic: When will MT v5.02 be Released? by Jim S. on Mar 18, 2010

483 1985

Last Topic: I have upgraded and I cant login! by Aleksandar on Mar 18, 2010

19 69

Last Topic: Custom main index page by Richard on Feb 7, 2010

11 22

Last Topic: Monthly Calendars Help Needed by joe leblanc on Jan 19, 2010

91 326

Last Topic: SpamLookup Keyword Filter 2.1 not work by b.n09 on Nov 17, 2009

55 206

Last Topic: URL Problems by NoSnaiL on Mar 17, 2010

code.sixapart.com

129 449

Last Topic: Action Stream for Google Buzz by jack lail on Feb 16, 2010