Loading...
 
Skip to main content

Custom Share Module 0.1dev

Tiki SQL FAQ

SQL is the backbone of Tiki. These FAQs should help you get a handle on the SQL core command line.
List FAQs
Print

Questions

  1. How do I dump MySQL database?
  2. How do I load an SQL file into mySQL?

Answers

Question: How do I dump MySQL database?
Answer: 

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.

Question: How do I load an SQL file into mySQL?
Answer: 

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.