Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Back-up / Restore DB Table Properties for Link, Categories & User

Quote Reply
Back-up / Restore DB Table Properties for Link, Categories & User
How can I set 'Back-up / Restore DB Table Properties only for Link, Categories, Reviews & User' .

i.e. for a site I am working on, I finished creating all table properties (link, categories, reviews & users) & would like to create a backup for them. Just in case, I have to reinstall everything or have another setup on test domain.

I know I can do import/export using GLinks admin (Database -> Import/Export) but that does not seem to be doing the backup for table properties.

Thank you.

Vishal
-------------------------------------------------------
Quote Reply
Re: [VishalT] Back-up / Restore DB Table Properties for Link, Categories & User In reply to
The easiest way is just to backup with mysqldump in SSH:

Code:
mysqldump --add-drop-table -uUSER -pPASS DB_NAME > backup.sql

Then also backup the ./admin/defs folder, as this holds all the .def files (which are the DB definitions for GLinks to use)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Back-up / Restore DB Table Properties for Link, Categories & User In reply to
I actually went to PhpMyAdmin & backed-up the database, It seems like the fields are also in there. However, your method seems straight forward too :)

btw.. I had no clue about backing up .def file folder.. thanks for adding that info.. now I feel little more confident about playing with the site functions & being able to restore if something goes wrong.

Thanks again :)

Vishal
-------------------------------------------------------