Poly Off Topic Users - The Dumbass Situation

[DaShi]

I thought you'd never ask for it!
Request approved.

Ha! Asher, you need a record like mine.

[DaShi]

Now if we could only stop them from accumulating with every post, I would be content.

[Robert]

Ha! Asher, you need a record like mine.

I tried to add them to my own account but I can't give myself neither a PCR nor a PCI

Now if we could only stop them from accumulating with every post, I would be content.

Also that request has been approved.
/me perm bans DaShi

[Robert]

Chicken.

I know that you would have done the expected

[DaShi]

I tried to add them to my own account but I can't give myself neither a PCR nor a PCI

That's probably a bug. You should report it.

[Asher]

Just change it in SQL. I'd do it for you if I still had access to the Poly DB.

[Asher]

Actually maybe I do.

Did you change the passwords since the previous administration left?

[Thoth]

It has come to my attention that some users are unhappy that so many posts are just users calling each other dumbass.

To remedy this I'd like to propose the following:

Would every user endeavour not to post as much dumb stuff? This will save other users having to call you a dumbass.

Thanks!

STFU Dumbass.

[Aeson]

PCR 2 0 2 plz

[DaShi]

Robert only just reduced my post count to zero yesterday and I've already got over 500 posts. I'm here too much.

[Robert]

I reduced it by 10,000. Not to zero.
I figured that remembering 10,000 was a lot easier then remembering 10556 (Hey, I still remember!)

[Robert]

Just change it in SQL. I'd do it for you if I still had access to the Poly DB.

Actually maybe I do.

Did you change the passwords since the previous administration left?

I do not really bother....
And since the previous administration left we changed servers, software, so the passwords most probably don't match as well anymore

You're able to do SQL stuff?
Would you care to try to get the archives at least backed up from the old server, and maybe even try to help them to transfer them to the new one? (as a matter of fact parts of the archives are missing on the new server while they're still there on the old server)

[Wezil]

That would be a true community service.

[Asher]

I do not really bother....
And since the previous administration left we changed servers, software, so the passwords most probably don't match as well anymore

You're able to do SQL stuff?
Would you care to try to get the archives at least backed up from the old server, and maybe even try to help them to transfer them to the new one? (as a matter of fact parts of the archives are missing on the new server while they're still there on the old server)

I guarantee you that investment banks had far larger DBs with far more asinine schemas than whatever Poly has...

As for backing up, what's the problem?

It's MySQL, no?

mysqldump -u <username> -p <password> --databases <database names, space-delimited> | gzip >databasebackup.sql.gz

Or to simply back up all:

mysqldump -u <username> -p <password> --all-databases | gzip >databasebackup.sql.gz

This will back up the entire MySQL database and compress it for transfer.

Then on your new server, upload the file and restore it. Note if you have duplicate database names, you'll probably just need to resolve this in the plaintext .sql file (unzip it then search/replace).
To restore:

gunzip < databasebackup.sql.gz | mysql -u <user> -p <pass>

You could also do a direct DB-to-DB transfer:

mysqldump -u <username> -p <password> --all-databases | mysql --host=<new host> <username> -p <password>

[DaShi]

I reduced it by 10,000. Not to zero.
I figured that remembering 10,000 was a lot easier then remembering 10556 (Hey, I still remember!)

There's no reason to remember. Bring my post count to zero.