-
Notifications
You must be signed in to change notification settings - Fork 2
sf_part
mysqldump -uroot -p -S /tmp/mysql-3306.sock --no-create-info --where "id > 1879176" molib sf_parts >molib-sf_parts-id-1879176-0212.sql
mysqldump -uroot -p -S /tmp/mysql-3306.sock --no-create-info --where "id > 1875" molib sf_mfrs >molib-sf_mfrs-id-1875-0212.sql
mysqldump -uroot -p -S /tmp/mysql-3309.sock molib sf_parts > molib-sf_parts.sql
mysqldump -uroot -p -S /tmp/mysql-3309.sock molib sf_mfrs > molib-sf_mfrs.sql
mysql -uroot -p -S /tmp/mysql-3309.sock molib < molib-sf_mfrs-id-1875-0212.sql
mysql -uroot -p -S /tmp/mysql-3309.sock molib < molib-sf_parts-id-1879176-0212.sql
mysql -uroot -p -S /tmp/mysql-3309.sock molib
mysql> select max(id) from sf_parts;
+---------+
| max(id) |
+---------+
| 1916050 |
+---------+
1 row in set (0.00 sec)
mysql> select max(id) from sf_mfrs;
+---------+
| max(id) |
+---------+
| 1908 |
+---------+
indexer --rotate sf_part
indexer --rotate sf_part