Backup of entire Database (including mails and other items)

[enjayworld]

Hi Everybody,

I am extremely sorry if I sound like a newbie, I may sound like that - because I am - a newbie.

firstly congratulations to all of you out there - for this fantastic product.

1. We have been using C.E. for past 6-8 weeks, and implemented, everything is fantastic.

2. We had used a normal P4 machine for the same. and OpenSuse as the server

3. Everything is fantastic, no problem, the system is working smooth.

4. But we need to move the CRM system to our existing server (Xeon dual proc, 2 g of ram, 200 g raid hdd)

5. However when i take complete backup of mysql database using phpmyadmin
the size of backup.sql (exported) file is very small - only 27 mb,

6. Where as we have lot of Emails included in our crm system.

My questions are as follows:

1. where is the email DATA stored ?
2. how do i back up the email Data.
3. How do I restore the data. Pl. correct me if the following procedure is incorrect.
>> install new server using bitrock installer.
>> after everything is up and running, just import the sql data using PHPMYADMIN.
4. in that case will the root user or admin user will get corrupt ?

any help is appreciated.
Limesh parekh
limesh@enjayworld.com
919377757650

[andopes]

Hi, enjayworld.

You can make a complete backup of your database using the phpmyadmin

Go to the phpmyadmin.
Select export
And at the next screen select the desired database at the multiselect field.
Choose the backup name


Cheers

André Lopes
Lâmpada Global Services
Av. Angelica, 1814 cj. 1502
São Paulo, SP 01228-200
tel1. 55 11 3668-6776
tel2. 55 11 3822-2581
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[enjayworld]

Does above procedure get all the data, I mean emails, notes, docs also ?

Kindly confirm

[AntSmith]

Does above procedure get all the data, I mean emails, notes, docs also ?

Kindly confirm

The problem is that this DOES NOT do enough of a backup. If you have custom fields then this will restore the data of the fields but you will not be able to access them. You need to ensure you backup various PHP code as well as the data. Also, your assumption is correct. Various documents and attachments (to emails) are not held in the DB. You will need to ensure you backup these locations as well.