Simple SQL data synchronization.
Leave any fields marked * blank to use the defaults coded into the script or read in from a previously saved .ini file...
(Any values in the .ini file take precedence over the script defaults)
Type the hostname of the target system:
* (default: db1)
Type the username for the database:
* (default: imagef_1)
Type the password for the database:
*
Type the database name:
* (default: imagef_1)
Type the table name for the database:
* (default: images)
Type the name of the output text file to use:
* (default: local_sql_output.txt)
Type the name of the input text file to use:
* (default: remote_sql_output.txt)
Type the name of the remote file path to use:
* (default: http://www.imagefair.co.uk/PHP/)
Type the name of the local file path to use:
* (default: http://localhost/imagefair/PHP/)
Type the name of the time stamp field to use:
* (default: TimeStamp)
Type the name of the 'new or deleted' field to use:
* (default: new_or_deleted)
Change the date of the last synchronization:
The last synchronization was on:
2009-08-25 11:58:48
Type the name of the index field to use:
* (default: id) Note: case sensitive
Tick to display sql commands and other output.
Tick to force an overwrite of target records if there is a conflict
Download a file to process first:
remote_sql_output.txt
( Right click and 'Save As')