importing datadump, so easy, so hard [message #18426] |
Sat, 22 May 2004 12:27 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
Member |
|
|
Hi,
I'm practising moving a forum to another web server (which I'll really need soon).
The current forum is on a linux system with php 4.3.4, mysql 3.23.56. The new site I'm practising is a freebsd with php 4.3.6, mysql 4.1.1 (The real site will most probably be a linux with php 4, and mysql 3.x).
Making datadump with no problem. Installing the new forum with no problem (The new installation directories are completely different than the old one).
I upgraded the old forum to version 2.6.3. Then I made a datadump. I made a fresh install of 2.6.3 to the new server.
When importing, the following error occurs:
Warning: mkdir(/home/FUDforum//errors/.backup/template_1025894133): Permission denied in /home/www/forum/adm/admimport.php on line 38
Failed to create /home/FUDforum//errors/.backup/template_1025894133 directory, check file permissions
However, the web server DOES HAVE write permissions to the directory, because it's the user I used when installing the fudforum.
Anyway, I do a chmod -R 777 /home/FUDforum. No luck! The same error message... I checked, The template_1025894133 dir is created with permissions 644. I guess there is something wrong with the umask, which is 0022. It should create the directories with 755, but it creates them with 644. It seems it creates dirs as if they were files.
Anyway, again I do a chmod -R 777 on the template_ directory.
This time, I get only the following message (but 6 times):
Warning: fread(): Length parameter must be greater than 0. in /home/www/forum/adm/admimport.php on line 92
Then I try to return to some administration part of the forum, I get a login and password page. It won't let me in (tried both OLD and NEW admin credentials), saying "Only administrators with proper access credentials can login via this control panel".
I checked fud2_users table (since old prefix was fud2_, I used the same prefix in the new forum as well), it's completely empty. Some of the other tables contain data, but I'm not quite sure if all or most of the rest are in good condition.
I have just one guess, it may be something related to mysql 3.x and 4.x differences. I don't know much about these differences, so I'll just once more try importing data with using mysql 3.x.
Do you have any idea?
Thanks in advance,
2f@n
[Updated on: Sat, 22 May 2004 12:33] Report message to a moderator
|
|
|
Re: importing datadump, so easy, so hard [message #18463 is a reply to message #18426] |
Mon, 24 May 2004 15:51 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The importer script creates directories with 0755 mask and does not perform any other permission modifications via umask() or chmod() functions.
The other error you saw was like the result of an empty file, I've added a workaround for that in CVS.
The lack of SQL data is a more serious problem, I am not sure why did it happen, but I can tell you that it is definitely not related to difference in SQL server versions. If possible send me the dump that you have and I'll try to figure out why it is not being imported correctly.
FUDforum Core Developer
|
|
|
Re: importing datadump, so easy, so hard [message #18509 is a reply to message #18463] |
Tue, 25 May 2004 18:41 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
Member |
|
|
Ok.
The guilty was not the script, nor the database version differences. The only problem was my apache server I guess, I restarted the web server using the /etc/rc.d script (as an alternative to using apachectl), and the problem disappeared. It's still strange though, I'll further investigate.
I managed to transfer the forum contents, both into mysql 4.x and mysql 3.23.x. I was able to import with no fatal errors. However, I had to do a forum consistency check (followed by the sql optimization) to see the messages: They were first inaccessible, although the forum statistics were correct. It was a bit funny actually: Even the page numbers at the bottom in the thread view were there, but there were no messages listed
Anyway, I succeded in the transfer experiment. Hopefully it'll be this smooth when doing the real transfer.
Thanks for the help, and by the way, thanks for writing such 'smooth operating' scripts. I never had any problems in upgrading the forum yet. For a very long time, I haven't been even making a backup of the forum when upgrading
cya,
2f@n
[Updated on: Tue, 25 May 2004 18:42] Report message to a moderator
|
|
|
|
|
Ok. I solved. [message #18549 is a reply to message #18548] |
Thu, 27 May 2004 09:19 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
Member |
|
|
I didn't change the cookie domain, although I thought I did it (I noticed I only changed the $WWW_ROOT)
I was in a kinda panic, I didn't notice it.
Now I can access to the admin page.
cya,
2f@n
|
|
|