thank you for your help...
but I have a question about upgrading from 1.3.1 to 1.4.1
I have windows machine & Apache2triad installed on it. so if i want to backup
postgre or the whole data and upgrade to the newest version of timetrex... so
any quick hints? really appreciated..
thank you...
Upgrading from 1.3.1 to 1.4.1
TimeTrex v1.4.2 was just released yesterday, so I would upgrade to that version.
Upgrading is quite easy, after you have completed your backup, just rename your current TimeTrex directory to "timetrex.old", unzip the new TimeTrex zip to the "timetrex" directory and copy timetrex.ini.php from "timetrex.old" to "timetrex". Then run the installer again.
Upgrading is quite easy, after you have completed your backup, just rename your current TimeTrex directory to "timetrex.old", unzip the new TimeTrex zip to the "timetrex" directory and copy timetrex.ini.php from "timetrex.old" to "timetrex". Then run the installer again.
You don't need to import any data when upgrading TimeTrex. In fact doing so will most likely break the upgrade.
You just need to backup your data before you start the upgrade process as a precautionary measure in case something goes wrong during the upgrade process.
In any case phppgadmin should have a import tool to help, or you can take a look here for a quick howto:
[urlhttp://www.cyberciti.biz/tips/howto-backup-pos ... bases.html[/url]
You just need to backup your data before you start the upgrade process as a precautionary measure in case something goes wrong during the upgrade process.
In any case phppgadmin should have a import tool to help, or you can take a look here for a quick howto:
[urlhttp://www.cyberciti.biz/tips/howto-backup-pos ... bases.html[/url]
found solution for backup/restore for pgresql
finally found a procedure to backup/resotre the DB on PostGRESQL and windows server using Apache2triad.
we start by dumping the DB using this command:
the destination of the backup file timetrex.bk will be on c:\
now let's drop the the timetrex db on postgre by loggin to phppgadmin and then re-create it with a same name.
Restoration:
that's all !!
enjoy backing up your db on pgresql on windows OS
we start by dumping the DB using this command:
Code: Select all
pg_dump -h localhost -p 5432 -U root -W timetrex -i -o > timetrex.bk
now let's drop the the timetrex db on postgre by loggin to phppgadmin and then re-create it with a same name.
Restoration:
Code: Select all
psql -d timetrex -f timetrex.bk -h localhost -p 5432 -U root -W
enjoy backing up your db on pgresql on windows OS