.sql file execution using php and pdo

Question

I want to run a .sql file using PHP and PDO.

It is working fine in my local environment. But in live it executes only 3500 lines from my SQL file.

Below this is my PHP code:

define('SITE_URL', 'http://' . $_SERVER["SERVER_NAME"] . '/');
define('DIR_URL', $_SERVER["DOCUMENT_ROOT"] . '/');
$db = new PDO("mysql:host=$db_host;dbname=$db_name",$db_username,$db_pass);
$sql = file_get_contents(SITE_URL.'database/mysql.sql');
$db->exec($sql);

My problem is mysql.sql file is executing only 3500 lines after that it does not execute the remaining lines in live environment.

Thanks in advance.

Possible duplicate of [Running MySQL \*.sql files in PHP](https://stackoverflow.com/questions/4027769/running-mysql-sql-files-in-php) — Nigel Ren, Jun 29 '18 at 12:31
@NigelRen my problem is file execution not work after 3500 line. — Gomzy, Jun 29 '18 at 12:50

score 0 · Accepted Answer · answered Jun 30 '18 at 08:39

0

After using this script my mysql.sql file imported successfully.

Thanks to Oshane Bailey

answered Jun 30 '18 at 08:39

Gomzy

431
4
14

.sql file execution using php and pdo

1 Answers1