Backing Up Using phpMyAdmin

If your ISP has configured PHP to run in "safe mode" then the Opus backup facility won't work but if your ISP has provided phpMyAdmin you can backup your Opus database using that.

To do this go into phpMyAdmin and click on the name of the database at the top of the left frame. Then scroll down the right frame a bit until you reach "View dump (schema) of database". Select all the tables via the "Select All" hyperlink and tell it you want to backup both structure and data. Also select "Add 'drop table'" and "Save as file", then click on "Go" and it will send you a backup copy of your database as a file for you to save on your PC.

And finally, if you want to create a mirror of the database on your local Linux web server then simply log in as a user with access to the local MySQL server and type:

mysql database < backup_file_name