How to import a large SQL file in XAMPP?

XAMPP is a popular web development stack package created by Apache Friends. It allows developers to easily install and configure Apache, MySQL, PHP, and other software on their devices.

XAMPP  is widely used to develop and test web applications before launching them into the markets. Such as, when working with large SQL files (Structured Query language), importing these files onto the MySQL database in XAMPP is quite a process. SQL files store the data and structure of a MySQL database. They are usually exported from one database and imported into another to transfer data. This process aids developers in testing their applications with actual data.

Visit- Apache friends.

Steps to import large SQL files in XAMPP easily

Step 1: launch the XAMPP Control Panel

Click the XAMPP icon on your desktop or go to the XAMPP folder under Programme Files to launch the XAMPP Control. 

Step 2: start the MySQL server on the Control Panel

Click the start button next to the MySQL module on the XAMPP Control Panel to launch the server. 

Step 3: Open phpMyAdmin

After running the server in step 2, Click the admin button beside the MySQL module to launch the phpMyAdmin. (phpMyAdmin allows the user to manage MySQL databases)

Step 4: pick the database

Click on the name of a database to Pick the database on phpMyAdmin where you want to import the SQL file. 

Sep 5: Select the import tab

After picking the database, select “Import” from the top menu bar. You will now see importing page.

Step 6: Select the individual SQL file for importing process

Click on the choose file tab To choose the SQL file on the import page. 

Step 7:Set the Import Settings 

The import options are changeable after picking the SQL file. While importing a huge file, phpMyAdmin, by default, tries to import the whole file at once, which can lead to complications. Select the “Partial import” option to avoid this so you can adjust the “Maximum import size” to a smaller value. You can also edit the character set and the format of the file.

Step 8:Start the import. 

Once the import preferences have been set, click “Go” to start the import procedure.

This part of the process is time-consuming, depending on the file size and your computer’s speed. The “Import” page lets you track the import’s development.

Step 9:Verify the import 

Check the data’s accuracy after the import to ensure the process is correct.

Verify the database tables to ensure the process of importing data is correct.

Conclusion

Make sure to follow the nine steps to smoothly import large SQL files in XAMPP.

See also: Install MySQL on Ubuntu