FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » Data dump hangs
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Data import blows up [message #34169 is a reply to message #34157] Mon, 09 October 2006 20:36 Go to previous messageGo to previous message
mdbrown is currently offline  mdbrown   United States
Messages: 18
Registered: December 2005
Karma:
Junior Member
Ilia wrote on Mon, 09 October 2006 09:49

Well, increasing the execution time in the script via set_time_limit(0) will probably ensure a complete run. If it still does not work you can forgo the forum's built-in data dump and simply use mysql dump for database info and tar for forum's files.


Thanks, I'll try that. But first, I'll restore the SQL tables and FUDforum/files and FUDforum/messages directories to their pristine, pre-import state...

Okay, ready to execute...

ono-sendai# php ./cliimport.php &
[1] 9718
ono-sendai# <html>
<head>
<link rel="StyleSheet" href="adm.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=PHP Notice: Undefined variable: usr in /www/rvconnection/adm/admpanel.php on line 5
PHP Notice: Undefined variable: usr in /www/rvconnection/adm/admpanel.php on line 5
PHP Notice: Undefined variable: usr in /www/rvconnection/adm/admpanel.php on line 7
us-ascii">
</head>
<body>
<table class="maintable">
<tr>
<td class="linkdata">
<table class="linktable">
<tr>
<td>
<a href="../PHP Notice: Use of undefined constant __fud_index_name__ - assumed '__fud_index_name__' in /www/rvconnection/adm/admpanel.php on line 21
PHP Notice: Use of undefined constant __adm_rsidl - assumed '__adm_rsidl' in /www/rvconnection/adm/admpanel.php on line 21
__fud_index_name__?__adm_rsidl">Return To Forum</a>
</td></tr>
<tr><td>
<span class="linkhead">Admin Control Panel</span></td></tr>
<tr>
<td nowrap>
<span class="linkgroup">Checks/Consistency</span><br>
<a href="consist.php?PHP Notice: Use of undefined constant __adm_rsidl - assumed '__adm_rsidl' in /www/rvconnection/adm/admpanel.php on line 28
__adm_rsidl">Forum Consistency</a><br>
<a href="indexdb.php?PHP Notice: Use of undefined constant __adm_rsidl - assumed '__adm_rsidl' in /www/rvconnection/adm/admpanel.php on line 29
__adm_rsidl">Rebuild Search Index</a><br>
<a href="compact.php?PHP Notice: Use of undefined constant __adm_rsidl - assumed '__adm_rsidl' in /www/rvconnection/adm/admpanel.php on line 30
__adm_rsidl">Compact Messages</a><br><br>
.
.
.

And there are a bunch more like that. Hope those are benign messages. The funny thing is, the earlier run that timed out at 6000 seconds didn't have those errors. Here's the output from that run:

ono-sendai# php ./cliimport.php &
<html>
<head>
<link rel="StyleSheet" href="adm.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<table class="maintable">
<tr>
<td class="linkdata">
<table class="linktable">
<tr>
<td>
<a href="../__fud_index_name__?__adm_rsidl">Return To Forum</a>
</td></tr>
<tr><td>
<span class="linkhead">Admin Control Panel</span></td></tr>
<tr>
<td nowrap>
<span class="linkgroup">Checks/Consistency</span><br>
<a href="consist.php?__adm_rsidl">Forum Consistency</a><br>
<a href="indexdb.php?__adm_rsidl">Rebuild Search Index</a><br>
<a href="compact.php?__adm_rsidl">Compact Messages</a><br><br>

<span class="linkgroup">General Management</span><br>
<a href="admglobal.php?__adm_rsidl">Global Settings Manager</a><br>
<a href="admreplace.php?__adm_rsidl">Replacement & Censorship System</a><br>
<a href="admmime.php?__adm_rsidl">MIME Managment System</a><br>
<a href="admrdf.php?__adm_rsidl">RDF Feed Managment</a><br>
<a href="admpdf.php?__adm_rsidl">PDF Generation Managment</a><br>
<a href="admspell.php?__adm_rsidl">Custom Dictionary Spell Checker</a><br><a href="admbrowse.php?__adm_rsidl">File Manager</a><br><a href="admlock.php?__adm_rsidl">Lock/Unlock Forum's Files</a><br> <a href="admstats.php?__adm_rsidl">Forum Statistics</a><br>
<a href="admlog.php?__adm_rsidl">Action Log Viewer</a><br>
<a href="admerr.php?__adm_rsidl">Error Log Viewer</a><br>
<a href="admsysinfo.php?__adm_rsidl">System Info</a><br><br>

<span class="linkgroup">Forum Management</span><br>
<a href="admcat.php?__adm_rsidl">Category & Forum Management</a><br>
<a href="admdelfrm.php?__adm_rsidl">Deleted Forums</a><br>
<a href="admannounce.php?__adm_rsidl">Announcement Manager</a><br>
<a href="admprune.php?__adm_rsidl">Topic Pruning</a><br>
<a href="admaprune.php?__adm_rsidl">Attachment Pruning</a><br>
<a href="admmlist.php?__adm_rsidl">Mailing List Manager</a><br>
<a href="admnntp.php?__adm_rsidl">Newsgroup Manager</a><br><br>
.
.
.

BTW, I'm using MySQL 4.0.15 and PHP 4.4.1 on a FreeBSD 4.11 server.

I appreciate your assistance.

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Attachment problem
Next Topic: how view one image in a post
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 07:07:24 GMT 2024

Total time taken to generate the page: 0.04304 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software