Wikipedia:Reference desk/Computing#Downloading MediaWiki for home use

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)

: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)

= June 16 =

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)