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 11884 Oct 30, 1999, 10:42 AM
Post Re: editing field position
Alex 11743 Nov 1, 1999, 10:27 AM
Post Re: editing field position
widgetz 11755 Nov 1, 1999, 11:41 AM
Post Re: editing field position
pugdog 11751 Nov 1, 1999, 4:38 PM
Post Re: editing field position
widgetz 11745 Nov 2, 1999, 11:44 AM
Post Re: editing field position
Ground Zero 11744 Apr 3, 2000, 11:43 AM
Post Re: editing field position
pugdog 11754 Apr 3, 2000, 11:07 PM
Post Re: editing field position
pugdog 11764 Apr 4, 2000, 9:05 PM
Post Re: editing field position
Alex 11747 Apr 8, 2000, 8:50 AM
Post Re: editing field position
Ground Zero 11739 Apr 8, 2000, 3:23 PM
Post Re: editing field position
pugdog 11756 Apr 10, 2000, 8:56 PM
Post Re: editing field position
pugdog 11749 Apr 11, 2000, 9:00 AM
Post Re: editing field position
Alex 11735 Apr 17, 2000, 7:23 AM
Thread Re: editing field position
gotze 11752 Apr 17, 2000, 10:58 AM
Post Re: [gotze] editing field position
jgkiefer 11685 Dec 10, 2002, 12:26 PM