On Apr 7, 2004, at 21:11, Paul Hardwick wrote:
Only had one small but surmountable
problem. When using IE 5.1.3 Under MacOS 9.0.4 I could not enter the
name
for the site. The field was overlaid by the info that should have been
to
its right. I switched to Netscape and then no problem.
I'll check this out, thanks for the note.
Now I am in the process of populating the database and
was wondering
if in
the maintenance folder (or someplace else) there is a set of script to
fetch and upload the actual base data content and then the weekly
updates. I would like to keep this mirror up to date with the master
copy.
No, there is no such script. Unfortunately we don't yet have a good
procedure for synchronizing a mirror other than throwing out and
replacing the whole thing every week or so.
Just note, INSTALL THE WIKI FIRST, then load in the data. The dumps
*drop* the existing tables and replace them, and the install doesn't
like to run over a partial set of tables. (Command-line install will
drop any existing tables.)
The partials have me confused,
First, the bad news. The partials weren't being updated automatically
by the backup process, so what you downloaded was about a month old. If
you want the April 3 backup, you'll have to grab them again. Sorry...
:(
Also, the split files are up to xae now. Compression of old revisions
reduces the raw disk space (& disk cache) needed for the table, but
totally ruins the compression ratio of the downloadable dumps.
-bash-2.05b$ nice bzip2 -t xaa xab xac xad
bzip2: xaa: file ends unexpectedly
bzip2: xab: bad magic number (file not created by bzip2)
That will try to decompress each file in turn, which doesn't work; you
need to concatenate them back into a single stream. The simplest thing
might be to pipe it straight into mysql, assuming you're already set
up:
cat xa? | bzip2 -dc | mysql -u mywikiuser -p mydatabase
Or if you'd like to output a big decompressed SQL file:
cat xa? | bzip2 -dc > old_table_20040403.sql
-bash-2.05b$ nice mysql -p -uxxxxxxx wikipedia <
20040403_cur_table.sql
Enter password:
ERROR 1153 at line 831: Got a packet bigger than 'max_allowed_packet'
-bash-2.05b$========= end of clip
What size should I be setting the 'max_allowed_packet' to?
I think 16MB is the maximum, try that.
-- brion vibber (brion @
pobox.com)