Categories
MySQL

MySQL: Import Database from Command Line

Copy your sql file and paste it inside xampp/mysql/bin directory. Let’s say our sql filename is: “userinfo.sql”.

Now, open command line and run following commands.

Categories
MySQL

MySQL: Import Table from CSV File

Run following command from command line

If your MariaDB doesn’t support this command, maybe you need to add following in my.ini file.

I am using Xampp on Windows 10. For me, my.ini file is located at:

Categories
MySQL

MySQL: Dynamic Column from Row