Upgrading from 1.3.1 to 1.4.1

[maroon]

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...

[shaunw]

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.

[maroon]

how to backup? just copy n paste folder? what about the database in postgre?

your help is highly appreciated

thank u

[shaunw]

Yup, you can just copy the TimeTrex folder and do a database dump with pg_dumpall or mysqldump.

[maroon]

please any how-to for dumping my postgre sql DB...

i'm using APACHE2TRIAD

please help!!

any help would be appreciated

thank you

[shaunw]

This should help:

http://www.postgresql.org/docs/8.1/static/backup.html

[maroon]

i've found on phpgadmin an export tool to backup the DB.

I need to know how to imoprt this DB after exporting it...

please I need to upgrade the timetrex to the latest version

thank you,

[shaunw]

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]

[maroon]

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:

Code: Select all

pg_dump -h localhost -p 5432 -U root -W timetrex -i -o > timetrex.bk

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:

Code: Select all

psql -d timetrex -f timetrex.bk -h localhost -p 5432 -U root -W

that's all !!

enjoy backing up your db on pgresql on windows OS