How to Load or Import data from a Text File into a table in a database MYSQL.
This video will guide you through the steps you need to take to import data from a .text file to a table in your database! All the best!
00:00 Intro
00:43 Default file location
01:34 Confirm the default location
02:10 Change the location settings to allow many locations process
02:43 Give administrative power to the user account.(You can change that later)
03:20 Change the location settings in the file
03:58 Restart the server
04:31 Check if the changes have been updated
05:04 Enable Load
05:30 Load data into the table
06:16 The end