| backup without database [message #35423] |
Tue, 09 January 2007 23:58  |
|
|
I have big problemm ... the serwer which hosted my forum died. I made a backup just before, but when importing it the messages files are copied into new forum, but tables in database are empty. No users info (0 record) no data.
The question is: Is it possible to recreate forum with posts from backup like this? And if yes how hard is it to do?
After importing backup FUDforum script says that there is no user info about me (administrator) so i have to login once again, but i cannot because there is no user info.
The server which was hosting the forum is now dead and buried so I have only the tar.gz backup file.
|
|
|
|
| Re: backup without database [message #35429 is a reply to message #35423] |
Wed, 10 January 2007 16:07  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Was the backup file made with forum's dump functionality?
Also, make sure that the version of the forum the dump was generated on is the same as the one you are importing the data into.
FUDforum Core Developer
|
|
|
|
| Re: backup without database [message #35432 is a reply to message #35429] |
Thu, 11 January 2007 03:14 |
|
|
| Ilia wrote on Wed, 10 January 2007 17:07 |
Was the backup file made with forum's dump functionality?
Also, make sure that the version of the forum the dump was generated on is the same as the one you are importing the data into.
|
Yes and Yes (latest version) ... but the server was going to die when I made a backup and probably this is why the datadump is not correct.
|
|
|
|
| Re: backup without database [message #35446 is a reply to message #35432] |
Fri, 12 January 2007 02:17 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Can you open the datadump in an editor and see if there are SQL queries inside it?
FUDforum Core Developer
|
|
|
|
| Re: backup without database [message #35451 is a reply to message #35446] |
Fri, 12 January 2007 09:47 |
|
|
| Ilia wrote on Fri, 12 January 2007 03:17 |
Can you open the datadump in an editor and see if there are SQL queries inside it?
|
Threre are some, but with no data ... not sure if i'm looking about correct data but e.g.
$ grep "^INSERT.*user" FUDforum_03_01_2007_03_20.fud
INSERT INTO {SQL_TABLE_PREFIX}users (login, alias, time_zone, theme, email, passwd, name, users_opt) VALUES('Anonymous Coward', 'Anonymous Coward', 'America/Montreal', 1, 'dev@null', '1', 'Anonymous Coward', 1|4|16|32|128|256|512|2048|4096|8192|16384|262144|2097152|4194304);
INSERT INTO {SQL_TABLE_PREFIX}custom_tags (name, user_id) VALUES ('Administrator', 2);
INSERT INTO {SQL_TABLE_PREFIX}stats_cache (online_users_text) VALUES('');
adds default data into table. same time, my username on forum is wariat, and if i'll try to look for it:
$ grep "INSERT.*wariat" FUDforum_03_01_2007_03_20.fud
it shows nothing.
|
|
|
|
| Re: backup without database [message #35452 is a reply to message #35451] |
Fri, 12 January 2007 15:20 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Would it be possible for you to make the dump file available for download (send me a PM) so I can review its contents.
From what you've said so far is certainly seems as if something prevented the forum from getting the information located within the DB when the dump was being made.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]