> 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 > phpMyAdmin?!
Since phpMyAdmin is a HTTP interfase, I don't think it is possible to do this. 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 HTH Adolfo --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php