Ok, so I have a problem. On one of my sites my host "disabled" one of my databases due to being a resource hog.. or some other BS.<br /><br />So, they inform me to continue using it, I need to get a dedicated server. Well.. no, I will not be getting a dedicated server with them, and am getting one elsewhere. So anyway, even in phpMyAdmin I can't see the database.<br /><br />I am praying to god it hasn't been deleted and only somehow disabled or moved or something. So, since it will take ages to hear back from them about the issue, I have shell access so I wanted to just go in and find it myself and copy it to my HD, but I can't find it. <br /><br />The "locate" db is too old, it isn't showing anything, so I was wondering where these are usually stored? Or if this would even be possible? <img src="/forum/images/graemlins/frown.gif" alt="" />

The "default" would be in the "data" subdirectory of the location where MySQL resides in.<br />Each database in it's own directory (same name as the database).<br /><br />But I'm not familiar with multi-user setups and don't know how the structure would be in that case. <img src="/forum/images/graemlins/crazy.gif" alt="" /><br /><br />Edit: Sorry, I'm talking about the default structure on Windows based servers, not Unix.

On my server, it's /var/lib/mysql<br /><br />I think I used the default settings when installing MySQL. <br /><br />The files are owned by either 'mysql' or 'root', and are not public-read, so you might have trouble accessing them directly.<br /><br />You might be able to backup the database with mysqldump.

never thought of using mysqldump.. but alas, it says there is no database found with that name <img src="/forum/images/graemlins/mad.gif" alt="" /><br /><br />and I don't see it under that location. argh....