Problems on MySQL restore

[dzeanah]

Looks like the MySQL version direct from MySQL.com/Oracle worked fine where the one from the yum repository was failing. Now, to research whether that's something I want to deal with or not.
...

[dzeanah]

So I ran it again on a Windows machine running MySQL 5.5 and it went through cleanly.

I wonder if it's an issue with the MySQL version, or possibly that I've got replication turned on?...

[dzeanah]

MySQL source machine: Server version: 5.0.51-log MySQL Community Edition (GPL)
MySQL destination machine: Server version: 5.0.77 Source distribution

I performed this command:...

[dzeanah]

Figured it out. Thanks.

[dzeanah]

Never mind - first plugin = confusion, I suppose.

[dzeanah]

Posting a follow-up for people who run into the same problem I do.

Steve's fix worked to a point. Once implemented the immediate problem went away, but I'd eventually run out of memory and...

[dzeanah]

It looks like that did it. Or at least, the process didn't stop where it did before, and it seems to be chugging along happily (if not as quickly as I'd prefer.)

Thanks, Steve.

[dzeanah]

I run a bigger forum, with 6.6 million posts and 500k threads.

I just turned the similar threads feature on, and I'm finding that reindexing dies consistently on thread #9, which happens...

[dzeanah]

OK.

Thanks.

[dzeanah]

I guess I wasn't clear.

What options are there that don't require adding a new hard drive or clearing up space in the short term? Is mirroring the database to another server viable from...

[dzeanah]

We're at the point where mysqldumps are in excess of 3 gigs, and there's not enough space on the device to gzip it at that point.

Up until now I've been dumping to the FS and using rsnapshot...

[dzeanah]

Poking around, it looks like someone's just found this page: http://www.thehighroad.org/sendmessage.php

Now, each IP address is different (84.40.23.88, 66.135.37.205, 65.98.58.250, 64.202.123.207...

[dzeanah]

http://www.thehighroad.org...

[dzeanah]

Just received a few e-mails similar to this one. Not quite sure what to make of it.

Does vB even have a contact us page that these can be sent from? All I see is a mailto: link at the bottom...

[dzeanah]

Thanks much.

[dzeanah]

Is there a toggle somewhere we can use to enable this by default, at least for some user groups? It'd be nice if PMs from moderators defaulted to "tracking = on."

Any chance of...

[dzeanah]

Thanks!

[dzeanah]

Thanks.

What's considered a "reasonable limit?" Before this, I would have thought a 2 megabyte SQL query was outside of reasonable for a forum...

[dzeanah]

A few times a day I get these errors:That address resolves to a cache at AOL that more than 50 of our users have come through at least one time, so I don't want to ban it.

Any idea what I...

[dzeanah]

Thanks.

I'll give it a shot.