Technology Errors

phpMyAdmin: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

When attempting to import a gzip sql file into MySQL via phpMyAdmin I continued to get the error below. There are a couple ways to get around this issue which depend on if you have access to the server or not. Below I will describe two ways to resolve the error if you have access to the server and two ways to resolve the issue if you do not have access to the server.

Error: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

Details
Technology Insights

phpMyAdmin: During SQL Imports What Does kKiB Mean, How to Modify Max File Import Size

Recently I had to import some files via phpMyAdmin because the web host of my client didn’t allow SSH access to the server or direct access to the MySQL command line. The need was to create a database and restore a previous backup from another database into MySQL. I noticed that on the Import screen there were a couple things I was curious about. First what kKiB meant and if I wanted to how would I change the max size file I could import.

What does kKiB Mean?

Details
Technology Insights

Create a SVN Repository, Then Import a SVN Repo Into The New SVN Repo

The below describes creating a SVN repository from a CentOS Linux shell followed by importing a SVN repository dump into the newly created repository. This can be useful for many reasons including moving servers or even just moving the location of an SVN repo.

If you don’t have subversion installed go ahead and do so now. The below command can be issued from the shell of a CentOS Linux server using yum to install subversion.

Details
Technology Insights

Use Microsoft Excel to Populate Cells on a Second Worksheet in the Same Workbook

If you have an Microsoft Excel workbook with multiple worksheets that contain similar type data it may save you a lot of time to auto populate the other worksheets with the similar data. In my scenario I had a form used to obtain information about customers which needed to be in a certain format but then I had two other forms that had some of the same data that needed to be provided to other departments. So the initial process was to fill out each individual form by hand and send to the proper department. To save time I wanted to auto populate as many like fields as possible.

The resolution ended up being really simple. First I just added the other forms to the workbook of the primary form. This ensured that when I opened up the form to enter customer data that the other two forms were open with t. Once I had added the worksheets and named each one properly I started messing around with formulas to complete the task of copying one cell from the primary worksheet to cells on the second and third worksheets in this workbook.

Details