Database back-up and restore - tips wanted!

[beeELLEcee]

Hello,

I only purchased eSyndicat yesterday and while waiting for payment to be cleared etc (so I can get to work!) I thought I'd introduce myself and have a hunt around the forum. Seems there is lots of really useful info here!

I am quite new to the 'directory' business (though not to web design etc) and something I would like to get to understand in advance is how best to back-up and restore the eSyndicat database in the event of a worst case scenario server crash or something.

Could anyone suggest a robust back-up plan, or what works for them? DO people rely on the eSyndicat back-up function or do they prefer manual database back-up and restore?

All thoughts and ideas welcome!

Many thank,

Beth

[Dave Baker]

Welcome to our forum beeELLEcee!
Go to Admin Panel » Manage Database » Export
Export: "Select All".
MySQL Options:
Structure: if you need the structure of database tables mark it (if you will use your backup with an empty database).
Add DROP TABLE: mark it if you will use your backup with a database in which were created the tables of directory. The tables will be recreated.
Data: mark it if you want to include data from your tables
Complete Inserts: in queries will be included field names.
Use real tables prefix: Your dump will use your tables prefix specified at installation process
Importing data you can make via Admin Panel » Manage Database » Import or via phpMyadmin