Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.05 KB | None | 0 0
  1. alias MYSQL='mysql --batch --show-warnings --user=wikiuser -D wikidb --password=wikipass';
  2. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/interwiki.txt' IGNORE INTO TABLE interwiki" ;
  3. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/logs.txt' IGNORE INTO TABLE logging" ;  
  4. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/images.txt' IGNORE INTO TABLE image" ;  
  5. MYSQL -e"ALTER TABLE oldimage ADD PRIMARY KEY (oi_archive_name)" ;
  6. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/images_old.txt' IGNORE INTO TABLE oldimage" ;
  7. MYSQL -e"ALTER TABLE oldimage DROP PRIMARY KEY" ;
  8. MYSQL -e"ALTER table archive ADD PRIMARY KEY(ar_rev_id)" ;
  9. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/archive.txt' IGNORE INTO TABLE archive" ;
  10. MYSQL -e"ALTER TABLE archive DROP PRIMARY KEY" ;
  11. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/page.txt' REPLACE INTO TABLE page" ;
  12. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/restrictions.txt' REPLACE INTO TABLE page_restrictions" ;
  13. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/revision.txt' REPLACE INTO TABLE revision" ;
  14. MYSQL -e"LOAD DATA LOCAL INFILE 'dumps/text.txt' IGNORE INTO TABLE text" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement