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
  • No labels

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.