[videoblogging] under control

2006-11-17 Thread Adam Quirk
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

Re: [videoblogging] under control

2006-11-17 Thread Charles Iliya Krempeaux
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

Re: [videoblogging] under control

2006-11-17 Thread Adam Quirk
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

Re: [videoblogging] under control

2006-11-17 Thread Adam Quirk
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

Re: [videoblogging] under control

2006-11-17 Thread Charles Iliya Krempeaux
Hello Adam, You use the a (for all) option. (Just an FYI... hidden directories or files start with a period... with a .) So, you might type something like... ls -alF NOTE... these backups will likely NOT be on your server. They will probably be on a tape that's stored in a safe or a

Re: [videoblogging] under control

2006-11-17 Thread Charles Iliya Krempeaux
Hello Adam, They probably have them on tape backup that's not accesable via any web interface. (Old tape backups are probably stored in a safe or a locker or something.) You'll probably have to ask them for it. (Via e-mail or whatever issue tracker they have.) So... basically ask them for the

Re: [videoblogging] under control

2006-11-17 Thread Devlon
Nevermind, was thinking of a different hosting service. I can't find anything on our DreamHost server. On 11/17/06, Devlon [EMAIL PROTECTED] wrote: I've seen the backups on our servers, let me poke around and see if I remember. Yeah, they shouldn't be on the same server, seems

Re: [videoblogging] under control

2006-11-17 Thread Devlon
I've seen the backups on our servers, let me poke around and see if I remember. Yeah, they shouldn't be on the same server, seems pointless...but I swear I've seen 'em. On 11/17/06, Charles Iliya Krempeaux [EMAIL PROTECTED] wrote: Hello Adam, They probably have them on tape backup that's not

Re: [videoblogging] under control

2006-11-17 Thread Harold Johnson
Please say it ain't so! But you *do* have all the video backed up, right? I *love* watching your collections/pans... Harold http://somethingthathappened.com Incidentally, something happened that I'll be posting video about On 11/17/06, Adam Quirk [EMAIL PROTECTED] wrote: Chris and I are

Re: [videoblogging] under control

2006-11-17 Thread sull
dude, dreamhost support will restore it for you most likely. unless you have an unmanaged dedicated server? just email them, they get back to you same day most of the time. use the support form in cpanel sull On 11/17/06, Adam Quirk [EMAIL PROTECTED] wrote: Chris and I are working on

Re: [videoblogging] under control

2006-11-17 Thread Adam Quirk
Yes, all videos remain intact. I'm pretty sure the database will be fine too. Judy Garland broke into our server and got her spirits all up in our machinery. We hired Juan Carlos http://blip.tv/file/64831 to exorcise her though, and all seems normal. Just waiting on Dreamhost support to respond