FUDforum: How To » restore data

Home » FUDforum » How To » restore data

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

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

Mon, 25 November 2002 07:52

moulee

Messages: 3
Registered: November 2002

Karma:

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

[Message index]

		restore data By: moulee on Wed, 20 November 2002 07:21
		Re: restore data By: Ilia on Wed, 20 November 2002 16:18
		Re: restore data By: moulee on Fri, 22 November 2002 01:47
		Re: restore data By: moulee on Mon, 25 November 2002 07:52
		Re: restore data By: Ilia on Mon, 25 November 2002 14:17

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: Thu Nov 28 11:31:16 GMT 2024

Total time taken to generate the page: 0.05007 seconds