History: Import-Export

            {syntax type="markdown"  editor="wysiwyg"} # Import and Export


Use this page to link to topics regarding importing & exporting data and content to Tiki. You might also want to read about the ((MediaWiki Importer)) or the ((WordPress Importer)).

## Databases

You can import and export databases by means of PhpMyAdmin.

In addition, you can export a database from the command line with something like: 
{CODE()}
mysqldump -u mysqluser -p db > file.sql 
{CODE}

And import it to a new server with a similar command in the new server (provided you ftp upload the file to your new server): 
{CODE()}
mysql -u mysqluser -p -f db < file.sql 
{CODE}

where mysqluser stands for your mysql username,

- -p with no passwod will imply that the mysql server will request you the password as hidden input in the next line after you hit enter in the command above
- -f indicates that you want to force the mysql to continue even if it finds that some mysql column already exists, etc.
- db stands for the database name
- file.sql stands for the sql filename.


See also:

- ((Import database))
- ((Backup))

## Profiles

Profiles are designed to help configure Tiki sites. But since they can create data (typically for sample data), they can be used to import various data types. Notably: ((Article)), ((Blog)), ((Category)), ((Menu)), ((Tracker)) and ((Wiki)) 
More details at: 
http://profiles.tiki.org/handlers

Also:

- ((profiles:Save current configuration as a profile))
- ((Export trackers))
- ((Import Trackers))

## Wiki

((XML Wiki Import-Export))

[Batch upload wiki pages from CSV|http://tikiwiki.cvs.sourceforge.net/tikiwiki/_mods/goodies/batch_load_pages/]

See also tiki-admin.php?page=wiki

- Import HTML
- Import pages

## Quiz

((Quiz Question Import))

## Image Gallery

see tiki-batch_upload.php 
"Directory Batch Loading" must be activated here: tiki-admin.php?page=gal

## File Gallery

see tiki-batch_upload_files.php 
Must be activated in admin panel

## Trackers

See ((Tracker Import Export)), ((Export trackers)) &amp; ((Import Trackers)).

### Trackers definition

tiki-admin_trackers.php

See also ((Export trackers)) and ((Import Trackers))

### Tracker data

tiki-admin_trackers.php?trackerId=1 (replace 1 with your tracker ID)

See also ((Export trackers)) &amp; ((Import Trackers))

## Forums

doc/devtools/tiki_forum_migration.php

## Articles

New in 1.10.

## Users

See [http://doc.tiki.org/tiki-index.php?page=Users%20Management#Adding_new_users_in_bulk|Users Management]

## Categories

import from .csv at tiki-admin_categories.php (version 3.0)

## Screen Scraper

Via ((Browser Automation))

## Importing from non-Tiki software.


((Migrate to TikiWiki))

((MediaWiki to TikiWiki))

((Confluence Importer))

((Mod import-phpwiki|Import from PHPwiki))

((Try to convert HTML to wiki))

((Non-Tikiwiki conversion tools))

E.g., [http://www.google.com/search?q=html2wiki&amp;sourceid=navclient-ff&amp;ie=UTF-8&amp;rlz=1B3GGGL_enUS223US224|html2wiki tools], MediaWiki conversion import tools.

# Related Features

- ((Communication Center)) to send and receive wiki pages and articles between Tiki instances
- ((Mail-in))
- ((Interoperability)) with the outside World
- ((Web Services)) coming to 3.0!
- ((Import database)) import complete Tiki database

# Related topics

- ((Backup))
- [http://en.wikipedia.org/wiki/Comma-separated_values|.csv is a file format]



{DIV(class=titlebar)}alias names for this page{DIV}


(alias(Import)) | (alias(Export)) | (alias(Import and Export))



{DIV(class=titlebar)}sister pages{DIV}


dev:((dev:Import-Export))