How to upload sql file to database using PhpMyAdmin in Xampp

Posted by

To upload an SQL file to your database using phpMyAdmin in XAMPP, you would typically use the phpMyAdmin web interface rather than a command-line interface. However, if you prefer to import an SQL file from the command line (or if the file is too large to import via the phpMyAdmin web interface), you can use the MySQL command line tool provided with XAMPP.

Using the Command Line

If the SQL file is too large or if you prefer using the command line, you can use the MySQL client that comes with XAMPP:

Open a Terminal or Command Prompt:

  • Navigate to your XAMPP’s MySQL bin directory, typically
cd /opt/lampp/bin

Log in to MySQL:

  • Use the following command to connect to your MySQL server. Replace username with your MySQL username (often root) and database_name with the name of the database you want to import your SQL file into:
./mysql -u username -p database_name

You will be prompted to enter your MySQL password.

Import the SQL File:

  • Use the following command to import your SQL file. Replace file.sql with the path to your SQL file:
./mysql -u username -p database_name < /path/to/your/file.sql
root@Jami2:/opt/lampp/bin# ./mysql -u root events < /home/jami/events.sql
root@Jami2:/opt/lampp/bin# ./mysql -u root trips < /home/jami/trips.sql

use -p in above command if you have defined password for the database.

This command does not output progress and will complete without messages unless there are errors.


  • Permissions: Ensure that the SQL file is readable by the user running the MySQL command.
  • File Path: Provide the absolute path to the SQL file if it is not in the current directory.
  • Large Files: For very large SQL files, consider using command-line tools as they handle large data imports more efficiently than web interfaces.
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x