NAVIGATION
This shows you the differences between two versions of the page.
english:technics:database:phpwcms_guestbook:export-import-guestbook [2009/10/09 18:31] 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|}} |
<note> | <note> | ||
**guestbook cp:** \\ | **guestbook cp:** \\ | ||
- | You find the associated alias-ID of a guestbook in the db table column guestbook_cid. | + | You find the associated **alias-ID** of a guestbook in the db table column **guestbook_cid**. |
+ | |||
+ | \\ | ||
+ | The **alias-I**D in your guestbook cp must be the same like the ID in the db table column **guestbook_cid**. \\ | ||
+ | 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|}} | ||
+ | |||
+ | |||
+ |