I have a world that has just transitioned into hard-mode. Stripes of Hallow and Corruption have both appeared in the world (as I expected), but the Hallow appeared right in the middle of my jungle biome (it even surrounds the Jungle Temple!).  Will the Hallow eventually destroy the jungle? I'm concerned that I won't be able to fight Plantera if it takes over the underground jungle quickly enough.
Once a world enters hardmode, corruption and hallows being spreading at an alarming rate, including the underground. Grass, which grows on dirt, succumbs easily to both. Jungles and glowing mushrooms grow on mud and provide unique and valuable items. Will corruption/hallows destroy these if left unchecked? If they do destroy mud-based life, how can I preserve these fragile ecosystems?
Restoring MySQL database from physical files Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types:  client.frm client.MYD client.MYI    but for about 20 more tables.  I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files? I just discovered an incredibly annoying "feature" of Windows 7 tonight.  If you click on your optical drive in Explorer, and there is no disc in the drive, Windows 7 is kind enough to open the tray for you.  I'm finding it hard to contain my rage over this idiotic design decision.  WTF?  According to , this behavior was apparently introduced in Vista.  The author posted a workaround, but I don't want a workaround.  I want it to stop doing this.  Like he, I have a case with a door that covers the drive bays.  If it's closed, and I accidentally click on that optical drive, it knocks on that door 10 or 12 times before giving up.  Can this behavior be turned off in Windows 7? Graph Proof by induction. Can you prove via induction that there exists a node in a directed graph of n nodes that can be reached in at most two edges from every other node in the graph. Every node in the graph is required to have an edge with every other node that either points out or in (For every pair of nodes X and Y, either X points to Y or Y points to X). How to identify cells in Column A that contain any of the values in Column B First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.  My question is very similar to  except that A) the answers there didn't work for me, and B) even if it did, it's not quite the correct output I need.   Basically, I have 2 columns. Column A contains URLs (16388 rows). Column B contains URL slugs (202 rows).   I want to search to see if any of the values in column B are contained within any of the values of Column A. If they are, I want to return the value TRUE in column C.   From what I've read, VLOOKUP ought to work for this, but for the life of me I can't get it to work. I also tried in the answers in the link above that use COUNTIF and MATCH, but in both of those cases, all I got were FALSE returns, when I know that there are values in Column B that are contained in a URL in Column A.   Does that make sense?  EDIT: Both answers are providing results (thank you!), but I suspect I may not have asked the question correctly. In both of the answers, I'm getting TRUE results, but it looks like the TRUE is correlating to the slug in Column B rather than the URL in Column A. Let me put it this way:  I'll move the slugs from Column B to C so that B can be used for the TRUE responses. What I want the fomula to do is:   Look at URL in A1 Are any of the values in Column C contained within the URL in A1? If yes, then return TRUE in B1. If FALSE, leave it blank.    So I will be able to see which of the URLs contain the slugs I am searching for. I apologize for not being clearer in my original ask (though I feel like it's only a slight tweak from the answers I've already been given.) I have used the websites of SO a lot the past few months because I am busy with a large scale web project. I feel I get better answers here on SO than when I just do a Google search, maybe because I can be more specific here with my problem, and the responses are really fast.  Occasionally when I am not working I try to answer some questions, but the question almost always has an answer which is 'as good as' or 'better' than the answer I would supply.  So my question/answer ratio is about 20/1 something, if not more. When I look at my profile page I see a bucket-load of questions and almost nothing I answered myself.  Is this considered bad behaviour? I can see that this looks a little egoistic.  : One devoted to one's own interests and advancement. I just did a clean install of 20.04 and I noticed that no key shortcuts for files manipulation work when my focus in on Desktop (not in Nautilus).   When I have copied a file to clipboard, I cannot Ctrl+V it to Desktop, when I click on a file on Desktop, I cannot Ctrl+C it, or I cannot Delete it with keys. Only ways to do it is either navigate to the Desktop folder in Nautilus, or right-click the file on the Desktop and copy/move to trash/paste...  Sorry if I'm missing something obvious, all the key shortcuts worked normally for me in 18.04. Why is using a wild card with a Java import statement bad? It is much more convenient and cleaner to use a single statement like  import java.awt.*;   than to import a bunch of individual classes  import java.awt.Panel; import java.awt.Graphics; import java.awt.Canvas; ...   What is wrong with using a wildcard in the import statement? I am using App Backup &amp; Restore for creating backup of my apps but with KitKat its using the internal SdCard as Storage.  When I explicitly set the external SdCard path it gives the error that it is unable to create folder,  I have also tried with creating folder under android/data/[packagename]/files/ but it is still not able to do the same.  Is there any solution so that apps can use external storage for writing files.  Note : I don't want to ROOT my Phone. Group With an Endomorphism That is "Almost" Abelian is Abelian. Suppose a finite group has the property that for every $x, y$, it follows that   \begin{equation*} (xy)^3 = x^3 y^3. \end{equation*}  How do you prove that it is abelian?    Edit: I recall that the correct exercise needed in addition that the order of the group is not divisible by 3. How to make text file created in Ubuntu compatible with Windows Notepad? Sometime I have to use the text files created in Ubuntu, using editors, in Windows editors. So basically when ever I create a text file in Ubuntu I append the extension .txt, and it does make the file open in Windows very easily.  But the actual problem is the text files created in Ubuntu are so difficult to understand (read) when opened in Windows' Notepad. No matter how many lines have been used, all the lines appear in the same one line.  Is there a easy way to save the text files in Ubuntu's basic editors so that it can be seen exactly the same in Windows' notepad? SD Card showing weird file names and files are lost I just plugged my SD Card to my PC after a long videography day, and I suddenly got this problem:    It is also not showing all the videos I took on my camera so what is the solution? Don't exclude results that have punctuation just because the query doesn't The new search function allows quoted queries that include punctuation, and this is fantastic, most of the time. However, the search considers the punctuation as part of the word itself, so searches for "a test" will not show results containing a test,, a test., or a test?. The reverse is also true.  Is this the intended behavior ? &lt;--(space added so that behavior will show in results.)  It seems that the logical way to do fix this (while maintaining character search) is for queries with punctuation to match results with punctuation, while queries without punctuation to match either with and without.    Example:  vs     A more practical example is described in Arjan's answer below. Hide some fields in the NewForm.aspx for a custom list Why didn't Gimli know Moria had fallen? How do I make a 2D game resolution independent? Can I estimate remaining battery life by measuring its voltage with the same MCU that it powers? I'd like to estimate the remaining battery life of a battery that powers a microcontroller. Could I accomplish this by simply leading the battery into the MCU's built-in ADC?  My idea is that I could plot the voltage over time to figure out how much battery life remains. But would the change in voltage be noticeable? And would it be a problem that the same battery powers the MCU (and ADC)? Is there any difference between the usage of 'later' and 'later on'?         I'll see you later.   I'll finish it later on. I would like to know if anyone can help me with installing Ubuntu on VirtualBox Functions that are their own inverse. What are the functions that are their own inverse?  (thus functions where $ f(f(x)) = x $ for a large domain)  I always thought there were only 4:  $f(x) = x , f(x) = -x , f(x) = \frac {1}{x} $ and $ f(x) = \frac {-1}{x} $   Later I heard about a fifth one     $$f(x) = \ln\left(\frac {e^x+1}{e^x-1}\right) $$ (for $x &gt; 0$)  This made me wonder are there more? What are conditions that apply to all these functions to get more, etc. What's the 1 inch square knob sticking out of the wall?