Magento rewrite vis mysql console

gistfile1.txt

mysql> CREATE table temporary_table AS SELECT * FROM core_url_rewrite;

mysql> UPDATE temporary_table SET url_rewrite_id = NULL;

mysql> UPDATE temporary_table SET store_id = 4; //set the store_id you need to

mysql> UPDATE temporary_table SET id_path = UUID(); //create a unique id_path

mysql> insert ignore into core_url_rewrite select * from temporary_table; //insert the new records ignoring the ones with conflicts

Copy rewrites in batch to make them work in a different store under the same Magento installation.