Home
Join
check
  • Execute the script , Note the SQL Script is in the window (Green text) 

    Depending on the speed of your machine this may take some time. 

    When completed you will see this: 



    Was this post helpful? thumb_up thumb_down
  • View Best Answer in replies below

    11 Replies

    • So to create the database from the Chinook_Sqlite.sql file:

      1. Create a new database
      2. Click the Execute SQL tab 
      3. Click Open SQL File
      4. Click Execute SQL File 
      5. When completed down the bottom will be displayed: 
      SQL
      -- At line 15855:
      INSERT INTO [PlaylistTrack] ([PlaylistId], [TrackId]) VALUES (18, 597);
      -- Result: query executed successfully. Took 1ms, 1 rows affected
      
      Was this post helpful? thumb_up thumb_down
    • Thanks for the reply. Creating New Database I understand means clicking New Database on SQLite.


      Next:



      Help appreciated.

      Was this post helpful? thumb_up thumb_down
    • I also tried this way:

      First, clicked Execute SQL






      Was this post helpful? thumb_up thumb_down
    • Click cancel when the Edit Table Definition window appears 
      The n click Execute SQL Tab

      Open SQL File "Chinook_Sqlite.sql"

      Execute All should be available

      Was this post helpful? thumb_up thumb_down




    • Was this post helpful? thumb_up thumb_down


    • Thanks for continuing to support. Sorry for seeking help again and again.

      Above are the screenshots of how I proceeded. As .db file was readily available, I tried with .db file. 

      Finally, no database structure/data apparently loaded as all showing 0.

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • Go  to: https://github.com/lerocha/chinook-database/

      Download the Zip 


      Extract the file "\chinook-database-master\ChinookDatabase\DataSources\Chinook_Sqlite.sql" from the chinook-database-master.zip

      Start DB Browser for SQLite 

      New Database 

      Cancel "Edit table definition" 


      Click "Execute SQL" tab 

      Open "Chinook_Sqlite.sql"

      Spice (1) flagReport
      2 found this helpful thumb_up thumb_down
    • Execute the script , Note the SQL Script is in the window (Green text) 

      Depending on the speed of your machine this may take some time. 

      When completed you will see this: 



      Was this post helpful? thumb_up thumb_down
    • Finally save the database changes

      The database should now be larger


      Spice (1) flagReport
      1 found this helpful thumb_up thumb_down
    • Thanks! By following the above, I was successful this time.

      One hurdle still faced is once I closed the DB browser, I could not find a way to access the saved files. Repeating the same will be time taking as there are lots of files to upload and that apparently takes time.

      Was this post helpful? thumb_up thumb_down
    • These are to create the database , you should be able to open the saved .sqlite file and see all the tables in the browser

      Was this post helpful? thumb_up thumb_down

    Read these next...