This is a useful feature when the file cannot be managed by PHPMyAdmin. When Importing a database and it takes more than 2 minutes, then use this method
- Create a database, user and give users the rights ( Copy and paste these values)
- Upload the .SQL file to the Home directory public_html Use ftp or File manager . Verify via cd /home/username/public_html
- Use the command below.
mysql -p -u username_user username_db < myqsl_name.sql
- When prompted for a password, use the information from (1) above
Congratulations you have now imported your SQL file into your database.