db backup

[tommytomato]

can some one tell me a eay way to back the gallery database.

or do i have to do it the hard way.?


please any idea's


cheers TT

mery xmas every one...

[Joachim Müller]

if your question is: how to backup coppermine, read this: http://coppermine.sourceforge.net/faq.php?q=BackupDatabase#BackupDatabase and http://forum.coppermine-gallery.net/index.php?topic=816

GauGau

[tommytomato]

Ok thanks.

I use a linux OS here, and i only use the CLI.
looks like i'll have to back it up like that.


thanks TT i did read the links thanks..

[Joachim Müller]

if you're running your own server, you can create a cron job with some simple mySQL-commands. Please refer to the mySQL-manual: http://www.mysql.com/doc/en/Backup.html

GauGau

[tommytomato]

thanks.

I found the way for Win, and i'm getting the hang of the Linux way now.

thanks again

EG for win is


To back up all databases

C:\mysql\bin\mysqldump.exe --host=localhost --user=username --password=password --all-databases > \path_to_backup_dir\mysql.back

to back up a single database use the command

C:\mysql\bin\mysqldump.exe --host=localhost --user=user_name --password=password dbtest>c:\path_to_backup_dir\dbtest.back

note it dont have to be .back you can name it to dbtest.sql

thanks for your help

TT