Creating a Database Backup
MySQL
MySQL 4.1/5.0
MySQL users should execute a command similar to the following to create a database dump:
The example above assumes that the database name is cascade.
SQL Server
SQL Server 2005
SQL Server users should follow the instructions below for creating a database dump in SQL Server Management Studio
- Right-click on the Cascade Server database
- Select Tasks -> Back Up...
- On the General page:
- For Backup Type, select Full
- Under the Destination section, make note of the path to which the database will be dumped
- Click OK
Oracle
Oracle 10g/11g
Oracle 10g/11g users should enter the following from a command prompt (or wherever exp can be executed):
Important: When creating a database dump be sure not to export using the system user.

