> I have multiple SQL files that create different tables.
> Is there a way for me to create a single SQL file that will
> call these
> other files?
> Since I am using phpMyAdmin, I am assuming that call this file from
Since phpMyAdmin is a HTTP interfase, I don't think it is possible to do
The server (Apache, IIS, etc) would have to know the location of the files
in the client machine, which is not possible in a stateless connection.
What I do is to have a script (bat for DOS or bash for Linux) making the
calls to the sql scripts. Something like:
mysql -h yourhost -u root -pqwerty < script1.sql
mysql -h yourhost -u root -pqwerty < scriptN.sql