Recently I tried importing a 1.2GB SQL dump file and Navicat kept immediately timing out with: [Err] 2006 – MySQL server has gone away Eventually, I was able to the entire file (6 million records worth) to import by unchecking* the “Run multiple queries in each execution” option before starting the import process. After this, the process completed perfectly! *normally I always uncheck that box, but for some reason this time I forgot to uncheck it on my first attempt.
Author Archives: J.D. H.
Last updated: April 28th, 2020 The iPad was first introduced in 2010 without a camera. Since then, the capabilities and models of the iPad family have steadily expanded. In this time of physical/social distancing and teleconferencing via a myriad of apps (Zoom, Skype, Facebook Messenger, WhatsApp, Facetime, etc.), camera quality has become even more important. Unfortunately, it can be hard to keep track of the camera changes over the iPad line after so many years. Therefore, I compiled a handy
A client recently reached out to me with the following problem: When importing a large (72MB) CSV document, Excel reports “file not loaded completely”. 🙁 Sure enough, data is missing. Can you help me? This issue is caused by Excel only supporting ~1,048,576 rows in a CSV file. In the client’s instance, there were around 1.6 million records. Thankfully, for Excel’s limitation, there is a relatively simple workaround: Open the CSV file in a text editor that supports large file
Summary: sometimes a PC or tablet may be stuck in the wrong screen orientation when you log in via TeamViewer or other remote software. Solution: Turn rotation lock ON Rotate via the “orientation setting” Apply settings and you are done! Details: Recently I had to do some work for a client via TeamViewer. While that is normal, the ruggedized tablet that I was logging into was a little out of the usual. Specifically, the tiny tablet was running Windows 10
Question. Does Quicken support online transaction download for Marcus by Goldman Sachs? Answer. Yes, Quicken supports automatic downloads of your Marcus transactions (interest, deposits, etc.). When you add an account, simply enter “marcus” in the financial institution search field and it will be the first result! You can see a screenshot here: I hope this helps! 🙂
Recently I received an unusual JPEG for a work project. The resolution was fairly low (1344×576) and the document resolution was also set to a relatively low screen resolution of 72dpi: Normally I would anticipate this file being less than 1MB. However, it was over 10MB! Copy and pasting the image content into a blank Photoshop file and saving as a JPEG also resulted in a 10MB file size. Even using a very high compression level (and thus reducing the
Recently my wife unable to save photos after editing them in Google Photos. Specifically, the Google Photos app would crash immediately upon trying to save edits and this issue was occurring on a Samsung Note 10+. Checking with some friends, they were having similar issues on their S10 phones. After trying a number of adjustments (restarting, clearing cache, clearing data) I finally realized that the issue was due to motion photos. Specifically, during a recent software update, it seems that
Q.How can I copy the pictures stored in the internal memory on my FujiFilm FinePix HS 50 EXR (or similar) to memory (SD) cards? Answer: The procedure to copy the pictures in the internal memory to a memory card is as follows: After copying, the pictures will remain in internal memory. Delete them if necessary. 1. Install a memory card into the camera. 2. Press the playback button to enter playback mode. 3. Press the MENU/OK button to open the