run mysql.sql using php

Question

i have mysql file. it has .sql extension. how to run that "mysql" file using php script? how is the script should be? the mysql file is already on the server, and i want to run this query using php file which is placed on the same place with mysql file...

you could use exec like stackoverflow.com/questions/1464571/exec-for-importing-sql-file — codercake
– codercake, Commented Mar 2, 2011 at 5:09

Daric · Accepted Answer · 2011-03-02 05:43:59Z

2

You could do this

$query=file_get_contents($file);

$mysqli->multi_query($query);

mysqli::multi_query can do the job.

answered Mar 2, 2011 at 5:43

Daric

16.9k11 gold badges44 silver badges58 bronze badges

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

2 Comments

Gaurav Over a year ago

as written in this doc : Executes one or multiple queries which are concatenated by a semicolon.

Daric Over a year ago

@gaurav: you are right But it will take care of value which contains ;

ajreal · Accepted Answer · 2011-03-02 05:31:46Z

0

the mysql file is already on the server

dun use PHP ....

Linux ???

install mysql client, and run a shell like

mysql -u root -ppassword -P port_number < any.sql

Windows ???

still need to install mysql client, repeat from above

if you don't have ssh access to the server, and don't have exec right

read/prepare again the mysql file by breaking multiple queries then execute one-by-one

edited Mar 2, 2011 at 5:31

answered Mar 2, 2011 at 5:25

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Collectives™ on Stack Overflow

run mysql.sql using php

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related