MySQL Data Manager
**** BUILD UP STAGE ****
This program can be used to transfer data from host table to local dbf and viceversa.
I use this program to do Backup and/or Restore of single data table from host to client. So this program is slow on large tables or on slow
networks. All data types are not fully supported. In a case of backup, table structure is copied into file with extension of .str and data is then transfered into apropriate dbf table. I decided to use dbf because data in that format can be easily used by some other applications.
When creating backup on local machine one has option to simple crypt
data in dbf table. This also put some extra time on execution.
Currently supported MySQL fields are:
- CHAR(n)
- INT[(n)]
- DECIMAL(n) or NUMERIC(n)
- DATE
- DATETIME => char(19) YYYY-MM-DD HH:MM:SS
- TIMESTAMP[(n)] => char(n)
- TINYBLOB or TINYTEXT => char(255)
- BLOB or TEXT => memo (I think up to 32K)
You can use this program as you wish, on your own risk. You should
always made some backups of data before backup or restore. I\m not
responsible of any damage or loss of data for using this program.
What\s not functioning :
- Blob support
- RESTORE
- TIMESTAMP - error
- .....
Maybe in the future this program will be used also to transfer whole or partial data in one table from host to host.
I will realy appreciate some feedback on my e-mail
pmax@g-kabel.si
INSTALATION
Put program (exe) fle in some dir also you must copy all ddl\s in \windows\system dir.
원본 출처 : http://www.primej.com/mysqlman
|