PHP script for MySQL database import

Posted: January 19, 2012 in Php

PHP script for MySQL database import

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:



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.
To test if the import was successful, log in to your phpMyAdmin tool from your cPanel and review the database.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s