How to execute mysql script file in PHP?

Question

I have almost 100MB of example.sql file. (Actually data export file from another database)

I want to give user the ability to run this file through some interface in my application. Can you please guide me how can i do that? Should i treat it as simple text file? Either there is any quick way???

In other words, I want to add same functionality as we have in phpMyAdmin, The import functionality.

If you can refer me some class on PHPclass.org that will be great.

let user upload that file and push it in mysqldump or something like that — user973254
– user973254, Commented Oct 20, 2011 at 17:55

genesis · Accepted Answer · 2011-10-20 18:01:27Z

4

function import_file($filename){
    if ($file = file_get_contents($filename)){
        foreach(explode(";", $file) as $query){
            $query = trim($query);
            if (!empty($query) && $query != ";") {
                mysql_query($query);
            }
        }
    }
}

can be called with

import_file("files/files.sql");

_{However, this function will not work properly if file includes semicolon ; somewhere else than at the end of the query}

edited Oct 20, 2011 at 18:01

answered Oct 20, 2011 at 17:55

genesis

51.1k20 gold badges99 silver badges127 bronze badges

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

11 Comments

Salman Aslam Over a year ago

I am just trying, seems like best option. Will be back to select it as accepted answer :)

Marc B Over a year ago

This'll blow up hideously if any of the actual data contains a ;. But for quick 'n dirty, it's "good enough"

genesis Over a year ago

@MarcB: Wow, didn't even think about this situation. In that case there would be a lot of things to be considered.

Marc B Over a year ago

@Herbert: php's mysql driver disables multiple queries in a single call as a security measure against sql injection attacks.

genesis Over a year ago

@Rocket: It's fortunately when speaking about SQLi. This can't happen with mysql_query()

|

John Watson · Accepted Answer · 2011-10-20 18:02:22Z

2

Create a file upload form that allows trusted users to upload the file to your server. Then call the mysql command-line tools from PHP to import the data into your database. Doing it by trying to explode(";", ...) will fail if there are any quoted semicolons within the imported data.

answered Oct 20, 2011 at 18:02

John Watson

2,5831 gold badge17 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to execute mysql script file in PHP?

2 Answers 2

11 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related