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: mysql17.000webhost.com)
Type the username for the database:
* (default: a3970413_phillip)
Type the password for the database:
Password required.
Type the database name:
* (default: a3970413_images)
Type the table name for the database:
* (default: images)
Type the name of the output text file to use:
* (default: remote_sql_output.txt)
Type the name of the input text file to use:
* (default: local_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:
2012-01-31 11:47:50
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
Upload a file to process first:
(Will upload into the current working directory for this script)