Database import issue mysql file on phpmyadmin

 

Import Using MySQL Command Line (Recommended)

Command line importing bypasses limitations in phpMyAdmin, making it ideal for very large databases:

1. Open Command Prompt and navigate to the MySQL folder:

   shell
   cd C:\xampp\mysql\bin
   

2. Run the following command to import the database:

   shell
   
   mysql -u root -p database_name < path\to\your\databasefile.sql
   

   Replace database_name and path\to\your\databasefile.sql with your database’s name and the path to the SQL file.

if ask for password then enter with blank if you don't have any password

Alternative way:-

1.mysql -u root -p buzfi

2.Enter the password when prompted.

3.Run the following command to import the file:

source C:/xampp/htdocs/buzfi/buzfi_ecom.sql;