Author Archives: J.D. H.

MySQL Server has gone away when importing large sqlfile [Navicat, SOLVED]

Leave a comment

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.

Read more Software Tips, Work

Best iPad for video meetings – ALL iPad camera specs LIST Video Conferencing & Photography

Leave a comment

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

Read more computer tips, iOS, photography, Work

How to fix Microsoft Excel’s “File not loaded completely” error message [SOLVED]

2 comments

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

Read more Uncategorized

Rotate a tablet screen when using TeamViewer or remote work software

Leave a comment

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

Read more computer tips, Networking, Off the Grid, tech tips

Photoshop JPG file sizes are way too BIG!

Leave a comment

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

Read more computer tips, Work

Google Photos crashes when saving edits on Samsung Note 10 (S10, S9, S8) [SOLVED]

Leave a comment

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

Read more Android tips, camera tips, photography, Software Tips

Q. How can I copy photos from internal memory/storage to SD card?! [SOLVED] Fuji

4 comments

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

Read more Cameras, Gadgets and Tech, photography