FUDforum: How To » restore data

Home » FUDforum » How To » restore data

Show: Today's Messages :: Polls :: Message Navigator

restore data [message #7377]

Wed, 20 November 2002 07:21

moulee

Messages: 3
Registered: November 2002

Karma: 0

Junior Member

hello,

I used v2.3.0 for a few months and made data backup using 'Make forum datadump' function. My harddisk crashed last week and after re-installing my linux and FUDForum v2.3.5, I got error messages when trying to restore the data using 'Import forum data' function. The same was true when using v2.3.0

Any ideas? Please help, thanks!

Kenneth
Sad

Report message to a moderator

Re: restore data [message #7383 is a reply to message #7377]

Wed, 20 November 2002 16:18

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You cannot import a data dump from 2.3.0 into 2.3.5, datadumps can only be imported to the forum running the same version. If that does not work, tell me exactly which errors did you recieve.

FUDforum Core Developer

Report message to a moderator

Re: restore data [message #7424 is a reply to message #7377]

Fri, 22 November 2002 01:47

moulee

Messages: 3
Registered: November 2002

Karma: 0

Junior Member

First, I install v2.2.3, then upgrade to v2.3.0. Then I use 'import forum data' function. See attached for the error messages. There are a lot of messages.
FYI, I have changed some versions when re-installing the linux:

before                after
Red Hat 7.3           RH 8.0
Apache 1.3.26         Apache 1.3.27
PHP 4.2.2             PHP 4.2.3
MySQL 3.23.52         MySQL 2.23.53a

BTW, is there other way to extract just the forum data out other than using the import function?

Thanks for your help

Kenneth

Attachment: admimport.php.html
(Size: 143.43KB, Downloaded 923 times)

[Updated on: Sun, 24 November 2002 08:59]

Report message to a moderator

Re: restore data [message #7479 is a reply to message #7377]

Mon, 25 November 2002 07:52

moulee

Messages: 3
Registered: November 2002

Karma: 0

Junior Member

finally I am able to restore the data, but in a very weired way!
just like to share with you what I've done:

1) gunzip the data dump

2) edit the data dump to add 1 more field to table:
2.1) fud21_attach - add "fsize INT UNSIGNED NULL"
2.2) fud21_users  - add "cat_collapse_status TEXT"

3) install 2.2.3, then upgrade to 2.3.0

4) overwrite the WWW_ROOT_DISK and DATA_DIR with backup data (I did backup before the harddisk crashed)

5) perform the "import forum data" function

It seems that the MYSQL table structures are not consistent. I don't know the reasons behind, but as long as it works, who cares? (at least I don't care)

I've just upgraded to 2.3.5 and so far so good, except some minor problem when recompiling the Cantonese language. (I need to manually copy 'img' folder from the English language and need to add a lot of labels in 'msg' by comparing with that of the English language)

Anyway, it's a great lesson for me and maybe I need to seriously consider other ways of data backup/restore methods instead of just relying on the data dump/import functions.

Thanks

Kenneth

[Updated on: Mon, 25 November 2002 07:52]

Report message to a moderator

Re: restore data [message #7482 is a reply to message #7479]

Mon, 25 November 2002 14:17

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Often the SQL data structure will change between the upgrades. Consequently I say the dump/import should be done ONLY between the same versions.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	How to add Windows-Paths with Backslashes?
Next Topic:	deleted admin account

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:05:28 GMT 2024

Total time taken to generate the page: 0.02153 seconds