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