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. 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.
cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!