Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » What is in the db and what is not?
 
Thread actions
Print this page
  • Print all pages

    • What is in the db and what is not?

    Posted by G.M. Knowles posts: 13 United States

    Can someone explain what, to me, appears to be a discrency?

    According to what I have gathered through hours and hours of reading and more hours of breaking stuff, is this:

    1. That "all" information is safed in the database unless you specify otherwise.
    2. Only exceptions are attachments to some docs, like blogs,etc.

    Consequence should be that I can backup my database with a clean install, except for exceptions mentioned above and I will have the same application?

    That is an excellent plan, btw

    However, I don't see that at all.

    To stop breaking what I want to be my production site, I started runing a local copy of the app.

    I am installed clean remotely and locally. I copied all the data and structure to my local db.

    So I should get the exact same thing?

    Nope.

    So, ok, I'm running a WinXP box and Apache website.

    To test this out I setup a subdomain on Apache and do the same thing.

    Once again the descrepency. In fact the exact same descrency.

    I MUST be missing some information here.

    btw, the site backup module s__ks, still, note was "this might not work" in 1.8x. In 1.9.2 it still doesn't work. Backuped and restored and TRASH

    I've attache two screen shots of the differences for a user coming in for the first time. This part is a user's first doorway, and in a commercial market, the first impression is only made once.

    Gary
    http://ourspiritualgrowth.net


    Screens.rar (311.77 Kb)
    Reads: 1163
    Posted by Damian Parker posts: 2881 United Kingdom

    How are you backing up and restoring the database ?

    Looks and soounds to me like the backup and restore method is not working as it should.

    if your using phpMyAdmin it can be extremely problematic with database backups.

    Damian

    Posted by G.M. Knowles posts: 13 United States

    > How are you backing up and restoring the database ?
    >
    > Looks and soounds to me like the backup and restore method is not working as it should.
    >
    > if your using phpMyAdmin it can be extremely problematic with database backups.
    >
    > Damian
    >
    Damian,

    Thanks for the suggestion.

    I was talking about the backup feature within Tiki.

    As a matter of fact I am using MySQL Administrator for backups/restore of db now. It works great. Especially since I am attempting to use the spellcheck feature with that huge data table.

    btw, I have a issue with that. It is erroring out. Part of the error message indicates it is using en-uk rather than en-us. I don't know if that would be the problem, but I had to disable it for now.

    Posted by Damian Parker posts: 2881 United Kingdom

    > > How are you backing up and restoring the database ?
    > >
    > > Looks and soounds to me like the backup and restore method is not working as it should.
    > >
    > > if your using phpMyAdmin it can be extremely problematic with database backups.
    > >
    > > Damian
    > >
    > Damian,
    >
    > Thanks for the suggestion.
    >
    > I was talking about the backup feature within Tiki.
    >

    Is that the one with the big message underneath that says do not use because its not reliable ? 😀

    > As a matter of fact I am using MySQL Administrator for backups/restore of db now. It works great. Especially since I am attempting to use the spellcheck feature with that huge data table.

    Just tell mysqldump to ignore that table

    > btw, I have a issue with that. It is erroring out. Part of the error message indicates it is using en-uk rather than en-us. I don't know if that would be the problem, but I had to disable it for now.

    Its because we brits rule the world 😛

    Damian

    Posted by G.M. Knowles posts: 13 United States

    > > > How are you backing up and restoring the database ?
    > > >
    > > > Looks and soounds to me like the backup and restore method is not working as it should.
    > > >
    > > > if your using phpMyAdmin it can be extremely problematic with database backups.
    > > >
    > > > Damian
    > > >
    > > Damian,
    > >
    > > Thanks for the suggestion.
    > >
    > > I was talking about the backup feature within Tiki.
    > >
    >
    > Is that the one with the big message underneath that says do not use because its not reliable ? 😀


    It had that message in 1.8x, but it was not there in 1.9.2, so I tried it. It would be an excellent feature, if it worked.



    >
    > > As a matter of fact I am using MySQL Administrator for backups/restore of db now. It works great. Especially since I am attempting to use the spellcheck feature with that huge data table.
    >
    > Just tell mysqldump to ignore that table


    Yeh, I do that. I do hope I can get the spellchecking working someday.


    >
    > > btw, I have a issue with that. It is erroring out. Part of the error message indicates it is using en-uk rather than en-us. I don't know if that would be the problem, but I had to disable it for now.
    >
    > Its because we brits rule the world 😛
    >
    > Damian