How to create empty database ?

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
booo9
Forum Members
Forum Members
Posts: 20
Joined: Tue Jan 01, 2013 8:26 pm

How to create empty database ?

Post by booo9 »

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 ?
HarmO
Power Poster
Power Poster
Posts: 251
Joined: Thu Jan 26, 2012 3:22 pm
Location: Belgium

Re: How to create empty database ?

Post by HarmO »

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:
Last edited by HarmO on Mon Oct 16, 2017 5:01 pm, edited 1 time in total.
Kind regards,
HarmO
booo9
Forum Members
Forum Members
Posts: 20
Joined: Tue Jan 01, 2013 8:26 pm

Re: How to create empty database ?

Post by booo9 »

> 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.
HarmO
Power Poster
Power Poster
Posts: 251
Joined: Thu Jan 26, 2012 3:22 pm
Location: Belgium

Re: How to create empty database ?

Post by HarmO »

that was a quick reply :-). i added some video's on the exporting and importing of your DB.

So problem solved?
Kind regards,
HarmO
booo9
Forum Members
Forum Members
Posts: 20
Joined: Tue Jan 01, 2013 8:26 pm

Re: How to create empty database ?

Post by booo9 »

> So problem solved?

viewtopic.php?f=3&t=77270
Post Reply

Return to “The Lounge”