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
Labels:
1 Comment
Hide/Show CommentsApr 25, 2008
Preston Tollinger
For mysql I recommend adding the --force option so it doesn't fail if some but not all of the indexes exist.
Add Comment