Copy large files into MySQL DB

#mysql #database #xampp #webdev

I recently wanted to copy a large file into my MySQL database (I'm using phpmyadmin) and I was having an error because the file was too large.
Here are the steps I followed to copy it successfully:

Step 1: Configure XAMPP for Large File Imports

Open the XAMPP Control Panel.
Click on the "Config" button for the Apache server.
Select "php.ini" to edit the PHP configuration file.
Find and update the following settings:

upload_max_filesize = 100M post_max_size = 100M max_execution_time = 600
Adjust the values according to the size of your large file.

Save the changes and restart the Apache server.

Step 2: Prepare Your MySQL Database

Open phpMyAdmin from the XAMPP Control Panel.
Create a new database or select an existing one where you want to import the data.
Create a table with the appropriate columns to match the data in your file.

Step 3: Choose the Right File Format

Ensure your large file is in a format suitable for importing into MySQL. CSV (Comma-Separated Values) is a common choice.

Step 4: Use MySQL Command-Line Tools

Open a command prompt or terminal and navigate to the XAMPP MySQL bin directory. Use the following command to import the file:

mysql -u your_username -p your_database_name < path/to/your/large_file.sql

Replace 'your_username', 'your_database_name', and the file path accordingly. Enter your MySQL password when prompted.

Congratulations! You've successfully imported a large file into your MySQL database using XAMPP. These steps should help you efficiently manage large datasets.
Thank you for reading this post