I have been running cmsms since 1.x
Couple of month upgraded to 2.x OK
Today upgraded to 2.2.3.1 with some glitches.
Upgrade would not accept empty db_prefix, which was OK before.
OK, myPhpAdmin, I prefixed all tables with mysite_,
Upgrade went OK, but, nav menus are missing.
cache/debug.log shows the code refers explicitely to mysite_index_ in sql query.
I can rename that specific index but I would like to fix other as well without manually renaming each.
I would like to
1. dump data w/o meta
2. create new database
3. load data from 1)
Q: How do I create newly initialized database ?
How to create empty database ?
Re: How to create empty database ?
Did you try to clear the CMS cache?
this can probably solve the problem of the menu not working.
on how to do the export of your DB and the creating of your DB:
this can probably solve the problem of the menu not working.
on how to do the export of your DB and the creating of your DB:
- 1:export you can do with phpMyadmin https://youtu.be/ffmCGVse8yg
- 2: check with your hosting povider
- 3: importing with phpmyadmin: https://youtu.be/jW5lrS6EUPM
Last edited by HarmO on Mon Oct 16, 2017 5:01 pm, edited 1 time in total.
Kind regards,
HarmO
HarmO
Re: How to create empty database ?
> Did you try to clear the CMS cache?
> this can probably solve the problem of the menu not working.
the menu problem was caused by php code sql query referencing new index name whereas my db had old index name.
> this can probably solve the problem of the menu not working.
the menu problem was caused by php code sql query referencing new index name whereas my db had old index name.
Re: How to create empty database ?
that was a quick reply . i added some video's on the exporting and importing of your DB.
So problem solved?
So problem solved?
Kind regards,
HarmO
HarmO