Load db.sql file into db using PDO

Question

i use file_get_contents to get the queries from the file but now how can i load all of them into a mariadb database by using PDO? With mysqli i know there is a function called mysqli_multi_query is there another function that does the same but with PDO?

`pdo->exec` will probably not complain when executing multiple queries — apokryfos, May 15 '18 at 15:25

score 0 · Answer 1 · answered May 25 '18 at 17:35

0

Do not use multi-query.

Is this a CSV file? If so, you should not need file_get_contents; instead use LOAD DATA INFILE ...

answered May 25 '18 at 17:35

Rick James

135,179
13
127
222

Load db.sql file into db using PDO

1 Answers1