Posts: 6,710
Threads: 131
Joined: Mar 2004
The only kind of dump I know of is a full MySQL database backup, which I can make through the vBulletin control panel, but can't retrieve or download it from there without server file access.
Posts: 483
Threads: 17
Joined: Oct 2007
T-hawk Wrote:The only kind of dump I know of is a full MySQL database backup, which I can make through the vBulletin control panel, but can't retrieve or download it from there without server file access. Oh you can retrieve or download it without server file access. All you need to do is create the MySQL dump file in a path that's part of the website and get it with a regular browser.
Of course writing a dump file requires enough disk space to do this. Now the error message you posted earlier states that we are already out of space on RB so i doubt a dumb will succeed.
Arthur pulls tiles from the Scrabble bag which by random form into "What do you get when you multiply six by nine?"
Arthur: "Six by nine? 42?"
Ford: "I always knew there was something fundamentally wrong with the universe."
Posts: 4,443
Threads: 45
Joined: Nov 2009
Dr.Disaster Wrote:Oh you can retrieve or download it without server file access. All you need to do is create the MySQL dump file in a path that's part of the website and get it with a regular browser.
Of course writing a dump file requires enough disk space to do this. Now the error message you posted earlier states that we are already out of space on RB so i doubt a dumb will succeed.
Your name is apt. I wonder if it saves passwords in plain text?
In Soviet Russia, Civilization Micros You!
"Right, as the world goes, is only in question between equals in power, while the strong do what they can and the weak suffer what they must."
“I have never understood why it is "greed" to want to keep the money you have earned but not greed to want to take somebody else's money.”
Posts: 483
Threads: 17
Joined: Oct 2007
antisocialmunky Wrote:Your name is apt.
*thinks*
Actually i wonder if "My name is apt." does qualifiy for a new QotM 
antisocialmunky Wrote:I wonder if it saves passwords in plain text? Usually dumps are plain text, so the answer is yes. BUT when nobody beside T-hawk knows path and name of the dumpfile which is required for retrieval i'm certain we are pretty save here. In doubt he can overwrite or delete the dumbfile after retrieval.
Arthur pulls tiles from the Scrabble bag which by random form into "What do you get when you multiply six by nine?"
Arthur: "Six by nine? 42?"
Ford: "I always knew there was something fundamentally wrong with the universe."
Posts: 6,710
Threads: 131
Joined: Mar 2004
Profiles seem to be working for me now. I didn't do anything, so probably either our web host freed some space for us, or MySQL did something like clean up an old backup on its own. Get your avatars in now before it breaks again. 
On downloading a backup - of course you're right that it's doable if the backup lands in a web-accessible directory. But I have no idea how the server is organized, with the relative paths between MySQL and the web space, and I'm not inclined to start trying random paths like ../../www/forums when I can't delete the backups to free the space.
Posts: 3,390
Threads: 31
Joined: Dec 2009
T-Hawk, not sure if you're aware, but the forums were down for 24 hours. (Database error)
Posts: 6,710
Threads: 131
Joined: Mar 2004
Yeah but I couldn't exactly post about it. 
I didn't do anything for the first error (MySQL too many connections), that must have been the web host if it wasn't MySQL itself cleaning up the connections. I did fix the second error (corrupt table), the admin control panel was working and I found the place where a command to repair MySQL tables is exposed.
Posts: 1,075
Threads: 14
Joined: Oct 2010
Thanks for fixing it T-hawk.
Amusingly, I got all excited that the forum was back, then realized sadly right after, that oh, yeah, there isn't going to be any new posts because no one else could post either. 
Posts: 4,443
Threads: 45
Joined: Nov 2009
T-hawk Wrote:Yeah but I couldn't exactly post about it.
I didn't do anything for the first error (MySQL too many connections), that must have been the web host if it wasn't MySQL itself cleaning up the connections. I did fix the second error (corrupt table), the admin control panel was working and I found the place where a command to repair MySQL tables is exposed.
Oh good, can you dump the database onto the server anyway? Glad it worked out.
In Soviet Russia, Civilization Micros You!
"Right, as the world goes, is only in question between equals in power, while the strong do what they can and the weak suffer what they must."
“I have never understood why it is "greed" to want to keep the money you have earned but not greed to want to take somebody else's money.”
Posts: 6,710
Threads: 131
Joined: Mar 2004
Yeah, I already tried in the wake of this problem. Didn't work though, threw an error that the directory is not writable by the web server process. I don't have file system access to make it writable or find another directory.
|
