Reposting to list… Thank you for your suggestion, Odhiambo. I fiddled with it quite a bit and was able to recover a working database with no data loss. Your steps are effectively what I did to retrieve it except for changing all instances from encrypted.* to ssl.*. Very glad to have not lost that important data.
Although backups should have been made automatically, that was not the case. Will be investigating my Virtualmin software for the cause of the missing of backups too. On Aug 12, 2013, at 5:41 AM, Odhiambo Washington <odhia...@gmail.com> wrote: > If the database is still in place (you did not wipe it out), then I > suppose maybe you just need to dump the db, edit to change the domain > name, then re-import into the database. It requires CLI to do that. I > don't know how to do it via GUI: > > From CLI: > > mysqldump dbname > dbname.sql > cat dbname.sql | sed -i.BAK 's/ssl/encrypted/g' > mysqladmin drop dbname > mysqladmin create dbname > mysql dbname < dbname.sql > > On 12 August 2013 05:31, Jason Wohlford <ja...@wohlfordcompany.com> wrote: >> I'm afraid I have done something to my database. I've lost my contacts, >> calendars, and user settings. Very eager for some help. I use software >> called Virtualmin which is part of the Webmin family. Yesterday, I changed >> the domain name in the Virtualmin from ssl.montgomery.al to >> encrypted.montgomery.al. This evening I noticed data was missing. I've >> performed a backup of all the data. It seems it is all there. I'm guessing >> it is some sort of permissions problem. Desperately needing assistance. -- Jason Wohlford <ja...@wohlfordcompany.com> <http://www.wohlfordcompany.com/> 334.322.1491 -- users@sogo.nu https://inverse.ca/sogo/lists
