Forum

Save Database
 
Notifications
Retirer tout

Save Database

3 Posts
3 Utilisateurs
0 Reactions
3,923 Vu
(@christophebolmontcharpy)
Posts: 18
Eminent Member
Début du sujet
 
[#4693]

Hello,
i'd want how to save mysql database directly on ProjeQtor .? Is it possible ? where please

Chris


 
Posté : 12/10/2017 6:41 pm
(@babynus)
Posts: 14952
Membre Admin
 

Yes, with "Database backup" plugin.


 
Posté : 12/10/2017 6:50 pm
Dale Scott
(@dale)
Posts: 12
Active Member
 

You can also backup using cli tools. Also you should backup any uploaded or generated files stored in the file system.

mysqldump -u root -p projeqtor | gzip > projeqtor.sql.gz
tar -zcf projeqtor.attach.tar.gz /usr/local/www/projeqtor/files/attach
tar -zcf projeqtor.report.tar.gz /usr/local/www/projeqtor/files/report
tar -zcf projeqtor.documents.tar.gz /usr/local/www/projeqtor/files/documents

The file paths on your server will probably be different than on mine and will need to be changed appropriately. Also before backing up the database you should ideally first disable user access to ProjeQtOr (e.g. by temporarily stopping the web server).

You can also use web db admin apps such as phpMyAdmin or Adminer to backup the database, but you will still need to backup the file system files separately (e.g. copy from server using WinSCP)

Cheers,
Dale


 
Posté : 13/10/2017 1:28 am
Share:
Retour en haut