Print Page - db backup

Title: db backup
Post by: tommytomato on December 20, 2003, 06:43:38 AM

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...

Title: db backup
Post by: Joachim Müller on December 20, 2003, 07:45:25 AM

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

Title: db backup
Post by: tommytomato on December 20, 2003, 08:15:20 AM

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..

Title: db backup
Post by: Joachim Müller on December 21, 2003, 01:06:59 PM

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

Title: db backup
Post by: tommytomato on December 21, 2003, 01:17:53 PM

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 8)

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: tommytomato on December 20, 2003, 06:43:38 AM