How to backup a project in the server.

Message boards : Server programs : How to backup a project in the server.
Message board moderation

To post messages, you must log in.

AuthorMessage
Patricio Vidal

Send message
Joined: 12 Mar 09
Posts: 2
United States
Message 23644 - Posted: 12 Mar 2009, 20:10:55 UTC

Hello all,

I'm not sure if this is the right forum for this question, but I couln't find a forum for server management.

I am running a Boinc server on my company's intranet, and I wanted to know how to backup my project. My guess is that I have to save the content of the ~/Boinc/projects/my project/ folder, but I guess that I also need to backup the MySql database (or some tables on it)? How?

Also, if I have a backup of my project. What will it take to put it on another server? Do I create a project and then replace its content with my backup? How do I import the MySql tables?

Thank you in advance for your time.

Best regards,
Patricio Vidal.
ID: 23644 · Report as offensive
Eric Myers
Avatar

Send message
Joined: 12 Feb 06
Posts: 232
United States
Message 23674 - Posted: 14 Mar 2009, 0:27:02 UTC - in response to Message 23644.  

Yes, copy the project directory, and the database.

For the database you can make a copy of the files (check /etc/my.cnf for the location of datadir, possibly /var/lib/mysql), but there are also ways to backup the database using mysql. That's something you might want to read up on at mysql.com, or a book on mysql (there are several).
-- Eric Myers

"Education is not the filling of a pail, but the lighting of a fire." -- William Butler Yeats
ID: 23674 · Report as offensive
Patricio Vidal

Send message
Joined: 12 Mar 09
Posts: 2
United States
Message 23753 - Posted: 17 Mar 2009, 22:21:33 UTC - in response to Message 23674.  

Hello Eric,

Thank you for your answer. Based on your answer I did a little search about backing up the mysql database and found this link (http://boinc.berkeley.edu/mysql_backup.txt) that showed how the SETI project do it.

Regards,
Patricio.
ID: 23753 · Report as offensive

Message boards : Server programs : How to backup a project in the server.

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.