PHP script for MySQL Large database import
Author: admin admin Reference Number: AA-00332 Views: 4183 Created: 2013-04-11 13:00 Last Updated: 2013-04-11 13:00 0 Rating/ Voters

You should start by creating a file called for example import.php and placing it in your public_html folder.

Then edit the file and paste the following code in it:

 <?php

passthru("nohup mysql -u USERNAME -pPASSWORD DBNAME < dump.sql");

 ?>


Where USER,PASSWORD and DBNAME are your details for the database in which you want to import the dumped file, and dump.sql is the file you want to import. Make sure you give the correct path to the dump.sql file.

When you are ready, open your browser and type in the URL to the update.php file, e.g. http://yourdomain.com/update.php.

To test if the import was successful, log in to your phpMyAdmin tool from your cPanel and review the database

Quick Jump Menu