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 – Help, I lost the Root password! Error number 1045

By Prodromus September 7, 2010 Errors, MySQL No Comments
MySQL – Help, I lost the Root password!  Error number 1045

Have you ever seen the dreaded MySQL Error number 1045 Access denied for user ‘root’@’localhost’ (using password: YES)? Don’t worry, this is an easy to recover from situation. Just follow…

Read more

MySQL – Innodb Slow Shutdown – Dirty Buffer Pages

By Prodromus September 3, 2010 Innodb, MySQL, Optimization No Comments
MySQL – Innodb Slow Shutdown – Dirty Buffer Pages

If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…

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- Allowing Access to Root Remotely

By Prodromus August 19, 2010 MySQL No Comments
MySQL- Allowing Access to Root Remotely

MySQL includes all the basic methods needed to secure your user accounts.  However, the syntax and style used to manage it is often confusing to MySQL novices.  Here are a…

Read more

Show Processlist and Show Full Processlist – MySQL Tip

By Prodromus August 19, 2010 MySQL No Comments
Show Processlist and Show Full Processlist – MySQL Tip

Everyone knows that using the MySQL command Show Processlist will display all current connections, like the following : mysql> show processlist; show processlist; +—-+————-+—————–+——+———+——+———————————-+——————+ | Id | User | Host…

Read more

  • « Previous
  • MySQL – ORDER BY does not sort data properly…MySQL – ORDER BY does not sort data properly…
  • Rear Wheel Bearing R&R for the Datsun RoadsterRear Wheel Bearing R&R for the Datsun Roadster
  • Datsun 510 Front Grill StylesDatsun 510 Front Grill Styles

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