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

How to increase MySQL performance when loading a Dump File

By Prodromus August 19, 2010 MySQL, Restore Backup No Comments
How to increase MySQL performance when loading a Dump File

In MYSQL, as well as most database engines, restoring a backup, or importing from an existing dump file can take a long time depending on the number of indexes and…

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 – Restoring from a Dump Syntax

By Prodromus March 26, 2010 MySQL, Restore Backup No Comments
MySQL – Restoring from a Dump Syntax

Here’s how to pass the arguments to MySQL to restore from a Dump: mysql [database name] < [backup file name] The “[database name]” specifies the name of the database to…

Read more

  • Lotus Elise – Wiper BladesLotus Elise – Wiper Blades
  • Simple DIY Lotus Elise Front License Plate BracketSimple DIY Lotus Elise Front License Plate Bracket
  • MySQL – Best way to speed up Slave replicationMySQL – Best way to speed up Slave replication

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

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