Wikipedia:Reference desk/Computing#E-mail deluge

I received a mysql database dump. I need two tables from it, but I can't figure out how to import specific tables from an sql file. I installed mysql. I then used the command line to import the dump file. It ran all day and when I logged out at the end of the day, it stopped. I checked it and it did import a lot of data, but it didn't get ot the two tables I need before it died. I tried again. It ran all day and stopped when I had to log out at the end of the data. It didn't get to the two tables I need. I do not have the option to stay logged in after hours. Is there a way to tell it to import specific tables instead of the entire data dump? 68.187.174.155 (talk) 19:21, 16 June 2025 (UTC)

: With regard to terminal sessions remaining when you "log out", if you're running on Linux, you can run the terminal session under tmux. When you need to go home, you detach the session from the terminal with ctrl-b d (it's still running, it's not suspended). When you return the next day, tmux attach to reconnect to the terminal and see how it's doing. tmux also works on Windows Subsystem for Linux and MacOS.-- Finlay McWalter··–·Talk 19:56, 16 June 2025 (UTC)

: It's been a long time since I did it, but MySQL dump is just a text file with MySQL commands in it. Its content is mostly just CREATE TABLE commands followed by INSERT INTO commands (you'll find a comment that says "Dumping data for table `whatever`"). So what I've done in the past (if I remember right is):

:* open the file with less (less is very good at searching around in files that are larger than will fit into memory) and figure out which lines I want

:* extract only those sections using cut, into separate .sql files

:* throw only those new files at MySql.

: -- Finlay McWalter··–·Talk 20:04, 16 June 2025 (UTC)

::Thank you, but I was unable to do it. The tables are far too large. I took it to IT and someone there turned it into a CSV file. Even then, the tables I was using have around a billion records, so they filtered out just the rows I needed and gave it back to me as an Excel spreadsheet. 68.187.174.155 (talk) 10:02, 18 June 2025 (UTC)

= June 20 =

Simple question, I trusted a repair service run by an idiot who lost the internal speaker of my phone (resulting in the phone not emitting any sound). Where to purschase a replacement part ? 82.67.45.113 (talk) 19:37, 20 June 2025 (UTC)

:Surely the repair service should replace it. Shantavira|^{feed me} 06:56, 21 June 2025 (UTC)

::Replacing the whole phone is probably cheaper for them than getting a replacement speaker and installing it.  ​‑‑Lambiam 10:13, 21 June 2025 (UTC)

:::I don't know, I see the speaker for an A5 being advertised by [https://www.mi.com/in/service/sparepartsprice/ this parts supplier] for 99 rupees, which is only slightly more than a dollar.  Card Zero  (talk) 12:04, 21 June 2025 (UTC)

::::This "parts supplier" is Xiaomi.  ​‑‑Lambiam 06:03, 22 June 2025 (UTC)

:::::Silly me, so it is. It seems like only the Indian branch of their website has a user friendly list of parts. Other countries get directions to service centers.  Card Zero  (talk) 13:08, 22 June 2025 (UTC)

::::The speaker don’t fit in the phone. And no part is sold for the A3 2A01:E0A:ACF:90B0:0:0:A03F:E788 (talk) 04:07, 25 June 2025 (UTC)

:::More exactly about the repair service they damage more each time you ask them to correct their mistakes. So repairing elsewhere is required. 37.167.77.33 (talk) 10:54, 23 June 2025 (UTC)

::::If they can't fix it, they should be liable for at least the (probably) extra cost of having it repaired elsewhere.  ​‑‑Lambiam 15:05, 25 June 2025 (UTC)

= June 22 =

Do any CPUs exist that can use DRAM, but can also boot without it and use the last-level cache as the main memory instead? Do any BIOSes exist that boot in both modes depending on whether or not DRAM is actually installed? NeonMerlin 01:14, 22 June 2025 (UTC)

