how to copy database records of one table section to another table section?

Hi Ragi

The issue with that is likely because of the colon in the label text. There is no actual column called 'top_menu:text' in the table itself - that's a generated field.

Personally I just wouldn't transfer the data through PHP. I use MySQL Workbench and straightforward queries to copy and move data around, if only because there's far less of a chance of data corruption.

Claire:  I usually use phpmyadmin but got a bit confused with the CMSB data structure.  Did it change drastically when you moved to CMSB 2.5+ ?

Not as far as I know. I'll ask Dave, just in case.

Transferring data between two tables seems to be very tricky in CMSB anyway, due to how variable the data structure can be outside of the core tables.

Hi Guys, 

There's no support for copying a table to another table in CMSB because it's not something you'd normally need to do, but you could do it like this (using a section called "widgets" as an example):

• Admin > Sections Editors > Add New Editor > Copy Existing Section > widgets > Save as New Table/Menu Name: widgets2
• Admin > General Settings > Backup & Restore > Backup Table > widgets
• Rename backup file from: /cmsb/data/backups/[domain]-[date]-widgets.sql.php to [domain]-[date]-widgets2.sql.php
• Edit [domain]-[date]-widgets2.sql.php and replace "widgets" with "widgets2"
• Admin > General Settings > Backup & Restore > Restore Table > widgets2

Note that uploads won't copy over properly, but you'll get all the MySQL data.

Hope that helps!