• By Rasika Preethiraj
• In SQL
• Posted 14 Aug 2015

Import a large mysql database from terminal / cmd

Most in cases, phpmyadmin not allows to import your database if you have a large mysql database with .sql extension. At this moment , you can easily import your database to mysql by using windows cmd or any terminal. In this post , we use windows cmd.

First open a command prompt and you need to goto the exact mysql installation path/bin . if you are using xampp installation, the path would be C:\xampp\mysql\bin

cd C:\xampp\mysql\bin

and lets copy your .sql file , where the database you need to import. lets say mydb.sql.

Then run the following command to import your database

mysql -u username -pPlainPassword databasename < filename.sql

example:

mysql -u USER -p123 wp_users < mydb.sql

• 0
• 170

Rasika Preethiraj

A technophile at icrony since 2012, In a quest to programmatic automations for scaled organisations through the use of python, php, autoit and machine learning

Comments

• php variables, functions, if, for, while, switch syntax - quick through

  27 Sep 2013 / PHP

• Copy/Extact lines from files inside folder, with a search word to a text file - windows batch

  24 Nov 2021 / WINDOWS

• AWS ses email policy to restrict recipients

  21 Dec 2022 / AWS

• Install and get started with autoit

  22 Oct 2021 / AUTOIT

• Replicate virtual machine tags to its all resources - azure cli

  21 Feb 2024 / WINDOWS

• Send Email from Windows Computer using powershell script

  28 Jul 2023 / WINDOWS

• Record video stream from rtsp enabled dvr camera using docker

  12 Feb 2023 / DOCKER

• Simple File Browser from web browser with docker

  21 Jan 2023 / DOCKER

• AUTOIT
• AWS
• DOCKER
• JAVASCRIPT
• LINUX
• NEWS
• PHP
• PYTHON
• SQL
• WINDOWS