Stored Procedure imported from file, but tables have no data
The fact of importing or creating a Stored Procedure, does not include its execution.

After creating the SP (via MySQL Shell or via bootstrap file) you must call it, in order to process the routines which are stored in it.

Stored Procedure 

DELIMITER //
CREATE PROCEDURE `books_database`()
BEGIN
   SELECT...
   INSERT...
END //


Call your Stored Procedure...

CALL books_database();




Extra Comment: Creation of Stored Procedures via MySQL Shell


Before creating your SP, first, select the database (use your_database)  where this SP will be used, or else, as you try to create the SP, the MySQL Shell will return: ERROR 1046 (3D000): No database selected. 
Don't forget to rollback to the default delimiter (DELIMITER ;) in order to perform the normal commands on MySQL Shell, after creating your SP.