You've made quite a mess, starting with the formatting of your question (see what I've done above which should make things below more clear).

First problem:
If you have a semicolon (;) or a "continue-on-success (&&) you are running two separate sets of commands.
Completely separate. It's like you ran one, hit enter and then ran the other.
This means your second awk is looking on stdin for input, and not finding anything it's giving you no output (which is why file2 is empty)

Second Problem:
Separate instances of awk can't share variables. Either you want the second awk to chew on the output of the MySQL query, or you want it to chew on the output of the first awk.
Since you've got 5 variables in your second awk I'm assuming the latter.

Solution
Run the first half of the command list (everything up to the semicolon).
Now run the second awk, and specify an input file (awk '{print $1":"$5":13753:0:99999:7:::"}' /tmp/file1 >> /tmp/file2).

Thank you! Sorry for the messy question, was in a bit of hurry when I wrote it, Ive think about it next time!
–
ApazOct 19 '11 at 8:26

No worries - That was more a "If you format your commands so they're pretty sometimes the answer jumps out" note than a "your question is ugly so I'm going to beat you with a dirty sock" one :-)
–
voretaq7♦Oct 19 '11 at 15:24