mySQL

[jonspe]

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?

Regards

Jon

[Watdaflip]

Re: mySQL

1. No, atleast not that I know of
2. You can export tables in a database with complete inserts. Presuming you know how to read the code you can edit the exported database and import it
3. Im not sure of any off the top of my head, I know mysql administrator is a good program for editing a database online, it might work offline as well

[jonspe]

Re: mySQL

Thanks, Watdaflip