davcs86/php-mysqlimporter

PHP class for importing big SQL files into MySQL.

PHP Mysql Importer

PHP class for importing big SQL files into MySQL server., _(*1)

This class comes to overpass the problem in phpMyAdmin (and others) , when you can't upload files of decent size through the browser upload., _(*2)

With this class you get the same function, just by uploading the file via FTP and doing the importing with 3 simple commands, e.g., _(*3)

include("php-mysqlimporter.php");
$mysqlImport = new MySQLImporter("localhost", "user", "password");
$mysqlImport->doImport("yourfile.sql");

Links

• Homepage: http://d-castillo.info/projects/php-mysqlimporter
• Source: https://github.com/davcs86/php-mysqlimporter
• Bugs: https://github.com/davcs86/php-mysqlimporter/issues

Requirements:

1. PHP 5.0+
2. MySQLi extension

Download

• As zip from this repository: https://github.com/davcs86/php-mysqlimporter/archive/master.zip, _(*4)

• With git from a terminal:, _(*5)

git clone https://github.com/davcs86/php-mysqlimporter.git

• Using Composer, add "davcs86/php-mysqimporter" as a dependency in your project's composer.json file:

{
    "require": {
        "davcs86/php-mysqlimporter": "dev-master"
    }
}

How to Use:

Initialization

$mysqlImport = new MySQLImporter($host, $user, $password, $port);

Basic Importing

$mysqlImport->doImport("./sqlfiles/test1.sql");

Error Reporting

if ($mysqlImport->hadErrors){
    // Display errors
    echo "<pre>\n";
    print_r($mysqlImport->errors);
    echo "\n</pre>";
} else {
    echo "<strong>File imported successfully</strong>";
}

Advanced Importing

1) You can specify database.
NOTE: This doesn't override the clause USE in the file, but sets an initial database., _(*6)

$mysqlImport->doImport("./sqlfiles/test1.sql", "initial_db_name");

2) You can create the database (if it doesn't exist)., _(*7)

$mysqlImport->doImport("./sqlfiles/test1.sql", "initial_db_name", true);

3) You can drop the database and then create it., _(*8)

$mysqlImport->doImport("./sqlfiles/test1.sql", "initial_db_name", true, true);

4) Or just drop it. Particularly useful if you already got a CREATE statement in your SQL file., _(*9)

$mysqlImport->doImport("./sqlfiles/test1.sql", "initial_db_name", false, true);

Support

Drop me line on: http://d-castillo.info/contactme/ or to: davcs86@gmail.com, _(*10)

Donations

Did this project help you to save (or earn) some money?
Please, support to the author by making a small donation., _(*11)

, _(*12)