{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/959","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/959/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/959/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/959/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/959","id":205870746,"number":959,"title":"Export/Import problem","user":{"login":"Phil1988","id":6054234,"avatar_url":"https://avatars.githubusercontent.com/u/6054234?v=3","gravatar_id":"","url":"https://api.github.com/users/Phil1988","html_url":"https://github.com/Phil1988","followers_url":"https://api.github.com/users/Phil1988/followers","following_url":"https://api.github.com/users/Phil1988/following{/other_user}","gists_url":"https://api.github.com/users/Phil1988/gists{/gist_id}","starred_url":"https://api.github.com/users/Phil1988/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Phil1988/subscriptions","organizations_url":"https://api.github.com/users/Phil1988/orgs","repos_url":"https://api.github.com/users/Phil1988/repos","events_url":"https://api.github.com/users/Phil1988/events{/privacy}","received_events_url":"https://api.github.com/users/Phil1988/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2017-02-07T12:18:34Z","updated_at":"2017-02-11T17:19:42Z","closed_at":null,"body":"### Details for the issue\r\n\r\nI have 2 Databases as *.db file that I want to merge.\r\n\r\nOn the first Database I use the export function (as SQL file instead of CSV) and export all tables I want, with NO \"INSERT INTO\" and NO \"Multiple VALUES\" seleced.\r\nIn the dropdown I chose \"only data export\" and export it.\r\n\r\nIn the 2nd Database I try to import as SQL file and it runs without any messages/hints/problems.\r\nAfter the process is completed, there is only a small part in the new Database.\r\n\r\nFor example there is one column with an ID that has 2943 entrys.\r\nAfter the import is \"done\" it has 507 entrys.\r\nSo somehow there are a lot of entrys lost during the export/import process.\r\n\r\nI hope you guys can give me hints what I can try to get this working or if there are any knows issues and ways around it.\r\n\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [x] DB4S has a bug\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x] Windows: 7 x64\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [x] 3.9.1\r\n\r\n#### I have also:\r\n\r\n- [ ]  Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows\r\n- [x] Tried out the latest portable version: https://github.com/sqlitebrowser/sqlitebrowser#windows\r\n- [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/279161009","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/959#issuecomment-279161009","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/959","id":279161009,"user":{"login":"schdub","id":1304776,"avatar_url":"https://avatars.githubusercontent.com/u/1304776?v=3","gravatar_id":"","url":"https://api.github.com/users/schdub","html_url":"https://github.com/schdub","followers_url":"https://api.github.com/users/schdub/followers","following_url":"https://api.github.com/users/schdub/following{/other_user}","gists_url":"https://api.github.com/users/schdub/gists{/gist_id}","starred_url":"https://api.github.com/users/schdub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schdub/subscriptions","organizations_url":"https://api.github.com/users/schdub/orgs","repos_url":"https://api.github.com/users/schdub/repos","events_url":"https://api.github.com/users/schdub/events{/privacy}","received_events_url":"https://api.github.com/users/schdub/received_events","type":"User","site_admin":false},"created_at":"2017-02-11T17:19:42Z","updated_at":"2017-02-11T17:19:42Z","body":"Is data lost in any of these tables:\r\n\r\nmessages_fts\r\nmessages_fts_segments\r\nmessages_fts_segdir\r\nmessages_fts_content\r\n\r\n?\r\n\r\nIf yes. My guess, this is because you can't merge FTS 'Shadow Tables' without understanding how full-text search is implemented.\r\nIf no. Could you please research which tables is losing data."}}
{"actor":{"display_login":"schdub"}}