Category Archives: Technical

Upgrading MySQL Database Server on Mac

Download latest version from mysql.com (select the *.dmg) Stop MySQL Server:
  • sudo -i
  • cd /Library/LaunchDaemons
  • launchctl unload com.mysql.mysql.plist
  • Install the downloaded dmg file (double-click to start install) and follow the prompts. -Accept all defaults
  • mv /usr/local/mysql/data /usr/local/mysql/data.bak
  • cp -R /usr/local/<old_mysql>/data /usr/local/mysql/
  • cd /Library/LaunchDaemons/
  • launchctl load com.mysql.mysql.plist
  • cd /usr/local/mysql/bin/
  • /usr/local/mysql/bin/mysql_upgrade -P
    See expected output below
root # /usr/local/mysql/bin/mysql_upgrade -p
Enter password: 
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
ac.appl_account_types                             OK
ac.appl_address_types                             OK
.
.
.
OK

Installing mcrypt and libmcrypt

Why isn't a library like mcrypt installed out of the box by default?

I just spent all of Sunday, and half of Monday night installing "dependencies" for the mcrypt lib.

My woes began when I fired up the macbook pro to install phpmyadmin. I need to do some heavy lifting without spending too much on the command line in terminal.app

I will summarize the steps I followed to install and configure mcrypt to work with everything else on mac

Optimization Tips for WordPress Blogs

Disable and delete wordpress post revisions

Add this line to your wp-config.php file (in the wordpress installation directory):
define('WP_POST_REVISIONS', false);

Run the following SQL statement to delete all post revisions; -Remember to change the <PREFIX> to whatever prefix you use in your wordpress configuration.

STOP:
Remember to backup your database before making this update.

DELETE a, b, c
FROM <PREFIX>_posts a
LEFT JOIN <PREFIX>_term_relationships b
ON a.ID = b.object_id
LEFT JOIN <PREFIX>_postmeta c
ON a.ID = c.post_id
WHERE a.post_type = 'revision';

QuickBooks Business Planner Printing Fix

Because quickbooks now uses the QuickBooks PDF Creator the Intuit Internal Printer is not installed.
Unfortunately the code for Add-In programs were not rewritten to use this new printer.

The solution discussed in this article addresses the problem shown in the following graphic:
Printer Error

Workaround:
Install a copy of the Amyuni 2.07 PDF converter.

  1. Download the File "amyuni PDF 20.zip" from the following location.
    https://www.quickbase.com/up/99vtu7ey/g/rr/ei/va/amyuni pdf 20.zip
  2. Select to save the file to your computer. I suggest saving it to the Desktop so it can be found.
  3. Once the file has completed downloading Double Click on the file "amyuni PDF 20.zip"
  4. You will need to Unpack/Extract the file. Select the C:\ drive as the location to Extract to.
  5. Walk thru installing a printer
    1. Make it a Local Printer.
    2. Do NOT auto Detect the plug and play printer.
    3. use the port LPT1
    4. On the Printer Selection window Select Have Disk...
    5. In the install from disk window Select the Browse Button.
    6. Browse to the file\Location "C:\amyuni PDF 20\OEMsetup_20.inf" from Step 4 , Select that file and click Open.
    7. Click Ok on the install from disk screen.
    8. The printer PDF Compatible Printer Driver should now be listed in the add printer Wizard window click Next
    9. You will be prompted to name the printer.
      Use the following Name exactly:
      Intuit Internal Printer
    10. Do not Use the printer as the windows Default.
    11. There is no need to share this printer.
    12. Do not print a test Page.
    13. Click Finish,( If you receive an error saying the driver has not passed windows LOGO testing to verify its compatibility with Windows XP, click Continue.)
  6. Check the Windows printers list to make sure that the Intuit Internal Printer is Listed