Car Repaint Project: Day 5 – Fine Sanding and Third Layer of Paint

I took Monday off.  I just didn’t feel like working on the car yesterday evening.

Before I log this day, let me note that it’s 12:30 am right now. I started the work at around 7:30 pm. So, it took me exactly 5 hours to finish.  If I learned one thing today it is that painting with heavier paint takes longer time.

I thought I had bought 800 grit, but I found that I had 600 grit instead. I used it to makes scratches all over the car.  It’s impossible to sand off the paint with it. Just rough up the car for easier reception of the third layer of paint.  I prepared the paint by just pouring more paint into the 40/60 can I had prepared before. It’s probably more like 1:5 ratio, maybe little too thick.

The paint definitely felt different this time. I wouldn’t say that it was easier to paint than using 40/60 paint, because it wasn’t, but there are some differences that sometimes made it easier. You can paint the whole panel for example, and then come back to brush over it.  If I understand it correctly, the paint is supposed to dry faster with more thinner, but I found that the heavier paint seemed to dry faster.  Anyhow, I guess it depends. I’m glad this is going to be the final layer, even though I’ve read that some people would put even more layer of paint from here.  I think three layers suffice for this type of work. Besides, I’ve gone farther than some of the write-ups I had read.  Anyway, here are photos after the third layer of paint was put on the car. I like it. I’m going to be spraying with clear coat tomorrow after work.

IMG_20160831_001520 IMG_20160831_001454 IMG_20160831_001435 IMG_20160831_001400 IMG_20160831_001543 IMG_20160831_001508

Car Repaint Project: Day 4 – Sanding and Second Layer of Paint

Today I spent about 4 hours after church sanding and putting on the second layer of paint. This time, I took time to sand using 400 grit, having learned from putting on the first layer. What I’ve learned is that paint don’t really stick well without enough sanding, especially on vertical pieces like the doors. Even with a good scratches from sanding it can be little frustrating, but it may have something to do with the amount of thinner I’ve added to the paint. Mine was nearly 40 thinner/60 paint, which really isn’t according to many recommendations I had read, including the one on the paint can itself, which recommends little or none.  Anyway, first two layers are supposed to be somewhat thin anyway, in order to speed the drying, and the last coat is supposed to be thicker.  I normally don’t praise the my own work, but after putting on the second coat I had impressed myself. It started to look like a decent paint job!  I’m now a firm believer in using Rust-Oleum. 😉  Of course, having done the work myself, I know all of the little inadequacies and places where there are too much paint or too little, but overall, it’s quite satisfying, albeit back-breaking. This ran into late evening hours, and I won’t get into details of little pesky bugs sticking on the paint and so on.  Just use your common sense if you’re following a similar procedure.

IMG_20160828_211522 IMG_20160828_211533  IMG_20160828_211631 IMG_20160828_211646 IMG_20160828_211707  IMG_20160828_191250  IMG_20160828_211610 IMG_20160828_211513

For a better comparison I should have taken some photos before the job, but I was merely thinking of blogging this as a type of record or a log.  Anyway, I had to rummage through my old photos to find this one (a stitched-up panoramic version) I had taken at Taos several years back.  You can see how the paint was coming off.



Car Repaint Project: Day 3 – First layer of paint

It must’ve taken up a good half of Saturday for this.  After taping and spraying the car with primer, and waiting for it to dry, I’ve applied the first layer of paint.  I had no previous experience of painting using form brushes, so I was little frustrated with how things looked and I even had some places where I accidentally squeeze the form causing bubbles to appear and then even vertical drips.  I’ve learned quite a bit on this first layer.

After spraying on the primer.

DSC03641 DSC03642 DSC03643

After the first layer of the paint.

IMG_20160827_145202 IMG_20160827_145122

Car Repaint Project: Day 1 – Sanding

Without much time or money on hand, I’ve decided to repaint my 2002 Nissan. It had a Molten Silver color for its exterior according to the spec doc, but the outer paint started to peel off about 10 years ago. The paint looked fine when I moved to New Mexico nearly 7 years ago though, but, now, the peeling paint has made the car look rather shabby to others. I’m not emotionally attached to the appearance of the car I drive, so it didn’t bother me that much.  In fact, I somewhat enjoy wearing and using things that has a look of being well-worn. I think my own pastor and I share a form of camaraderie for having the shabbiest looking cars at the church.  Anyway, my bumper decided to give recently, and when I bought a replacement it came in its raw, black color, and it needed to be painted. I felt that I might as well repaint the whole car while at it.

