Restoring wordpress backup

  • mds1978

    (@mds1978)


    17 years, 5 months ago

    hello,

    I have backup of all wp-tables when I was running wordpress 2.6.3

    Now I have new hosting account. There I want to restore my data as it is.

    I have done fresh installation of wordpress 2.7
    then went to phpmyadmin and deleted all tables generated by new installation. and then I clicked IMPORT and put my backup.sql file there and all tables are showing me perfectly.

    But when i try to open my blog, It shows me BLANK page. my wp-config file is also perfect.

    Do I need to restore wordpress 2.6.3 as bcos I have taken backup when It was 2.6.3. ?

    why it is showing me blank page ?

Viewing 8 replies - 1 through 8 (of 8 total)
  • mrmist

    (@mrmist)

    17 years, 5 months ago

    I think it would make things easier if you did install the 2.6.3 files and then upgrade.

    In theory it should make no difference, but in practice you would be more able to see where the problem is being introduced.

    Also if you have changed URL you will need to modify the site url as described in moving wordpress.

    Thread Starter mds1978

    (@mds1978)

    17 years, 5 months ago

    you are right.

    But my site address / path etc is same. There is no change in that.

    I have uploaded 2.6.3

    “manage” in admin area showing me all posts perfectly, but it is not displaying on site :

    see : http://www.readgujarati.com/sahitya

    it is showing me blank page still.

    I am using default permalinks.

    whooami

    (@whooami)

    17 years, 5 months ago

    if you have a database from a 2.6.3 blog, and files from 2.7 — you MUST click through to wp-admin/upgrade.php

    and you better hope you disbaled all of your plugins before you grabbed that database dump.

    mrmist

    (@mrmist)

    17 years, 5 months ago

    As WhoAmI eludes to, I think you need to look at disabling all your plugins to see if that makes your site appear.

    Also I’d suggest switching to the default theme.

    You can start switching things back on once stuff works.

    Thread Starter mds1978

    (@mds1978)

    17 years, 5 months ago

    At present on site,

    I have database of 2.6.3 and WordPress files are also from 2.6.3.

    I am using default wp-content folder. So no plugins and no themes.

    It is just like fresh files of 2.6.3.

    Still site is not working.

    any .htaccess issue ? bcos my blog is in subfolder and that does not contain any .htaccess file.

    mrmist

    (@mrmist)

    17 years, 5 months ago

    With the default permalinks there wouldn’t be any need for a .htaccess file.

    Has the site URL changed?

    Thread Starter mds1978

    (@mds1978)

    17 years, 5 months ago

    Now I got my blog back by clicking default theme and disabling all plugins.

    But now I got another problem.

    My text is in Gujarati – (one of the indian language), It is showing me questions marks ????? insted of actual text.

    I am sure the problem is with wp table collation. default collation is : latin1_swedish_ci. is it should be utf8_general-ci ?

    mrmist

    (@mrmist)

    17 years, 5 months ago

    That’s an area which I do not know a lot about, there is a fix for it though, and I think it is something to do with the

    define('DB_CHARSET', 'utf8');

    Line in your wp-config.

    However, I’d not add that without checking stuff out first. I suppose since you haev a backup you can play with it as much as you need until it’s right. Your best bet might be to do some google searching, it might show a thread on here that has the answer.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Restoring wordpress backup’ is closed to new replies.