Welcome to the computing section
of the Wikipedia reference desk.

Select a section:

WP:RD/C

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.

Ready? Ask a new question!

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.

June 12

Ability to “sync further” from iPad after I sync from iCloud

I just lost my iPhone. I’ve ordered a new one which has just arrived.

Unfortunately, iCloud stopped syncing maybe a year and a half ago (I never paid for the upgrade once I reach the data limit).

I also have an iPad that was syncing with my lost iPhone, and so is much more up-to-date than the iCloud will be. But of course, an iPad doesn’t have all the same features as an iphone,

Given this, I was thinking that I would first sync my new iPhone from iCloud, to achieve I guess the state it was in a year and a half ago.

Once I’m done with that. I was hoping to “sync further” from the iPad—-in an attempt to make my new iphone as close as possible with the state my lost phone was in.

However, I have no idea how this can be done. Once I finish syncing with iCloud, how would I go about then syncing further from my iPad? Can anyone give me some guidance on this? Thanks— 2600:4040:9103:5000:7525:BC03:25D0:5326 (talk) 02:41, 12 June 2025 (UTC)[reply]

Just sync from the last backup your phone and then sync the items you want from iPad without pulling the iPad's backup, if any. Only the synced items would be overwritten. Aaron Liu (talk) 12:31, 12 June 2025 (UTC)[reply]

June 16

Mysql import specific tables from dump

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

Where to find an Internal speaker for Redmi A3 ?

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

DRAM-optional computing

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? Neon Merlin 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

Windows 11 Home Single Language

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

Convert a web table to Excel

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]