root/feedmelinks/_config/SQL/data-migration-steps.txt
| Revision 397, 281 bytes (checked in by hirokai, 5 years ago) | |
|---|---|
| |
| Line | |
|---|---|
| 1 | mysql -h localhost -u jm3 -pdevdata dev_feedmelinks_com_-_dev -e "SELECT ID, groupid FROM links WHERE groupid IS NOT NULL ORDER BY ID;" > link-folder-xrefs.txt |
| 2 | cat link-folder-xrefs.txt | awk '{print " INSERT INTO linksCategoriesXRef VALUES( " $1 ", " $2 " );"}' > conversion.sql |
Note: See TracBrowser for help on using the browser.