Tiki SQL FAQ

The phpMyAdmin way :
Select your Tiki DB, click the Export tab, select all tables (with the link to do so), and export it. There may be a few other things to check, so test that you can import the DB before trusting it. Feel free to complete these explanations.

The command line way :
To dump the DB use
{CODE()]mysqldump -u tiki -p tikidb > tikidump.sql{CODE}
where tiki is the username to connect to DB, tikidb is the name of the database holding tiki tables,
tikidump.sql is a text file with everything to recreate the DB.
You are then prompted for a password, use Tiki user DB password.
You don't have to be root.

to restore a dumped db
mysql -u tiki -p tikidb < tikidump.sql
where
tiki is the username to connect to db
tikidb is the name of the database holding tiki tables
tikidump.sql is a text file with everything to recreate the db
(you are them prompted for a password, use tiki user db password)

You don't have to be at root.