Migrating from MySQL to SQLite3 causes post id changed

Developer help Migrations
1

I’m going to migrating my ghost instance from MySQL to SQLite3 , so I just export json data from old instance , start up a new instance ,and then import that json data into the new one .

It all seems ok , until i found all links for my posts were changed … My permalink config is : permalink: /post/{id}/ . It makes all my old links invalid …

So can I just migrate my data from MySQL to SQLite3 without any changes to my post id ?

Thanks a lot.

2

Alright , I have fixed it by writing some scripts to manual change new post id to old post id in database.

Related tables are : posts posts_authors posts_tags and posts_meta …