NAVIGATION
Differences
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 109: | Line 109: | ||
| 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**. \\ | 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. | 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|}} | ||
| + | |||
| + | |||
| + | |||
