On Monday 18 August 2003 19:10, Winelfred G. Pasamba wrote: > select field1, field2 into temp_table from the_big_table; > > then try > mysqldump --tables temp_table the_database > two_fields_backup.dump
include the primary key and any important relational keys in the select though. you might need to restore later and if you don't have those relational keys... well, you wouldn't be able to restore from the backup. tiger -- Gerald Timothy Quimpo gquimpo*hotmail.com tiger*sni*ph http://bopolissimus.sni.ph Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78" I'm so miserable without you, it's almost like you're here. -- 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
