Confluence Docs 3.0 : How to run a SQL script on your database This page last changed on Jun 28, 2009 by ggaskell. 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 < myscript.sql

Document generated by Confluence on Nov 05, 2009 23:34