SQL scripts (including backup files) are kept in the user dedicated directory, defined by user name and user location. For example user username1
from location userhost1 and the same user username1 logged in from different location userhost2 will use different directories. For each user@location pair
only one directory is accessible.All scripts can exist as plain text, compressed zip files (with .zip extension) and compressed as gzip
files (with .gz extension). Any script in plain text format can be compressed using zip or gzip methods. The method used for compressing is defined during the initial setup and can not be changed without
editing the program source file.
It is not necessarily to decompress the script in order to run it. When a compressed script is selected to
run, the program will decompress it before the execution and compress it again after that, even if an exception occurred during the execution.
Mysql Data Manager allows the user to upload his own files created on his local machine.
These files should be zip, gzip or plain text files. Zip files should not contain more than one
compressed file inside, they also should not contain path info.
NOTE: If you upload a file 'filename' into the user directory where file 'filename.zip' or 'filename.gz'
already exist you must use 'overwrite if exists' option, otherwise the file will not be uploaded.
Before the script is applied to the selected database its header can be previewed.
If the header of the uploaded file is not specially formatted for this purpose the program shows the first 12 lines of the file.
Any file from the user directory can be downloaded or deleted using "DOWNLOAD" or "DELETE" buttons.
It is not recommended to use 'Back' or 'Forward' buttons of web browser, because in this case wrong
information can be reflected. If you are not sure that the current page is updated correctly use 'RELOAD' button' in order to update the page