Running MySQL *.sql files in PHP

by

This question comes up from time to time. There’s no good solution for running a .sql script directly from PHP. There are edge cases where statements common in a .sql script can’t be executed as SQL statements. For example, the mysql tool has builtin commands that are not recognized by the MySQL Server, e.g. CONNECT, TEE, STATUS, and DELIMITER.

So I give +1 to @Ignacio Vazquez-Abrams’s answer. You should run your .sql script in PHP by invoking the mysql tool, for instance with shell_exec().

I got this test working:

$command = "mysql --user={$vals['db_user']} --password='{$vals['db_pass']}' "
 . "-h {$vals['db_host']} -D {$vals['db_name']} < {$script_path}";

$output = shell_exec($command . '/shellexec.sql');

See also my answers to these related questions:

More Related Contents:

  1. Loading .sql files from within PHP
  2. How do detect that transaction has already been started?
  3. Selecting all fields except only one field in mysql [duplicate]
  4. php, mysql – Too many connections to database error
  5. avoiding MySQL injections with the Zend_Db class
  6. If number have inside number string [closed]
  7. recurring system my sql query [closed]
  8. MySQL query won't update database [closed]
  9. Cannot modify header information [duplicate]
  10. Gather column name of a table from database [closed]
  11. PHP sending form data to the database
  12. inserting information and image in php and mysql
  13. CodeIgniter – foreach loop
  14. Project Links do not work on Wamp Server
  15. SET NAMES utf8 in MySQL?
  16. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  17. Why doesn’t MySQL support millisecond / microsecond precision?
  18. Real escape string and PDO [duplicate]
  19. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  20. Run a mySQL query as a cron job?
  21. Can I create a database using PDO in PHP?
  22. MySQL PHP incompatibility
  23. PHP PDO and MySQLi [duplicate]
  24. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  25. How to store an array into mysql?
  26. Error 1148 MySQL The used command is not allowed with this MySQL version
  27. How can I debug why simplest MySQL query returns false?
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment