A SQL file is a simple text file which contains a list of SQL queries inside it. It contains SQL code to modify the contents of a relational database. The SQL statements can create and modify the database structures and other SQL operations.
Steps to import SQL file using phpMyAdmin:
The MySQL file backup can be imported into your database directly through phpMyAdmin in cPanel. First, create a database in cPanel and assign users to it. Then you can directly import the SQL file in it which will take just a few minutes time. Follow the below steps to import a SQL file into the database.
Step 1: Login to cPanel, access the database through the option phpMyAdmin.
Step 2: Select the database in which files have to be imported and go to the tab ‘Import’.
Step 3: Upload the SQL file through the option ‘Choose File’ with the format .sql.zip. The maximum upload limit is 50Mb.
Step 4: Browse the .sql file in the local and then click the option ‘Go’. Now the files will be imported into the database.