NAVIGATION
This shows you the differences between two versions of the page.
english:technics:database:phpwcms_guestbook:export-import-guestbook [2009/10/09 19:00] Knut Heermann (flip-flop) |
english:technics:database:phpwcms_guestbook:export-import-guestbook [2018/06/03 18:09] (current) |
||
---|---|---|---|
Line 7: | Line 7: | ||
If there is an empty table "phpwcms_guestbook" in your target db: | If there is an empty table "phpwcms_guestbook" in your target db: | ||
- | ===== First db: ===== | + | ===== Export from first db: ===== |
Export only the table "phpwcms_guestbook" and its data into a file | Export only the table "phpwcms_guestbook" and its data into a file | ||
- | {{:english:technics:database:phpwcms_guestbook:table_export01.png?860|}} | + | {{:english:technics:database:phpwcms_guestbook:table_export01.gif|}} |
\\ | \\ | ||
- | ==== Generated sql file ==== | + | ===== Generated sql file (example) ===== |
<code sql|h example |h> | <code sql|h example |h> | ||
Line 94: | Line 94: | ||
\\ | \\ | ||
- | ==== Second db (target) ==== | + | ===== Import into the second db (target) ===== |
Import this file into the target db | Import this file into the target db | ||
- | {{:english:technics:database:phpwcms_guestbook:table_import01.png?860|}} | + | {{:english:technics:database:phpwcms_guestbook:table_import01.gif|}} |
- | ==== Result ==== | + | ===== Result in target db ===== |
- | {{:english:technics:database:phpwcms_guestbook:table_browse03.png?860|}} | + | {{:english:technics:database:phpwcms_guestbook:table_browse03.jpg?860|}} |
Line 113: | Line 113: | ||
If in the db table column **guestbook_cid** more then one ID exist, you have more then one guestbook in several contentparts. | If in the db table column **guestbook_cid** more then one ID exist, you have more then one guestbook in several contentparts. | ||
</note> | </note> | ||
+ | |||
+ | |||
+ | |||
+ | ===== guestbook content part ===== | ||
+ | |||
+ | {{:english:technics:database:phpwcms_guestbook:guestbook_cp01.gif|}} | ||
+ | |||
+ | |||
+ |