Step1:
Welcome to designer blog. We are going to discuss how to import the larger file in phpmyadmin using the command prompt
Step2:
Open the command prompt and go the MySQL path location Ex : F:\xamp\mysql\bin
Step3:
F:\xamp\mysql\bin > mysql -u root -p freshbenies_broker < E:\freshbenies_broker.sql
U denotes - Username
P denotes - password (As it empty)
Database name - freshbenies_broker
< denotes - Importing file
Path - E:\freshbenies_broker.sql
Step4:
Once file is imported,You can go and see in Phpmyadmin...
Latest Method :
Import Syntax:
Entering to MariaDb
Ayaan@DESKTOP-47QT599 d:\xamp-5.6.40
# mysql -u root -p -h localhost
MariaDB [(none)]> SHOW DATABASES; ( show the database command)
MariaDB [(none)]> CREATE DATABASE ( Create the database Inventory)
MariaDB [(none)]> use inventory (database name)
MariaDB [inventory]> source E:\inventory.sql; (Importing the db using source syntax)
