| importing data after server move [message #8920] |
Sun, 02 March 2003 06:19  |
gekido
Messages: 9
Registered: March 2003
Karma: 0
|
Junior Member |
|
|
k i've been running a fud forum for a while, we're now moving to a new upgraded server...
i did a 'datadump' from the old server, it created a .fud.gz file about 55 megs in size...
i ran the install.php file on the new forum, it's setup with the empty forum, the install process went fine...
the admin console works fine, i can login...but when i try to run the data import, it seems to just hang and not do anything...
i've let it run for quite a while (over an hour), but nothing seems to be happening...
just for curiousity, i've checked the database tables via webmin and nothing seems to be getting added to the database...
here's the machine info:
PHP built On: FreeBSD 4.7-RELEASE FreeBSD 4.7-RELEASE #0: Sat Feb i386
MySQL Version: 3.23.55
PHP Version: 4.3.0
Web Server: Apache/1.3.27 (Unix) PHP/4.3.0
WebServer to PHP interface: apache
Forum Version: 2.3.2
Relavent PHP Settings:
Safe Mode: OFF
Display Errors: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: ON
Output Buffering: OFF
Disabled Functions: none
PSpell Support: Yes
do i need to turn safemode on to import data or something? i REALLY need this forum up asap, any help or suggestions you have is greatly appreciated.
the forum url is http://rfactory.uber-geek.ca/forum/
cheers
Mike W
Reality Factory Web Guy
http://rfactory.uber-geek.ca
|
|
|
|
|
|
| Re: importing data after server move [message #8923 is a reply to message #8921] |
Sun, 02 March 2003 10:15  |
gekido
Messages: 9
Registered: March 2003
Karma: 0
|
Junior Member |
|
|
k well, i let it run and finally the sucker completed...but it lost all of the file attachments that had been uploaded to the forum.
hmm...somewhat annoying as this is a game development forum and people are uploading useful attachments and whatnot all the time...
dunno...the forum works...i still have access to the old forum...might be good enough...can glean whatever i need from the old one i guess...sigh
[Updated on: Sun, 02 March 2003 10:16] Report message to a moderator |
|
|
|
| Re: importing data after server move [message #8941 is a reply to message #8923] |
Mon, 03 March 2003 14:34 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The import/dump process may work with safe_mode, but ideally it should be ran with it off. You also need to make sure that the version of the source & destination forum in the same, if they are not there may be problems.
You can manually move the forum too, basically you'll need to do the following:
1) Compress all forum directories & backup the mysql data
2) Decompress forum directories on new server & import mysql data
3) Modify GLOBALS.php to correct paths & sql info
4) Using the theme manager rebuild the theme.
FUDforum Core Developer
|
|
|
|
| Re: importing data after server move [message #8952 is a reply to message #8941] |
Mon, 03 March 2003 18:39 |
gekido
Messages: 9
Registered: March 2003
Karma: 0
|
Junior Member |
|
|
suckers already live on the new server.
sigh. too bad, those attachments were pretty important.
i had the exact version of the forum on each server, different php version, different mysql version.
and i thought of turning safemode on, but didn't know how ;]
[Updated on: Mon, 03 March 2003 18:39] Report message to a moderator |
|
|
|
|
|
| Re: importing data after server move [message #8954 is a reply to message #8953] |
Mon, 03 March 2003 22:23 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Ideally people should use the dump/import because it is the fastest and more proven method. The other method while it 'sounds' simply can be quite prolematic. Even I occasionaly have problems doing it and usually just use the dump/import.
FUDforum Core Developer
|
|
|
|
|
|
| Re: importing data after server move [message #10449 is a reply to message #10440] |
Mon, 02 June 2003 12:37 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You can do a datadump manually but you need to do a bit of work.
In addition to dumping the SQL data you need to backup the messages/, files/ and images/ directories of your existing forum.
Then when you install a new forum and overwrite it's databases with the ones from the old forum you'll also need to import the files you've backed up into the appropriate directories.
FUDforum Core Developer
|
|
|
|
|
|
| Re: importing data after server move [message #10462 is a reply to message #10461] |
Mon, 02 June 2003 14:57 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Did you modify your GLOBALS.php to use the right table prefix etc...?
Did you recompile the templates after importing the data?
FUDforum Core Developer
|
|
|
|
|
|
| Re: importing data after server move [message #10479 is a reply to message #10463] |
Mon, 02 June 2003 19:28 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
That should be fine, no GLOBALS.php changed are required. To rebuild templates go to the theme manager and use the rebuild themes link.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: importing data after server move [message #10962 is a reply to message #10953] |
Sat, 14 June 2003 14:57 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
To be honest with you, version 2.3.1 is quite old and has many bugs that by know have been long solved & forgotten. My advice to you would be to upgrade to 2.3.8 before doing any further debugging.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
| Re: importing data after server move [message #10990 is a reply to message #10971] |
Mon, 16 June 2003 01:39 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Hmm if you server has about 500-700mhz and the php time limit is 3-4 minutes that the upgrade script should be safe to run.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: importing data after server move [message #11043 is a reply to message #11042] |
Tue, 17 June 2003 13:08 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Ok, the problem is slightly different from what you've described. The file is actually there, however it's size appears to be 0 bytes, Hence the broken image you are seeing. You need to do several things. 1st of all check the SQL database and make sure that the files sizes are not 0, if they are let me know and I'll tell you what you need to do.
Also, with the forum's file browser go into the files/ directory and see if you can use it successfuly download any of the file attachments.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: importing data after server move [message #11050 is a reply to message #11047] |
Tue, 17 June 2003 13:31 |
gserban
Messages: 26
Registered: June 2003
Karma: 0
|
Junior Member |
|
|
do you mean the file fud_attach.tbl in
/var/www/www.mercedesbenzclub.nl/forum/sql/mysql
if it is so in that file is written now
# copyright : (C) 2001,2002 Advanced Internet Designs Inc.
# email : forum(at)prohost(dot)org
#
# $Id: fud_attach.tbl,v 1.2 2002/09/12 23:00:58 hackie Exp $
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
DROP TABLE IF EXISTS {SQL_TABLE_PREFIX}attach;
CREATE TABLE {SQL_TABLE_PREFIX}attach
(
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
proto ENUM('LOCAL', 'REMOTE') NOT NULL DEFAULT 'REMOTE',
location CHAR(255) NOT NULL,
original_name CHAR(255),
owner INT UNSIGNED NOT NULL,
private ENUM('N', 'Y') NOT NULL DEFAULT 'N',
message_id INT UNSIGNED NOT NULL,
dlcount INT UNSIGNED NOT NULL DEFAULT 0,
mime_type INT UNSIGNED NOT NULL DEFAULT 0,
fsize INT NOT NULL DEFAULT 0,
INDEX(message_id,private)
)
[Updated on: Tue, 17 June 2003 13:33] Report message to a moderator |
|
|
|
| Re: importing data after server move [message #11051 is a reply to message #11050] |
Tue, 17 June 2003 13:35 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
No, that file contains just the table defenition. I would like you to connect to MySQL and run a query such as this:
SELECT id,size FROM fud25_attach ORDER BY id LIMIT 100;
If your SQL table prefix is not fud25, then change fud25_ to whatever your SQL table prefix is.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]