Good news, Dreamhost had backups of all our databases, even the one I deleted (because Judy Garland told me to), and the support guy just copied them into my directory.
My brain is fried from trying to straighten out the mess I made with thepan.org, so I'm no longer able to rationally troubleshoot anymore tonight, but I have one last request to the Wordpress hackers on this list: Do any of you know about Wordpress feed generation, and why our raw feeds aren't populating? http://thepan.org/admin/wp-rss2-qt.php http://thepan.org/admin/wp-rss2-wmv.php They're custom versions of the wp-rss2.php file, with just a custom enclosure element, and they've been working fine for almost a year now, but when I messed up our database, I had to reinstall wordpress and something got messed up. I use too many commas. AQ On 11/17/06, Adam Quirk <[EMAIL PROTECTED]> wrote: > > Yep, I saw that. Trouble is that I need to restore a deleted database, so > it's no longer in the tree on the mysql page. > > Hopefully they'll have it somewhere. > > I have it backed up to September, so at worst we'll be missing October and > part of November, which have been slow anyhow if anyone has noticed. The > PAN has been going through some emotional changes, hormonal in nature, > similar to puberty, minus the sex drive. > > AQ > > On 11/17/06, Bill Streeter <[EMAIL PROTECTED]> wrote: > > > > To restore backup databases on Dreamhost go to goodies in your > > dreamhost panel then "manage mysql" and then find the database you > > want to restore and click the "restore" button on it. You'll get a > > choice of backups that you want to revert to. Thats it. > > > > Bill Streeter > > LO-FI SAINT LOUIS > > www.lofistl.com > > > > --- In videoblogging@yahoogroups.com <videoblogging%40yahoogroups.com>, > > "Adam Quirk" <[EMAIL PROTECTED]> > > wrote: > > > > > > A better question is, what unix command lists hidden directories? > > > > > > On 11/17/06, Adam Quirk <[EMAIL PROTECTED]> wrote: > > > > > > > > Hi Charles, > > > > > > > > Im using mySQL on Dreamhost. The support docs mention that they > > do a > > > > nightly backup of all databases. The problem is, I don't know > > where to look > > > > for them. They are accessible via the admin panel at dreamhost, > > but only > > > > the databases that still exist. I need to access a snapshot of > > a database > > > > that was deleted. Not even sure if that's possible. > > > > > > > > Any clues as to where they might store the snapshot? They take > > snapshots > > > > of the domains too, and store them in a folder at the root > > called .snapshot > > > > > > > > Thanks for the help, > > > > Adam > > > > > > > > On 11/17/06, Charles Iliya Krempeaux <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hello Adam, > > > > > > > > > > What kind of database server are you using? MySQL? Postgres? > > SQLite? > > > > > Oracle? Something else? (I don't think the "repair" command > > are the same > > > > > across all of them.) > > > > > > > > > > Looking forward... you could try backing up your database > > automatically. > > > > > (I'm very familiar with MySQL... so if you are using that I > > could help > > > > > set > > > > > something up for it.) > > > > > > > > > > Also... something else to consider is the backup stuff that > > was being > > > > > discussed in the "I.Hate.Blogger" thread (on the Videoblogging > > Mailing > > > > > List). Refer to these... > > > > > > > > > > http://tech.groups.yahoo.com/group/videoblogging/message/52143 > > > > > http://tech.groups.yahoo.com/group/videoblogging/message/52155 > > > > > http://tech.groups.yahoo.com/group/videoblogging/message/52157 > > > > > http://tech.groups.yahoo.com/group/videoblogging/message/52168 > > > > > http://tech.groups.yahoo.com/group/videoblogging/message/52171 > > > > > > > > > > Doing something like what is described there could allow a > > kind of > > > > > "universal vlog backup application" to be able to backup any > > vlog... > > > > > without > > > > > needing direct access to the database. > > > > > > > > > > See ya > > > > > > > > > > > > > > > On 11/17/06, Adam Quirk <[EMAIL PROTECTED] <bullemhead% > > 40gmail.com>> > > > > > wrote: > > > > > > > > > > > > Chris and I are working on thepan.org site. All things are > > fucked > > > > > right > > > > > > now, feeds included. > > > > > > If you want to watch The PAN, go to http://thepan-org.blip.tv > > > > > > > > > > > > If anyone knows anything about retrieving lost sql data, I > > could use > > > > > some > > > > > > tips. > > > > > > I'm hoping there's a cache somewhere. > > > > > > > > > > > > Thanks, > > > > > > AQ > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Charles Iliya Krempeaux, B.Sc. > > > > > > > > > > charles @ reptile.ca > > > > > supercanadian @ gmail.com > > > > > > > > > > developer weblog: http://ChangeLog.ca/ > > > > > __________________________________________________________ > > > > > Make Television http://maketelevision.com/ > > > > > > > > > > __________________________________________________________ > > > > > Cars, Motorcycles, Trucks, and Racing... http://tirebiterz.com/ > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > [Non-text portions of this message have been removed]