Migrating an existing Scuttle database to SemanticScuttle

URL dieses Beitrags: http://blog.stefan-macke.com/2012/08/05/migrating-an-existing-scuttle-database-to-semanticscuttle/

I’ve migrated my existing bookmark collection from Scuttle to SemanticScuttle. All it took was these three lines of SQL:

  1. INSERT INTO semanticscuttle.sc_users (uId,username,password,uDatetime,uModified,name,email,homepage,uContent) (SELECT * FROM scuttle.sc_users);
  2. INSERT INTO semanticscuttle.sc_bookmarks (bId,uId,bIp,bStatus,bDatetime,bModified,bTitle,bAddress,bDescription,bHash) (SELECT * FROM scuttle.sc_bookmarks);
  3. INSERT INTO semanticscuttle.sc_bookmarks2tags (SELECT * FROM scuttle.sc_tags);

Kommentar zu diesem Beitrag

  1. Gravatar alex
    Am 6. Februar 2013 um 15:53 Uhr

    Thanks for this – just what I needed to move across to semantic scuttle.

Einen Kommentar schreiben

XHTML: Diese Tags sind erlaubt: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>