Wikipedia:Reference desk/Computing#Problems using the wikipedia dump bz2 file

Welcome to the computing section
of the Wikipedia reference desk.
Select a section:
Want a faster answer?

Main page: Help searching Wikipedia

   

How can I get my question answered?

  • Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
  • Post your question to only one section, providing a short header that gives the topic of your question.
  • Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
  • Don't post personal contact information – it will be removed. Any answers will be provided here.
  • Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
  • Note:
    • We don't answer (and may remove) questions that require medical diagnosis or legal advice.
    • We don't answer requests for opinions, predictions or debate.
    • We don't do your homework for you, though we'll help you past the stuck point.
    • We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.



How do I answer a question?

Main page: Wikipedia:Reference desk/Guidelines

  • The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
See also:


June 16

[edit]

Mysql import specific tables from dump

[edit]

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)[reply]

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)[reply]
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)[reply]
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)[reply]


June 20

[edit]

Where to find an Internal speaker for Redmi A3 ?

[edit]

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)[reply]

Surely the repair service should replace it. Shantavira|feed me 06:56, 21 June 2025 (UTC)[reply]
Replacing the whole phone is probably cheaper for them than getting a replacement speaker and installing it.  ​‑‑Lambiam 10:13, 21 June 2025 (UTC)[reply]
I don't know, I see the speaker for an A5 being advertised by this parts supplier for 99 rupees, which is only slightly more than a dollar.  Card Zero  (talk) 12:04, 21 June 2025 (UTC)[reply]
This "parts supplier" is Xiaomi.  ​‑‑Lambiam 06:03, 22 June 2025 (UTC)[reply]
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)[reply]
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)[reply]
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)[reply]
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)[reply]

June 22

[edit]

DRAM-optional computing

[edit]

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)[reply]

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    url is blocked, as it's a blogging site -- Finlay McWalter··–·Talk 08:25, 22 June 2025 (UTC)[reply]
... 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)[reply]


June 25

[edit]

Windows 11 Home Single Language

[edit]

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)[reply]

June 26

[edit]

Convert a web table to Excel

[edit]

Does anyone know how to convert 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)[reply]

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&sectorcode=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)[reply]
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)[reply]

Upgrading conventional HDDs to SSDs in Dell PowerEdge R310

[edit]

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)[reply]

Can't reinstall Chrome

[edit]

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)[reply]

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
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)[reply]
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)[reply]
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)[reply]
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)[reply]

June 27

[edit]