I have looked around a bit on the web but did not find a definitive answer/example.

I want to be able to discern different customer data by using the concept of schemas.

For example

SELECT * from BIGDB.Customer1.patient_information

WHERE BIGDB is the database and Customer1 is the schema
and lastly the table

If it does support schemas like this, sorry another question, can you backup and restore individual schemas?

As I indicated I have searched for a while now and am either not getting it, it does not exist, or I am searching with the incorrect 'terms'

Thanks!

In MySQL CREATE SCHEMA is synonymous for CREATE DATABASE. So your query above can only do SELECT * FROM DATABASE.TABLE;