I heard from a coworker once that an excellent paint job may cost over a 1,000 bucks, and an average paint job typically costs around 300 to 500. I can’t afford that kind of money at the moment, and there are other expenses that are just waiting to move out of my checking account, so I googled the Internet to find a more frugal way and most of the recent answers seem to be around the use of Rust-Oleum enamel paint.  There are actually many guides and write-ups and I’m indebted to them all, especially Styluss, Craig Fitzgerald, and jtech87. I guess this may seem like yet-another-attempt at a write-up, but this is more as a logging purpose for me to keep track of my progress.  I can only allot 1 or less hour a day to this project, and usually it’s in evening.  I may be able to find little more time on the weekends.

Materials (matches Styluss’ preparation, but mine ended up being about 90 dollars total):

  • Rustoleum high gloss white paint – 1 gallon
  • Odorless mineral spirits – 1 gallon
  • Primer spray paint
  • 4″ High density foam brushes – x9
  • 2″ High density foam brushes – x8
  • Paint trays – x3
  • Sandpaper – 2 packs (400 & 800 grit)
  • Painter’s tape – 1 roll
  • Rustoleum clear coat
  • (optional) Car polish
  • (optional, but recommended) Paint mask, ear plugs or earphones, and goggle

The first draft of my plan (similar to jtech87’s) looks like this:

Subroutine M: Wet a rag with paint thinner (100% mineral spirit) and rub down.
Subroutine T:  Use tack cloth to wipe the surface.
Subroutine P: Paint surface.
Subroutine S(n): [Wet]sand with n grit paper.
Subroutine W(n): Wait at least n hours.

  1. Wear a paint mask, ear plugs (or earphones if you prefer), and a goggle if you don’t want paint particles entering your system in any significant amounts.
  2. Clean the car and do S(400), M, and T. Dust off
  3. Spray primer. W(6).
  4. Prepare paint solution (50% Rust-Oleum Glossy White / 50% thinner) and mix it well.
  5. Do P, and W(6).
  6. Do S(400) to get rid of at least 50% of the orange peel.
  7. Do M, T, P, and W(6).
  8. Repeat steps 6 and 7, and then jump to 9.
  9. Do S(800). Get at least 80% of the orange peel, but do not sand too deep.
  10. Prepare a slightly thicker paint solution (less thinner than last time). Use a new brush.
  11. Do M, T, P.
  12. Apply clear coat.
  13. Apply 2nd clear coat (assuming you’re rotating around the car, you can start at the beginning point on step 12).
  14. Do S(800 or higher).
  15. (optional) Apply polish.

I estimate about a week, but with only an hour a day, it may turn out to be longer. Anyway, here I go.

With some preparation time, I ended up with only about 30 minutes of time. In a scale of 1 to 10, where 10 is a thorough job of sanding, I’d probably give myself 5 on this one.  I managed to cover most of the car except for 3 doors.  I imagine I may be sanding for a whole week before I put anything on.

car-cutout-day-1IMG_20160825_234205 IMG_20160825_234215 IMG_20160825_234228

As you can see in the photo, there’s still much more sanding to do.  (Yawn) I need to sleep.

Copying MySQL databases on the same server

Last tested on Ubuntu 16.04.01 LTS (xenial) with MySQL Ver 14.14 Distrib 5.7.13

We had to make a copy of existing databases for development app instances.  For example, a database called xp_main was for the production and xpdev_main would be for development. This depends on how date strings were created, but if you have a lot of dates in the records you may want to turn off the NO_ZERO_DATE mode.  If you don’t turn it off, the copying process can be interrupted. Go into your MySQL console.

mysql> select @@sql_mode;
| @@sql_mode |

As you can see NO_ZERO_DATE exists.  Copy paste the entire string w/o NO_ZERO_DATE.

Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit

Next, we will copy the database using mysqldbcopy utility.  You may need to install mysql-utilities package if you don’t have it available.

$ mysqldbcopy --drop-first --source=root:mypassword@localhost --destination=root:mypassword@localhost xp_main:xpdev_main
WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
# Copying database eh_bcbs renamed as ehdev_bcbs
# Copying TABLE xp_main.accesses
# Copying TABLE xp_main.accessflags
# Copying TABLE xp_main.activities
# Copying TABLE xp_main.activitytype_items
# Copying TABLE xp_main.encounter_goals
# Copying TABLE xp_main.files
# Copying TABLE xp_main.tester1_intake_subseqvisit_goals
# Copying TABLE xp_main.tester1_game_careplan_goals
# Copying TABLE xp_main.localgames
# Copying TABLE xp_main.roles
# Copying GRANTS from xp_main
# Copying data for TABLE xp_main.accesses
# Copying data for TABLE xp_main.accessflags
# Copying data for TABLE xp_main.activities
# Copying data for TABLE xp_main.activitytype_items
# Copying data for TABLE xp_main.encounter_goals
# Copying data for TABLE xp_main.files
# Copying data for TABLE xp_main.tester1_intake_subseqvisit_goals
# Copying data for TABLE xp_main.tester1_game_careplan_goals
# Copying data for TABLE xp_main.localgames
# Copying data for TABLE xp_main.roles

That should do it!