This script import the sql queries from a file to mysql database.

Tested : PHPMyAdmin Export, Adminer Export, InfiniteWP Database Backup file, ManageWP Database Backup file and WP Time Capsule Database Backup file

Steps to Run the secript.

1.Clone the repo

git clone https://github.com/thamaraiselvam/import-database-file-using-php.git

OR

Download here - import-database-file-using-php

2.Open the import.php and replace following varialbles with your Database credentials

$filename = 'filname.sql';

$mysql_host = 'localhost';

$mysql_username = 'USERNAME';

$mysql_password = 'PASSWORD';

$mysql_database = 'DB_NAME';'

3.Run the import.php

That's it. your database is imported :)

Note: If you have very large database file then you have to enable the following line in the import.php to avoid PHP timeouts

set_time_limit(0);

If you want to import very large database without affect the server performance or memory peak. Try following repo.

https://github.com/thamaraiselvam/import-large-database-file-using-php