This documentation relates to an early version of Confluence.
View this page in the current documentation or visit the current documentation home.

How to run a SQL script on your database

All Versions
Click for all versions
Confluence 2.6 Documentation

Index

This document contains some basic instructions on how to run a SQL script on your database. This document is not intended to be exhaustive of the databases we support. We still recommend that you ask your DBA to perform this task if possible.

The following examples assume a database name of yourdb and a script file called myscript.sql. Of course, the extension of the SQL script file does not have to be .sql. Any file can be used so long as it contains SQL statements.

MySQL

mysql yourdb < myscript.sql

PostgreSQL

psql yourdb < myscrpt.sql
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.