Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Save Database
 
Notifications
Clear all

Save Database

3 Posts
3 Users
0 Reactions
3,939 Views
(@christophebolmontcharpy)
Posts: 18
Active Member
Topic starter
 
[#4693]

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

Chris


 
Posted : 12 Oct 2017 18H41
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes, with "Database backup" plugin.


 
Posted : 12 Oct 2017 18H50
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


 
Posted : 13 Oct 2017 1H28
Share:

Scroll to Top