Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alias MYSQL='mysql --batch --show-warnings --user=wikiuser -D wikidb --password=wikipass';
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/interwiki.txt' IGNORE INTO TABLE interwiki" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/logs.txt' IGNORE INTO TABLE logging" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/images.txt' IGNORE INTO TABLE image" ;
- MYSQL -e"ALTER TABLE oldimage ADD PRIMARY KEY (oi_archive_name)" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/images_old.txt' IGNORE INTO TABLE oldimage" ;
- MYSQL -e"ALTER TABLE oldimage DROP PRIMARY KEY" ;
- MYSQL -e"ALTER table archive ADD PRIMARY KEY(ar_rev_id)" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/archive.txt' IGNORE INTO TABLE archive" ;
- MYSQL -e"ALTER TABLE archive DROP PRIMARY KEY" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/page.txt' REPLACE INTO TABLE page" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/restrictions.txt' REPLACE INTO TABLE page_restrictions" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/revision.txt' REPLACE INTO TABLE revision" ;
- MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/text.txt' IGNORE INTO TABLE text" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement