Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [I]Polsaker>oh well
- [I]Polsaker>let me tell you about how AWESOME mysql is!
- PM_ME_YOUR_BOOBS2>I'
- PM_ME_YOUR_BOOBS2>m all ears!
- PM_ME_YOUR_BOOBS2>HOW AWESOME IS IT?!?!
- [I]Polsaker>Inocent little Polsaker once opened the mysql console, wanting to change the character set of his tables
- PM_ME_YOUR_BOOBS2>why does this story sound familiar so far
- [I]Polsaker>he carefully typed the commands
- [I]Polsaker>but as he typed the last command he noticed some errors were popping up
- PM_ME_YOUR_BOOBS2>Cannot change column 'client_id': used in a foreign key constraint 'grant_ibfk_1'
- [I]Polsaker>"well, I just have to repair the table", he innocently thought
- [I]Polsaker>but as he tried to repair the table, he noticed that the table did not exist anymore
- PM_ME_YOUR_BOOBS2>wft?
- [I]Polsaker>for his nightmares came true and the whole database got corrupted
- [I]Polsaker>"well, gotta restore from the backups then"
- PM_ME_YOUR_BOOBS2>insert dramatic music here
- [I]Polsaker>But as little Polsaker tried to recreated the tables he shockingly saw yet another error!
- [I]Polsaker>"Table sub_post already exists"
- [I]Polsaker>"Well, I guess I have to remove it first"
- [I]Polsaker>but as he issued the DROP TABLE sub_post command he was met by yet another error!
- [I]Polsaker>"Table sub_post does not exist"
- [I]Polsaker>It was then when Polsaker realized that not only was his database corrupted, but it was also haunted!
- PM_ME_YOUR_BOOBS2>I'm assuming this has a happy ending
- [I]Polsaker>Pancking, little Polsaker tried to wipe the whole database to re-create it again
- [I]Polsaker>as he was typing he was receiving thousands of pings on IRC from people wondering why the fuck was Phuks down
- [I]Polsaker>but no matter how many times he tried to drop and re-create the table or even the whole database
- [I]Polsaker>the ghost sub_post table kept haunting him
- PM_ME_YOUR_BOOBS2>reboot vps?
- [I]Polsaker>After praying to the gods and searching over every corner of the Internet
- [I]Polsaker>after heavily tampering with mysql Polsaker resorted to directly delete the database files
- [I]Polsaker>and so he successfuly exterminated the haunted soul of the sub_post table
- [I]Polsaker>"But I only wanted to change the character set!" he said as he laid crying on the ground, exhausted after half an hour of battling
- [I]Polsaker>"If I restore the database from a backup it will still have the old character set!"
- [I]Polsaker>and then, a light shone from the skies and the clouds parted. The flying spaghetti monster heard his prayers and enlightened him
- [I]Polsaker>"Just change the character set directly on the sql dump file and restore that"
- [I]pembo>>aka he got super lucky he made a backup
- [I]Polsaker>And so Phuks came back online and InnocentBystander could post comments with weird emojis
- [I]Polsaker>The End.
- [I]Polsaker>morale of the story: don't fuck with mysql character sets
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement