I do not use mysql but postgresql. I would try the following: * using the database backend export the table to a csv-file * drop the table in the database backend. * remove the table's entry in applications/yourapp/databases (be careful to delete the correct file). Maybe move it to another temporary location to be save. * do a 'python web2py.py -M -S application/[your controller] on the commandline or run appadmin. * check whether the table creation was successful * adapt the csv-file to your new format. The easiest way for me is to export the new empty table to get the correct headings. Then, if it is not too large for a program like localc/oocalc/gnumeric/excel you can use a spreadsheet program to combine the two csv-files. Otherwise you can do it using sed and awk. * import the adapted csv-file.
Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
