Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alias MYSQL='mysql --batch --show-warnings -u <YOUR_DATABASE_USERNAME> -D <USER_DATABASE_NAME> -p<YOUR_DATABASE_PASSWORD>'
- 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