It's up to 1,200,000 in it's count now:
1,200,000 pages (118.572/sec), 1,200,000 revs
(118.572/sec)
I thought there were less than 1,000,000 articles...
What's up with that?
X
--- Xed Mac <xed2507(a)yahoo.co.uk> wrote:
Thanks for your help so far.
OK, I enter this in the terminal:
/usr/local/mysql-standard-5.0.16-osx10.4-powerpc/bin/mysql
-u root -p wikidb
Then I type this (literally) in mysql:
SOURCE
/Users/xed/Sites/mediawiki/maintenance/tables.sql
....i get this:
Query OK, 0 rows affected, 1 warning (0.17 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.06 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.02 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
...
Back in the terminal, I wrote:
/System/Library/Frameworks/JavaVM.framework/Versions/1.5/Commands/java
-jar -Xmx=200m /Users/xed/Desktop/mwdumper.jar
--format=sql:1.5
/Users/xed/Desktop/20051127_pages_articles.xml.bz2 |
/usr/local/mysql-standard-5.0.16-osx10.4-powerpc/bin/mysql
-u wikiuser -p wikidb
I got the error: invalid initial heap size
So I tried this:
/System/Library/Frameworks/JavaVM.framework/Versions/1.5/Commands/java
-jar -Xmx512m -Xms256m
/Users/xed/Desktop/mwdumper.jar
--format=sql:1.5
/Users/xed/Desktop/20051127_pages_articles.xml.bz2 |
/usr/local/mysql-standard-5.0.16-osx10.4-powerpc/bin/mysql
-u wikiuser -p wikidb
...and now it's stepping thru (very slowly):
1,000 pages (91.033/sec), 1,000 revs (91.033/sec)
2,000 pages (98.917/sec), 2,000 revs (98.917/sec)
3,000 pages (101.93/sec), 3,000 revs (101.93/sec)
4,000 pages (92.913/sec), 4,000 revs (92.913/sec)
5,000 pages (89.284/sec), 5,000 revs (89.284/sec)
6,000 pages (84.647/sec), 6,000 revs (84.647/sec)
7,000 pages (80.61/sec), 7,000 revs (80.61/sec)
8,000 pages (80.176/sec), 8,000 revs (80.176/sec)
9,000 pages (78.468/sec), 9,000 revs (78.468/sec)
10,000 pages (78.394/sec), 10,000 revs (78.394/sec)
etc
It's getting slower as it goes on. I guess that's
normal?
What do I do when this process is finished?
Thanks
X
--- Brion Vibber <brion(a)pobox.com> wrote:
Xed Mac wrote:
> How do I use tables.sql? What do I need to type
in
the
terminal?
$ mysql -u root -p your_database_name
mysql> SOURCE
/path/to/mediawiki-1.5.3/maintenance/tables.sql
-- brion vibber (brion @
pobox.com)
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
___________________________________________________________
Yahoo! Model Search 2005 - Find the next catwalk
superstars -
http://uk.news.yahoo.com/hot/model-search/
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
___________________________________________________________
WIN ONE OF THREE YAHOO! VESPAS - Enter now! -
http://uk.cars.yahoo.com/features/competitions/vespa.html