How to import larger file database in phpmyadmin using command prompt

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)

Step5:

Enjoy Folks

 

 

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger×Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger×