vtiger

dubberdan · Posted: Thu Aug 21, 2008 2:55 pm Post subject: Backing up data but not structure

I think something odd has gone on with me install, so I want to backup just my data (accounts, contacts, products, etc) so I can then import it all into a fresh install.

How can I back just this info up rather backing up the whole database?

pinaki · Joined: 18 Oct 2007 Posts: 57

Hi dubberdan,

You can achiene this by export your data and importing it in your new install. But vtiger for now only provides import/export facility for few modules (Accounts, Contacts, TroubleTickets, Leads, Potentials, Products, Documents and Vendors).

Other than these modules, you will have to take backup from database itself.

Thanks
Pinaki
vTiger Team

dubberdan · Posted: Fri Aug 22, 2008 8:31 am Post subject: Backing up data but not structure

Ok thanks.

How would I go about that then, as I can't see it anywhere obvious, or is that what the Backup Server section does in Settings?

churchpath · Joined: 15 Oct 2007 Posts: 58

Hi,
Use phpmyadmin - select your db and then go to EXPORT and export your data/structure as a .sql file.
This will back up everything for you (data and structure) - except the actual files of your install.
ChurchPath.

dubberdan

churchpath wrote: Hi,
Use phpmyadmin - select your db and then go to EXPORT and export your data/structure as a .sql file.
This will back up everything for you (data and structure) - except the actual files of your install.
ChurchPath.
Yep, I know that, but I don't want to back up the structure, only the data ;)

churchpath · Joined: 15 Oct 2007 Posts: 58

Then untick 'structure' in export page in myphpadmin before you export.

dubberdan

ok, cool, good tip :)