Sympa MySQL changes mean upgrades are difficult

Heya again I've found that my previous question RE moving Sympa can be partially fixed. I've found that on the new server running the sympa --upgrade will set things ready to go but still have no subscriber data. If I then manually dump the entries from the MySQL database (subscribers_table) on the old Sympa server to the new in the right place, and then go to the column created which didn't exist on the old server (robot_subscriber) and add the proper robot details relating to the new server, the subscriber will attach as it's supposed to! I've been using phpmyadmin to browse the tables and check out the structure as I'm really not that much of a MySQL admin, so does anyone know what I could use to change the contents of every single entry for "robot_subscriber" in the table "subscriber_table" in the database "sympa" ? Also this raises another question - why is grabbing a subscriber list so difficult? To me it would be a vital thing to be able to dump this list in whatever format you'd like for easy backups and fail safe restoration. Sometimes these lists can be thousands of entries! Any help is very much appreciated Jesse

On Thu, 12 Jan 2012 17:53:03 +1100, Jesse Stevens <noodlepringle@gmail.com> wrote:
I've been using phpmyadmin to browse the tables and check out the structure as I'm really not that much of a MySQL admin, so does anyone know what I could use to change the contents of every single entry for "robot_subscriber" in the table "subscriber_table" in the database "sympa" ?
$ mysql sympa mysql> UPDATE substriber_table SET robot_subscriber=FOO;
Also this raises another question - why is grabbing a subscriber list so difficult? To me it would be a vital thing to be able to dump this list in whatever format you'd like for easy backups and fail safe restoration. Sometimes these lists can be thousands of entries!
worst case scenario... check out SELECT INTO OUTFILE -- Stewart Smith

On Thu, Jan 12, 2012 at 6:30 PM, Stewart Smith <stewart@flamingspork.com> wrote:
On Thu, 12 Jan 2012 17:53:03 +1100, Jesse Stevens <noodlepringle@gmail.com> wrote:
I've been using phpmyadmin to browse the tables and check out the structure as I'm really not that much of a MySQL admin, so does anyone know what I could use to change the contents of every single entry for "robot_subscriber" in the table "subscriber_table" in the database "sympa" ?
$ mysql sympa mysql> UPDATE substriber_table SET robot_subscriber=FOO;
Also this raises another question - why is grabbing a subscriber list so difficult? To me it would be a vital thing to be able to dump this list in whatever format you'd like for easy backups and fail safe restoration. Sometimes these lists can be thousands of entries!
worst case scenario... check out SELECT INTO OUTFILE
-- Stewart Smith
Thanks Stewart - did the trick - all is good in the mailing list world.. Jesse
participants (2)
-
Jesse Stevens
-
Stewart Smith