I have to set up a local database on a number of people's Linux Mint lap- and desk-tops. The idea is to do this from the command line after installing MySQL Server and Client, and associated components. The command line I am looking for is something like:-
mysql -uuser -p database < schemafile.sql
However at this stage MySQL does not know about the database and I cannot work out the syntax to introduce it. Previously I have done this via Workbench but I do not want to install this as the users are only meant to populate their local database which will be exported down the line via a specific app that does numerous validations and cross-checks.
Thanks and regards...