Jump to:

23486 Posts in 18995 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Lost pagetree (sitetree) after converting DB

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 408 Views
  • wilsonStaff
    Avatar
    Community Member
    142 Posts

    Lost pagetree (sitetree) after converting DB Link to this post

    Hi to all, we had to change server environment

    from --> Microsoft IIs using SQL

    to --> Apache using mySQL

    The tech guy supposely converted the DB from SQL to mySQL.

    - - -

    I dumped all of my local files to the new server.
    Did a dev/build?flush=all

    - - -

    I can see/add all of my page types

    BUT

    ive lost the site tree (all of my pages and their content)

    - - -

    I can access the DB via myPHPAdmin and when i click on SITETREE

    i can only see the basic pages from the SS fresh install.

    - - -

    Have i lost it all?

    Thanks!

  • MrNick
    Avatar
    Community Member
    9 Posts

    Re: Lost pagetree (sitetree) after converting DB Link to this post

    Did he provide a dump for you of the new mysql database, or did he just tell you it was done?
    Maybe it's under a different database name or something...

    Ask him/her for a physical file dump - then you can have a look. And double check where the database is on the production machine.

  • wilsonStaff
    Avatar
    Community Member
    142 Posts

    Re: Lost pagetree (sitetree) after converting DB Link to this post

    Hello, turns out he didnt convert at all. He just created a new db under the same name.

    Later, he sent me a .mdf and .ldf files, which i asked him to convert to xml/csv (or sql) as i cant do much with mdf files.

    - - -

    But as i can open .mdf with text editor, i can SEE that the date (texts, content, sitetree) is there, garbagely displayed.

    - - -

    Any suggestions?

    Thanks for helping.

  • swaiba
    Avatar
    Forum Moderator
    1792 Posts
  • wilsonStaff
    Avatar
    Community Member
    142 Posts

    Re: Lost pagetree (sitetree) after converting DB Link to this post

    Ive read all that but i dont have a SQL Server handy (in fact i am on Mac using MAMP).

    Thanks!

  • wilsonStaff
    Avatar
    Community Member
    142 Posts

    Re: Lost pagetree (sitetree) after converting DB Link to this post

    Thing done. What i did:

    => Had the DB converted to an mysql file, standard settings.

    => Had to fiddle a bit with the DB back in phpmyadmin, because i had a bunch of errors, i.e:

    Incorrect table definition; there can be only one auto column and it must be defined as a key

    => changing ID column of EACH TABLE to :

    - Type = int(11)
    - Null = No
    - Default = None
    - Extra = AUTO_INCREMENT

    did the job.

    - - -

    I recovered ALL of my sitetree, along page content.

    Ouf...... been painfull.....

    408 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.