Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: editing field position

Quote Reply
Re: editing field position In reply to
Here's another way to do it using mysqldump utility:

mysqldump --add-drop-table -c -uUSERNAME -pPASSWORD YOURDB Links > yourdb.txt

This will dump the contents of the Links table into a file called yourdb.txt. You can then edit the file and change the order of fields by editing the create table statement (should just be a matter of cut and paste some rows into different order).

Then just do a:

mysql -uUSERNAME -pPASSWORD YOURDB < yourdb.txt

and it will do the changes. You should then do a re-sync in the admin and you are set.

Cheers,

Alex
Subject Author Views Date
Thread editing field position widgetz 16618 Oct 30, 1999, 10:42 AM
Post Re: editing field position
Alex 16349 Nov 1, 1999, 10:27 AM
Post Re: editing field position
widgetz 16359 Nov 1, 1999, 11:41 AM
Post Re: editing field position
pugdog 16356 Nov 1, 1999, 4:38 PM
Post Re: editing field position
widgetz 16356 Nov 2, 1999, 11:44 AM
Post Re: editing field position
Ground Zero 16351 Apr 3, 2000, 11:43 AM
Post Re: editing field position
pugdog 16363 Apr 3, 2000, 11:07 PM
Post Re: editing field position
pugdog 16378 Apr 4, 2000, 9:05 PM
Post Re: editing field position
Alex 16360 Apr 8, 2000, 8:50 AM
Post Re: editing field position
Ground Zero 16362 Apr 8, 2000, 3:23 PM
Post Re: editing field position
pugdog 16364 Apr 10, 2000, 8:56 PM
Post Re: editing field position
pugdog 16359 Apr 11, 2000, 9:00 AM
Post Re: editing field position
Alex 16344 Apr 17, 2000, 7:23 AM
Thread Re: editing field position
gotze 16376 Apr 17, 2000, 10:58 AM
Post Re: [gotze] editing field position
jgkiefer 16291 Dec 10, 2002, 12:26 PM