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 check or uncheck a checkbox dynamically using jQueryUse the jQuery prop() method You can...
How to Create Python Virtual Environments on Ubuntu 18.04Python virtual environment is a self-con...
Foreach loop through multidimensional array in PHPUse the PHP nested loop You can simpl...
How to Load Local JSON File Using jQueryUse the jQuery $.getJSON() Method You...
How to Detect Change in a Text Input Box in jQueryUse the input Event You can bind the&...