View Single Post
Old 10-14-2006, 01:32 AM  
teksonline
So Fucking Banned
 
Join Date: Jan 2005
Location: At My Desk
Posts: 2,904
you need database experience or a database admin to do these tasks for you, its a simple but multi-step proccess

connect to mysql client.. if you have shell access to server you can do something like

echo "SELECT field1, field2, field3, field4 FROM <tablename>"|mysql -u<username> -p <databasename> >filename.txt

this will put all those records into filename.txt, then load into spreadsheet selecting proper formatting, might be a space or tab, between fields, i forget
offhand

you need to include the primary key field in your selects so when your done you can use the following commands to re-import

UPDATE <tablename> SET field2 = 'blah', field3 = 'blah' field4='blah' WHERE field1 = 'ID'; based off a written script of some sort that is reading the text file line by line
teksonline is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote