Connect to existing table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 2, 2015   (RSS)

By nmsinc - May 29, 2015

I had to delete and reload CMS Builder. I have two tables that I failed to backup prior to deleting and I would like to re-connect with these tables if possible. Ant attempt gives me a warring that the table already exists!

What is the best solution for this?

Thanks

nmsinc

nmsinc

By Dave - June 1, 2015

Hi nmsinc, 

Sure, the software doesn't do that, but try this:

  • First things first, backup your MySQL and CMSB
  • Next, say your missing section was called "news", create a section called "news2".
  • Erase every field except the num field
  • Copy the /data/schema/news2.ini.php file and save it as news.ini.php
  • "News" will now show up under Section Editors, click on it.
  • MySQL fields that don't exist in the schema will show as "(no field label)" and "none"
  • For each one, click modify, select text field (or other field type) and click save.
  • Erase news2 under Section Editors (you can do this last if you want)

Let me know if that works for you (or gets you closer).  

Good luck!

Dave Edis - Senior Developer
interactivetools.com