View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Back-up / Restore - ProjeQtOr
 
 

Back-up / Restore

More
08 Feb 2011 10:34 #1 by babynus
Back-up / Restore was created by babynus
Back-up is a good practice.
You should regularly back-up your Data to be able to retrieve it is case of a crash.
How often ? It just depends on your need ... Just ask yourself : what is acceptable to loose in case of a crash ? 1 day, 1 week ?

You should also always back-up your Data before any application upgrade... in case of ...

So, how to back-up ? The simplest way is to use phpMyAdmin export capacity, using "SQL" format, saving result to a file.
Then you'll be able to import Data from this exported file.

hints :
- be sure to use UTF-8 charset when exporting / importing.
- you cannot import into a full Database (with existing Data) :
=> either you truncate the tables before import
(you must then assure to import Data into a structure of the same version of application !)
=> or you drop the tables before import
=> or you export data including 'Drop tables'
- regularly test your back-up files, trying to restore it on an empty Database
(I saw so many times back-up that were never tested, and could not be imported when needed...)
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
13 Dec 2011 11:31 #2 by ivanturpin
Replied by ivanturpin on topic RE : Back-up / Restore
I was looking for backup solution provider companies in London. Though I know Intacore is best among them but wanted to know reviews of other readers.

================
Backup
The topic has been locked.
More
13 Dec 2011 15:02 #3 by climb4fun
Replied by climb4fun on topic RE : Back-up / Restore
Dear all,

for your productive envirnoment, we have daily dumps of all databases triggered with cronjob. We didn't have an outsourced centre for this service.

On my test environment I apply MySQLDumper (open source), because this is very flexible and is not to be maintained by our operations team.

Klaus
The topic has been locked.
More
23 Dec 2011 07:44 #4 by Grete Anderson
Replied by Grete Anderson on topic RE : Back-up / Restore
Even I found Inta core most reliable and cost effective when it comes to backup.
The topic has been locked.
More
27 Mar 2012 09:36 #5 by simonbond
Replied by simonbond on topic RE : Back-up / Restore
I like all the posts here about the backup. I also got good solution here for the online data backup. But I think here you should post more tricks and tips for data handling. Thank you.

___________________________
excel tips
computer pranks
windows xp tricks
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.036 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form