XAMPP phpMyAdmin: Importing of Large SQL files to database

phpMyAdmin Error: "You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit." Here's a simple tutorial of importing large sql files to your phpMyAdmin database. Summary: 1. Modify the my.ini of the mysql module from the XAMPP Control Panel. The only thing to modify from the my.ini file is the buffer size. Change 8M to whatever value that you want for as long as it is more than the file size that you are trying to import. Then save the changes. 2. Restart the MySQL module from the XAMPP Control Panel to enable the changes that you made. 3. Open Command Prompt. 4. Change your directory to where the bin folder of the mysql module of your XAMPP is located. e.g. "C:\xampp\mysql\bin" 5.In your command prompt, type in "mysql -u username -p database [less_than_symbol] sql.file" **Make sure you are using the less-than symbol to import. Using greater-than symbol will export files. Make sure the database is already created** 6. Provide username's password 7. Press enter and wait for a couple of seconds to minutes. It takes longer when file size is huge. 8. Verify the database if the files are imported. Thank you for watching this video tutorial. Don't forget to drop comments, hit like, and subscribe to this YouTube Channel :D Credits to Reev Music for the background music. https://www.youtube.com/watch?v=rGIAQm-ixAQ