Mysqldump only certain fields of a table
The trick here is to not use mysqldump
[code]mysql -u root -p -e “SELECT `field_01` AS ‘new_name_01`,`field_02` as `new_name_02` FROM database.schema” -X > /tmp/output.xml[/code]
And to load it back into the new table which exists and has the fields new_name_01 & new_name_02:
[code]mysql -u root -p –local-infile -e “LOAD XML LOCAL INFILE ‘/tmp/output.xml’ INTO TABLE database.new_schema ROWS IDENTIFIED BY ‘<row>’;”[/code]
Doomsday Preppers caters to opposing audiences
X-Factor: your ability to pack explosives into dead racoons will be a valuable asset when the city folks come steal your shit.
Cool Duplo Project #14 – Train Induced Weight Shifting Train Track
[mejsvideo mp4=”http://ben.akrin.com/videos/IMG_5040.MOV.mp4″ ogg=”http://ben.akrin.com/videos/IMG_5040.MOV.ogv” webm=”http://ben.akrin.com/videos/IMG_5040.MOV.webm” poster=”http://ben.akrin.com/videos/IMG_5040.MOV.jpg” width=”640″ height=”360″]
Cool Duplo Project #13 – Boat
Protected: Cool Duplo Project #12 – Big Rig
Protected: Cool Duplo Project #11 – Raised Platform
Cool Duplo Project #10 – Falling Dominoes
[mejsvideo mp4=”http://ben.akrin.com/videos/IMG_5031.MOV.mp4″ ogg=”http://ben.akrin.com/videos/IMG_5031.MOV.ogv” webm=”http://ben.akrin.com/videos/IMG_5031.MOV.webm” poster=”http://ben.akrin.com/videos/IMG_5031.MOV.jpg” width=”640″ height=”360″]
Protected: Cool Duplo Project #09 – Reverse Center of Mass Spinning Top
Cool Duplo Project #08 – Robots
Waldo
Fat Head
Mechwarrior
Pincher
Nanobot
Macrobot
