in this article, i will share with you how to import a large database in MySQL using the command line. this is a very important topic and tips and it will help you more.
as you know. sometimes you have no access to root users in cPanel, WHM, and AWS then you have no access to increase MySQL database upload limit and you have a very large database and you want to upload it on your live database. so, at that time you have only one and best option to upload your large database in MySQL using the command line.
first, we need to login to our MySQL using the following command.
<!-- syntax --> sudo mysql -u mysql_user_name -p <!-- example --> sudo mysql -u root -p
Hit the enter after type this command. then the enter your MySQL password after entering the correct password then you can see the following text in your command line.
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.7.31-0ubuntu0.16.04.1 (Ubuntu) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
it means you can successfully login in to your MySQL using the CMS.
After successfully login the second thing we need to choose our database using the following command.
<!-- syntax --> use database_name <!-- example --> use payment_terminal
after running the above command in your terminal then you can see the following output in your command line.
After the chosen database then now how to imports large tables set in our database using the following command.
<!-- syntax --> source database_file_name_with_path <!-- example --> source /home/dell/Downloads/payment_terminal.sql
Hit the above command and wait till your database import process not completed. and it will be a very fast way to import any large database in your MySQL.
i hope you like this article.
How to Install Django in Ubuntu 20.04 LTSDjango is a free and open-source high-le...
How to toggle text inside and element on click using jQueryUse the jQuery text() method You can...
How to change OLD Password with Validation in LaravelHere, i will show you old password valid...
How to customize file input type box using CSS and jQueryUse the CSS Opacity and Positioning meth...
How to create jQuery slide left and right toggle effectUse the jQuery animate() metho...