: Yes, modern x86-64 CPUs can be configured to use the cache as RAM. Before this, the boot-rom (that is, BIOS), had to enumerate the DRAM chips and set the memory controller up entirely using CPU registers (which is a fiddly business). Now it (well, now it's a UEFI-BIOS) can use cache-as-ram, and as the cache is so (comparatively) huge, it's a much easier environment. I saw a coreboot presentation about this a while ago (I can't find it now), but there's a coreboot blog about at: blog.aheymans.xyz/post/car {{nbsp}}{{nbsp}}{{nbsp}}url is blocked, as it's a blogging site -- Finlay McWalter··–·Talk 08:25, 22 June 2025 (UTC)

:: ... but there's not much one can do in this mode. coreboot just uses it to host its stack as it sets up the DRAM chips, and then it runs using stack (and I guess heap) in the DRAM as normal. I guess one could run a DRAM test suite in this mode (compared with Memtest86, which keeps its program code and some variables in the same DRAM it's testing), but with no video or other devices operational, it's very limited. I daresay some enterprising person could write some rudimentary code to bring up the PCI controller, xHCI, maybe the video controller (without using the option ROM in the video card) to provide a rudimentary no-DRAM environment. I can really only think that would be useful for memory testing, and it would be a lot of work. -- Finlay McWalter··–·Talk 16:28, 22 June 2025 (UTC)

= June 25 =

In My laptop the option for WiFi connection sometimes vanishes. I have 5G mobile hotspot with password. After the last windows update the icon vanishes and connection gets disconnected and I am not able to connect.

I restart the laptop and the option appears again.

screenshot 1- When the wifi option is there-- https://pbs.twimg.com/media/GuRDrgPWgAAqBW6?format=jpg&name=medium

screenshot 2- when the wifi option vanishes-- https://pbs.twimg.com/media/GuRDtBlXIAAsc5J?format=jpg&name=medium

During the screenshot 2 situation I dont know how to bring the wifi option back without restarting. Also why does it vanish? Grinthorse (talk) 05:50, 25 June 2025 (UTC)

= June 26 =

Does anyone know how to convert [https://www.fis-ski.com/DB/general/statistics.html?statistictype=positions&positionstype=multi-position§orcode=AL&seasoncode=&categorycode=WC&disciplinecode=&gendercode=&place=&competitornationcode=&position=2&positionsnumber=1 this table]

to view and work in Excel or LibreOffice Calc? I've tried copying and pasting, but it puts everything in a single vertical column, so I can't work with it.

Thanks. 46.114.161.131 (talk) 05:26, 26 June 2025 (UTC)

:I asked ChatGPT with the following prompt:

:could you please put all the entries on the table in this link in excel? https://www.fis-ski.com/DB/general/statistics.html?statistictype=positions&positionstype=multi-position§orcode=AL&seasoncode=&categorycode=WC&disciplinecode=&gendercode=&place=&competitornationcode=&position=2&positionsnumber=1 thanks!

:It gave me the top 10 in a csv format, so you could ask it for the full list. Rmvandijk (talk) 08:28, 26 June 2025 (UTC)

:Have you used Excel's data from web function? Under data, you should see something with a name similar to "Get and Transform Data." From there, you can select "From Web." Enter the URL of the web page. It will look for the table and import it into Excel for you. 68.187.174.155 (talk) 11:29, 26 June 2025 (UTC)

So I'm somewhat new to the server world, in that I've run servers before but this is my first true server (I've previously used desktop or even laptop PCs as servers). Firstly, any suggestions a brand or model? (I don't have a $500 budget for this project, however I would not be opposed to a used one). Secondly, anything (brand, model, style, etc) I should avoid? 143.223.148.17 (talk) 14:07, 26 June 2025 (UTC)

I am using Windows 11, and was using Chrome as a web browser until a few days ago. Then I couldn't launch Chrome either by clicking its icon or by clicking a link in an email. So I uninstalled it, and have been unable to reinstall it. All attempts that I make to install it using the on-line installer result in the stupid message, "No updates are available", or some other message. I have tried deleting the previous folders and repeating the install, and it doesn't help. At this point, I think that what I need is for someone who knows what they are doing to take control of my computer and complete the install. I have looked at Google's web site to see if there is a way to chat with a human, and all that I have found is chatbots that show me documentation that I have already seen. Are there any ideas for what to try next?

Robert McClenon (talk) 22:10, 26 June 2025 (UTC)

:Try one of Chrome's offline installers. https://support.google.com/chrome/answer/95346?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cwindows:~:text=Install%20Chrome%20offline{{pb}}Also, is there a particular reason you want to use Chrome instead of the Chrome-based Microsoft Edge or the independent Firefox? Aaron Liu (talk) 22:24, 26 June 2025 (UTC)

::To answer the second question, I would like my choice of web browsers, and have long used Firefox to edit Wikipedia (including for this inquiry). I downloaded ChromeStandaloneSetup64.exe, which has Chrome inside it. When I run it, it says it is initializing, and then it stops. Sometimes it says that there is already an instance of the setup process running. Using the Resource Manager, I don't see any zombie processes. What I would really like is a knowledgeable human to take over my computer and drive through the process. Am I to infer that Google has completely done away with human technical support? I know that I could call Best Buy technical support, but they would escalate me to second-level technical support, and I have never had a successful experience with Best Buy second-level technical support. (You don't want those details.) I had Chrome working for three years. Is there some known but non-obvious reason why the standalone installer doesn't work? I will try rerunning it after restarting my computer, but I don't want to restart my computer for a little while. Robert McClenon (talk) 23:51, 26 June 2025 (UTC)

:::You may be able to reset your computer to a restore point. However, restarting it is certainly worth trying first.-Gadfium (talk) 23:56, 26 June 2025 (UTC)

:::Can you try using https://www.nirsoft.net/utils/installed_packages_view.html to see if there is a leftover Chrome installation? If there is, the tool can show you a command to run that uninstalls it. Ian P. Tetriss (talk) 00:43, 27 June 2025 (UTC)

:Answering "is there a way to chat with a human": Most people are using the free Chrome web browser. It is free. You are not a customer. You did not purchase anything. Free products rarely come with any form of support. The license states clearly that the product is "as is." But, there is an enterprise Chrome web browser you can purchase. I assume it is the same web browser, but it comes with support. You are basically making a purchase to become a customer so you can get support.

:As for the main issue: I cannot install Chrome on my computer at work. We have a VPN that links all of our computers into a single network (I do not know the technical stuff). To install Chrome, our IT person has to first disable the VPN. Then, install Chrome. Then enable the VPN again. Of course, the entire process is normal Windows. Reboot. Download Chrome. Reboot. Disable VPN. Reboot. Install Chrome. Reboot. Enable VPN. Reboot. Then, reboot a couple more times just for good luck. 68.187.174.155 (talk) 12:08, 27 June 2025 (UTC)

= June 27 =