Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. alias MYSQL='mysql --batch --show-warnings -u <YOUR_DATABASE_USERNAME> -D <USER_DATABASE_NAME> -p<YOUR_DATABASE_PASSWORD>'
  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