Tos Web Developer provides insights, tutorials, and advice around topics including content strategy, design, Drupal Development, Drupal Custom Module Development, Drupal 8 Custom themes, PHP, Server, Twig, and more

Mysql

MYSQL large database import using terminal in windows 10/8

A+compilation+of+reading+material+%25E2%2580%2594+books+and+blogs+%25E2%2580%2594+by+MySQL+Experts



Simple few steps you can import database large database very fast way this way is not usually to use this different way to import database.

Step 1:-  Open terminal on the windows machine

Step 2:-  Goto to the XAMPP path - D:\Xampp\mysql\bin>  like this. using  'cd' command.

Step 3:-  
D:\Xampp\mysql\bin> mysql -u root -p
                 
Step 4:- You can go to the
 MariaDB monitor.

Step 5:- Select database name using - use {database_name}

Step 6:- After select database, it time to import database enter following command

              source C:\Users\ompmanka1\Desktop\example
.sql

Step 7:- After the database is imported. goto to PHPMyAdmin and check.

Thanks for following TOsTech

Like our Facebook page
https://goo.gl/2kaXBc

Subscribe us on YouTube and help us grow
https://goo.gl/BQuUy3

Follow on Instagram account
https://goo.gl/LVWUQ5

Also, Read And Follow our Blog
https://goo.gl/55WrBR

Follow on LinkedIn -
https://goo.gl/tXXfAy

Thank u and keep supporting👍

- TOsTech team

Stay Connected Stay Techy

TOsTech Team

No comments:

Post a Comment

| Designed And Blog Post by www.toswebdeveloper.com