thanks for all the info. it really helps! elgene
----- Original Message ----- From: "Michael Chaney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Philippine Linux Users Group Mailing List" <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 1:30 PM Subject: Re: [plug] BACKUP ONLY FIELD ON MYSQL > On Mon, Aug 18, 2003 at 11:32:31PM +0800, Bopolissimus Platypus wrote: > > 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. > > Good advice, which I wanted to leave in even though I'm really replying > to the grandparent post. > > Don't do the two-stage select/mysqldump. Use this instead: > > mysql -uname -ppw -Ddbname -B -N -e 'select primary_key, field1, field2 from table;' >two_fields_backup.txt > > That'll put them into a tab-delimited format. If you want to know the > field names in the file, just drop the "-N" and the first row will > contain the field names. You can load it in later by using > > load data local infile 'two_fields_backup.txt' into table whatever ignore 1 rows; > > Of course, you'll have to specify columns and all that. If you don't > have the field names on the first row, omit the "ignore 1 rows" part. > > Michael > -- > Michael Darrin Chaney > [EMAIL PROTECTED] > http://www.michaelchaney.com/ > -- > 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.511 / Virus Database: 308 - Release Date: 8/18/2003 -- 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
