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
interactivetools.com