title: is there a way to run a remote shell script on AWS MySql/Aurora that references sql remote files
body: <p>I am trying to run an init script on a AWS MySQL database, I have been able to run the same script on a local instance of MySQL but not when attempting it on a remote instance. This is the command I run, from the directory that has both the shell script and sql resource files:</p>
  
  <blockquote>
    <p>mysql -u user -p -h endpoint123.us-east-1.rds.amazonaws.com -P 3306 &lt;
    create_database.sh</p>
  </blockquote>
  
  <p>And after entering in my password get the following error:</p>
  
  <blockquote>
    <p>ERROR 1064 (42000) at line 15: You have an error in your SQL syntax;
    check the manual that corresponds to your MySQL server version for the
    right syntax to use near [line referencing SQL files]</p>
  </blockquote>
  
  <p>Basically the script references local sql files that are also needed for the setup to complete. As far as I know, it is not possible to copy these files over to the AWS RDS machine. Is there any way to solve this so the shell script can run properly? Either by copying the files over or by running the shell script remotely? Thanks in advance!</p>