elg3ne said: > hi guys, is there a way to backup a certain field on mysql? > > i have a db & there are lots of field inside & i only want to get 2 fields > on that db. > > thanks
try select field1, field2 into temp_table from the_big_table; then try mysqldump --tables temp_table the_database > two_fields_backup.dump just guessing, :) -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
