How to import SQL ( more than 50MB) through SSH<\/span><\/strong><\/p>\n ( i ) For already created Database:<\/strong><\/span><\/p>\n Step1 :<\/strong> Login to your SSH with root user.<\/p>\n Step2 :<\/strong> Use command<\/p>\n Step3 : <\/strong>Enter the password to start restoring the database.<\/p>\n <\/p>\n ( ii ) Creating and importing Database:<\/strong><\/span><\/p>\n Step1 :<\/strong> Login to your SSH with root user.<\/p>\n Step2 :\u00a0<\/strong>Enter into MySQL using “root” user identified by password.<\/p>\n Step3 :<\/strong>Create the database<\/p>\n Step4 :<\/strong>Create the user<\/p>\n Step4 :\u00a0<\/strong>Grant ALL privileges onthe new database to the new User<\/p>\n Step4 :\u00a0<\/strong>Insert data from source.sql<\/p>\n ...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9NOHH-2x","jetpack-related-posts":[{"id":1812,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/how-to-restore-mysql-database-using-phpmyadmin\/","url_meta":{"origin":157,"position":0},"title":"How to Restore MySQL Database Using phpMyAdmin","author":"Cavin","date":"February 19, 2024","format":false,"excerpt":"Most WordPress hosts, including Webhostingchennai, have automated backups that allow you to restore in case of an emergency. However, there might be times where you need to restore and or upload your own MySQL database manually. This could be because you are migrating hosts or perhaps you want to do\u2026","rel":"","context":"In "cPanel"","block_context":{"text":"cPanel","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/cpanel\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/restore-mysql.jpg?fit=799%2C500&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/restore-mysql.jpg?fit=799%2C500&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/restore-mysql.jpg?fit=799%2C500&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/restore-mysql.jpg?fit=799%2C500&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":461,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/installing-cacti-monitoring-tool-on-centos-7\/","url_meta":{"origin":157,"position":1},"title":"Installing Cacti Monitoring Tool on CentOS 7","author":"Cavin","date":"July 11, 2017","format":false,"excerpt":"Installing Cacti Monitoring Tool on CentOS 7 Let us see about cacti,\u00a0Cacti is a complete front end \u00a0RRDTool(round-robin database tool), it stores all of the vital information to create graphs and populate them with data in a MySQL database. Along with this, it is capable\u00a0 to maintain Graphs, Data Sources,\u2026","rel":"","context":"In "MONITORING TOOLS"","block_context":{"text":"MONITORING TOOLS","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/monitoring-tools\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/cacti.jpg?fit=640%2C260&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/cacti.jpg?fit=640%2C260&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/cacti.jpg?fit=640%2C260&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":777,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/installing-zabbix-server\/","url_meta":{"origin":157,"position":2},"title":"Installing Zabbix Server 3.4 on CentOS 7","author":"Cavin","date":"March 19, 2018","format":false,"excerpt":"How to install Zabbix Server 3.4 on CentOS 7 Installing Zabbix Server Zabbix is an enterprise open source monitoring software for networks and applications. It is designed to monitor and track the status of various network services, servers, and other network hardware. Zabbix uses MySQL, PostgreSQL, SQLite, Oracle to store\u2026","rel":"","context":"In "MONITORING TOOLS"","block_context":{"text":"MONITORING TOOLS","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/monitoring-tools\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/03\/zabbix.jpg?fit=660%2C260&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/03\/zabbix.jpg?fit=660%2C260&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/03\/zabbix.jpg?fit=660%2C260&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":1017,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/how-to-install-mysql-centos7\/","url_meta":{"origin":157,"position":3},"title":"How to Install MySQL 8.0 on CentOS 7","author":"Cavin","date":"August 14, 2018","format":false,"excerpt":"How to Install MySQL 8.0 on CentOS 7 In this article, we are going to see how to install MySQL 8.0 on CentOS MySQL server is the most popular open source relational database management system (RDBMS). MySQL has become the leading database choice web-based applications, Used by high profile web\u2026","rel":"","context":"In "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/08\/mysql8.jpg?fit=640%2C240&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/08\/mysql8.jpg?fit=640%2C240&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2018\/08\/mysql8.jpg?fit=640%2C240&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":166,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/restore-sql-file-through-phpmyadmin\/","url_meta":{"origin":157,"position":4},"title":"How to Restore SQL file through phpMyAdmin","author":"Cavin","date":"June 28, 2017","format":false,"excerpt":"How to Restore SQL file through phpMyAdmin Step1 : Login to your cPanel. Step2 : Click \"phpMyAdmin\" and Click your username to see the expanded list of database. \u00a0 Step3 : Choose the database you need to import \/ restore. \u00a0 Step 4 : Click \"Import\" tab, followed by Choose\u2026","rel":"","context":"In "DATABASE"","block_context":{"text":"DATABASE","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/06\/phpmyadmin.jpg?fit=640%2C260&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/06\/phpmyadmin.jpg?fit=640%2C260&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/06\/phpmyadmin.jpg?fit=640%2C260&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":590,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/installing-cwp-on-centos-7\/","url_meta":{"origin":157,"position":5},"title":"Installing CentOS Web Panel on Centos 7","author":"Cavin","date":"August 5, 2017","format":false,"excerpt":"In this tutorial we are going to see, how to install and configure\u00a0CentOS Web Panel on Centos 7 About CentOS Web Panel CentOS Web panel(CWP),\u00a0is a free, Open Source control panel that can be widely used for deploying a Web hosting environment easily. Unlike other Control panels, CWP is automatically\u2026","rel":"","context":"In "VPS"","block_context":{"text":"VPS","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/vps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/08\/CWPmain.jpg?fit=640%2C260&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/08\/CWPmain.jpg?fit=640%2C260&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/08\/CWPmain.jpg?fit=640%2C260&ssl=1&resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":11,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/157\/revisions\/159"}],"wp:attachment":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}mysql -u user_name<\/em> -p -h localhost data_base_name<\/em> < \/home\/user_name<\/em>\/public_html\/sql file_name.sql<\/b><\/pre>\n
#mysql -u root -p<\/em><\/pre>\n
mysql> CREATE DATABASE NEWDB;<\/em><\/pre>\n
mysql> CREATE USER 'newuser'@'localhsot' IDENTIFIED BY 'newpass';<\/em><\/pre>\n
mysql> GRANT ALL PRIVILEGES ON NEWDB.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpass';<\/em><\/pre>\n
mysql> SOURCE source.sql<\/em><\/pre>\n","protected":false},"excerpt":{"rendered":"