--- scripts/reblog2couchdb.pl 2008/08/05 14:48:57 4 +++ scripts/reblog2couchdb.pl 2008/08/05 15:03:24 5 @@ -10,7 +10,7 @@ my $database = 'reblog'; my $connect = "DBI:mysql:database=$database"; -#$connect = "DBI:mysql:database=$database;host=localhost;port=13306"; +$connect .= ";host=127.0.0.1;port=13306"; # XXX over ssh my $dbh = DBI->connect($connect,"","") || die $DBI::errstr; @@ -28,7 +28,7 @@ -- where label = 'read' and value_numeric = ? join feeds on items.feed_id = feeds.id order by items.id asc --- limit 42 + limit 5000 }; my $sth = $dbh->prepare($sql) || die $dbh->errstr();