vwedesam / mysql-export-import
import and export mysql Database/Table
dev-main
2021-01-26 12:17 UTC
Requires (Dev)
- phpunit/phpunit: ^5.7
This package is auto-updated.
Last update: 2024-09-26 20:42:06 UTC
README
MySQL is a popular Linux-based database program. As a database, MySQL is a versatile application. It can be used for something as simple as a product database, or as complex as a Wordpress website..
This package will help you Export a MySQL database and Import it from a dump file in PHP.
Features!
- Export MySQL database and Tables to a file (.sql)
- Import it from a file
See SQLITE Export And Import LIbraray for SQLITE DB EXport and Import
Installation
This Library requires PHP to run.
$ composer require vwedesam/mysql-export-import
Example:1
using helper function mysqlExporter" and MysqlImporter with connection "params"
require "../vendor/autoload.php"; $host = "localhost"; $user = "root"; $pass = ""; $name = "my_mysql_db"; // Connection Parameters $connection_params = [ 'host' => $host, 'name' => $name, 'user' => $user, 'pass' => $pass ]; // parameters // 1: Mysql database Instance <instance> // 2. mysql tables to be export <Array> // 3. backup name <String> // 4. connection parameters <Array> MysqlExporter(null, ['products'], false, $connection_params); // parameters // 1: Mysql database Instance <instance> // 2. full path eg "../filepath/db.sql" to mysql dump file (.sql, .zip) // 3. connectoin params <Array> MysqlImporter(null, $sql_content, $connection_params); // return: true / false
Example:2
using helper function mysqlExporter and MysqlImporter with "Mysql Instance"
require "../vendor/autoload.php"; $host = "localhost"; $user = "root"; $pass = ""; $name = "my_mysql_db"; $dsn = "mysql:dbname=$name;host=$host"; // PDO instance $db_instance = new \PDO($dsn, $user, $pass); MysqlExporter($db_instance); MysqlImporter($db_instance, $sql_content); // return: true / false
More Examples
Mysql Export Import with classes, functions and connection params
License
MIT