how to import .sql file in mysql databse with php

Question

I'm trying to import .sql file into mysql database using php but I can't

Am using like this code:

<?php

$sql = mysqli_connect('localhost', 'root', '123123', '');
mysqli_query($sql, "USE vmail");
mysqli_query($sql, "source insert.sql");
mysqli_close($sql);

echo ("Done")


?>

How can I import it??

thnx.

Duplicate of how to import .sql file in mysql database using php — adarsh hota
– adarsh hota, Commented Feb 24, 2015 at 11:23
looks like duplicate of this stackoverflow.com/questions/19751354/… — user1627167
– user1627167, Commented Feb 24, 2015 at 11:24

Your Common Sense · Accepted Answer · 2017-08-09 13:07:57Z

13

Try this code. You have to read the sql file first and than execute:

eg:

$sqlSource = file_get_contents('insert.sql');

mysqli_multi_query($sql,$sqlSource);

edited Aug 9, 2017 at 13:07

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

answered Feb 24, 2015 at 11:23

teo

8011 gold badge6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Metalik Over a year ago

Will this work when file contains comments or empty lines ?

Collectives™ on Stack Overflow

how to import .sql file in mysql databse with php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related