Z-Car

Ramblings about everything from Cars to Computers

Z-Car
  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

MySQL – A simple script to truncate all MySQL tables in a Database

By Prodromus December 22, 2010 MySQL, Scripting No Comments
MySQL – A simple script to truncate all MySQL tables in a Database

Want a quick and dirty way to Truncate all the tables in a MySQL DB?  You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…

Read more

MySQL – Best way to remove all data from a table

By Prodromus November 22, 2010 MySQL, Scripting No Comments
MySQL – Best way to remove all data from a table

There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…

Read more

Top My.CNF Optimizations for Innodb

By Prodromus August 20, 2010 MySQL, Optimization No Comments
Top My.CNF Optimizations for Innodb

These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb.   If you are suffering from poor performance, try changing the…

Read more

MySQL – Should you put an index on a Boolean field to help query performance?

By Prodromus June 14, 2010 MySQL, Query Optimization 2 Comments
MySQL – Should you put an index on a Boolean field to help query performance?

I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance.  In general, because a boolean value can only…

Read more

MySQL – DateTime vs. TimeStamp – When to use?

By Prodromus June 12, 2010 MySQL, Optimization No Comments
MySQL – DateTime vs. TimeStamp – When to use?

This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…

Read more

MySQL – SQL Injection, and how to Prevent it

By Prodromus June 11, 2010 MySQL, Scripting No Comments
MySQL – SQL Injection, and how to Prevent it

SQL injection vulnerabilities are often been described as the most serious threat for Web applications, regardless of what language they are written in . Web applications that are vulnerable to…

Read more

  • « Previous
  • Republic P-47 ThunderboltRepublic P-47 Thunderbolt
  • How do you extract POST form data and file uploads in node.js?How do you extract POST form data and file uploads in node.js?
  • Database Admin Controller for Code Igniter and Ext JS 4Database Admin Controller for Code Igniter and Ext JS 4

Recent Posts

  • 2005 Laser Blue Lotus Elise for Sale
  • 2011 MacBook Pro GPU Failure – A software fix to disable GPU
  • Unable to renew using LetsEncrypt Certbot-Auto with CRON – Fail
  • Installing LetsEncrypt Certbot on Amazon Linux Server
  • Upgrade your Miata’s headlights with Hella H4 halogen bulbs, Cibie eCode projectors, and a relay kit.

Pages

  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

Recent Posts

  • 2005 Laser Blue Lotus Elise for Sale
  • 2011 MacBook Pro GPU Failure – A software fix to disable GPU
  • Unable to renew using LetsEncrypt Certbot-Auto with CRON – Fail
  • Installing LetsEncrypt Certbot on Amazon Linux Server
  • Upgrade your Miata’s headlights with Hella H4 halogen bulbs, Cibie eCode projectors, and a relay kit.

Chat with me Live!

Recent Comments

  • Phyllis Dorazio on GE Induction Cooktop – Control Lock Stuck ON
  • Chuck from PA on Toyota SDK8
  • Tony Mann on Toyota SDK8
  • James J. Fairbanks on Fairchild Republic A-10 Thunderbolt II “WartHog”
  • MyClock on Moen shower faucet provides no cold water, only hot

Categories

  • A-10 Thunderbolt II
  • Animals
  • B-17 Flying Fortress
  • B-25 Mitchell
  • Bell
  • Blogging
  • BMW
  • Boeing
  • Books
  • Cars
  • Chevy
  • Chrome
  • Chrysler
  • Corruption
  • Datsun
  • DIY
  • Electric Car
  • Electronics
  • Energy-Independence
  • Engines
  • Errors
  • Extjs
  • F-111 Aardvark
  • F-14 Tomcat
  • F-15
  • F-16 Fighting Falcon
  • F-20 Tigershark
  • F-22 Raptor
  • F-4 Phantom II
  • F/A-18
  • F6-F Hellcat
  • Fabrica Militar de Aviones
  • Fairchild Republic
  • Food
  • General Dynamics
  • Girls
  • Global Warming
  • GM
  • Green
  • Grumman
  • Honda
  • Humor
  • IA 58 Pucará
  • Infiniti
  • Innodb
  • JsonStore
  • Linux
  • Lion Electric Vehicles
  • Lockheed
  • Lockheed Martin
  • Lotus
  • MacBook Pro
  • Magazine
  • Mazda
  • McDonnell Douglas
  • Mercedes
  • Miata
  • Mongo DB
  • Movie
  • Museum
  • MySQL
  • Node.js
  • North American Aviation
  • Northrop
  • Oil Companies
  • Optimization
  • Other
  • P-38 Lightning
  • P-39 Airacobra
  • P-47
  • P-51 Mustang
  • Paleo
  • Past
  • PHP
  • Planes
  • Planes of Fame
  • Politics
  • Porsche
  • Primal
  • Pro Bono
  • Programming
  • Query Optimization
  • R/C Airplanes
  • Repair
  • Replication
  • Republic
  • Restore Backup
  • Rolls-Royce
  • RQ-170 Sentinel
  • Scam
  • Scripting
  • Security
  • SEO – Search Engine Optimization
  • Software
  • Solar
  • Stored Procedure
  • Tesla
  • Th!nk!
  • Theater
  • Tourism
  • Toyota
  • Toyota SDK8
  • Travel
  • Vacation
  • War
  • Web
  • Wings of Freedom
  • Wordpress
  • X-2
  • Zip Files

Copyright © 2023 Z-Car | Theme by: Theme Horse | Powered by: WordPress