user-pic

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

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012