exec() for importing sql file

Question

how can i use exec() method to import a .sql file in php? what is its output?

Answer 1

You would need to use the command line client. For example, using mysql:

  exec('mysql db_name < script.sql > results')