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:

 

 <?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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s