Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

need a more flexible backup

Quote Reply
need a more flexible backup
Here some doubts I have regarding the way LinksSQL does backups... I develop on a win machine, then I put the final working LinksSQL on a Unix system, with the current export/backup system I'm not able to copy the database used in the on-line server and test it onto my local windows machine.

I think shuold be more convenient have a procedure that exports all datas from all tables including attachments and so on. Somekind of istant photo of the actual database (cp ./mysql/data/Links ..ect) but machine indipendend.
Right now, if I use attachments tables for example I should have more than one problem trying to recostruct the database in the way the backup works now.

Are there some tricks to allow people to get the entire database exported?

This sounds like a wish list :-)



thanks in advance


lepo

Quote Reply
Re: need a more flexible backup In reply to
Unfortunately doing it in a database independant way is very difficult. I would use the mysql tools for this.

To export:

mysqldump --add-drop-table -uUSERNAME -pPASSWORD YOURDB > backup.txt

to restore:

mysql -uUSERNAME -pPASSWORD YOURDB < backup.txt

Backup.txt is a simple ascii file that you can copy between unix/windows and contains a "snapshot" of your database.

Cheers,

Alex