Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
13
Newest
 Talkative
Impact
~2k people reached

1d
awarded  Talkative
2d
awarded  Popular Question
Sep
9
awarded  Popular Question
Sep
8
revised When will Cent OS delete empty dirs in /tmp?
added 792 characters in body
Sep
8
asked When will Cent OS delete empty dirs in /tmp?
Jul
16
revised How can I delete the 5th word of every line in a file?
Turned off syntax highlighting on non-code block. Tidied grammar.
Jul
16
suggested approved edit on How can I delete the 5th word of every line in a file?
Jul
9
comment How can I fully remove a tablespace from MySQL?
Added attempt, @datUser. It's possible that the previous table, removed with DROP TABLE IF EXISTS, was MyISAM, not InnoDB. I'm not certain. Might that make a difference?
Jul
9
revised How can I fully remove a tablespace from MySQL?
added 2017 characters in body
Jul
9
comment How can I fully remove a tablespace from MySQL?
I'm actually perfectly willing to throw away everything. Anything important is backed up. I can delete all the tables and all the databases and reinstall MySQL if it'll help.
Jul
9
comment How can I fully remove a tablespace from MySQL?
Today, camera_main_live is working fine, but test is broken. Pasted the DROP TABLE and CREATE TABLE commands onto a mysql> prompt: same result. @datUser.
Jul
8
comment How can I fully remove a tablespace from MySQL?
Have done so, and updated, @Interesting.
Jul
8
revised How can I fully remove a tablespace from MySQL?
deleted 5 characters in body
Jul
8
revised How can I fully remove a tablespace from MySQL?
added 1320 characters in body
Jul
8
comment How can I fully remove a tablespace from MySQL?
Nope. Worked on camera_main_live, but not on test2.
Jul
8
comment How can I fully remove a tablespace from MySQL?
That worked, for now. Maybe that'll be it. Still not sure why this problem happened in the first place.
Jul
8
comment How can I fully remove a tablespace from MySQL?
Ah. Just noticed your first comment. Shall try emptying the database by hand and then restarting MySQL.
Jul
8
comment How can I fully remove a tablespace from MySQL?
I reported earlier that camera_main_live had fixed itself. However, when I tried running that original query again, it dropped the table, as expected, but failed to recreate it. So apparently camera_main_live has broken itself again. Gah! Anyway, the information you requested from information_schema is now in place.
Jul
8
revised How can I fully remove a tablespace from MySQL?
added 2365 characters in body
Jul
6
revised What is so special about Linux permission 004?
Transitive and intransitive verbs. They're a thing.