I'd appreciate some info on the following:
1. What are the file locations of the databases when they are created? I know they are managed thru the control panel. Can file locations be made visible in the control panel File Manager?
2. I've looked at phpAdmin and can see that data can be imported/exported from mySQL databases, presumably for backup/restore purposes. Is there any way to download/upload complete databases for off-line maintenance and back-up?
3. Is there a recommended program to administer databases off-line?