Trying to restore a db

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Locked
fred
Posts: 38
Joined: Mon Oct 26, 2009 8:28 am

Trying to restore a db

Post by fred »

I'm currently running Timtrex 3.0.3 on our server.
One of our employes made a mistake in his timesheet this morning, and doesnt remember the initial data.

So I'm trying to see was whas in the at the last TimeTrex backup (SQL dump)

I don't want to restore the whole database, so I installed on another test machine the lastest version of TimeTrex 3.0.5. (Running XP SP3)
After installation, I initialised Timetrex like every new installation, stopped services and then clicked on restore_database.bat.

The command windows launched and closed automaticaly...
The database file i'm trying to restore is from version 3.0.3
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Trying to restore a db

Post by shaunw »

The command you need to run is:

restore_database.bat <backup file.sql>

ie:

restore_database.bat timetrex_backup_20100101.sql
Locked