Click Here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"...<\/p>\n","protected":false},"author":1,"featured_media":1509,"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":[197,12],"tags":[224,33,34,225,226],"class_list":["post-166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-linux","tag-importing-database","tag-phpmyadmin","tag-restoring-database-in-phpmyadmin","tag-restoring-sql-file","tag-restoring-sql-file-in-php-myadin"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/06\/phpmyadmin.jpg?fit=640%2C260&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9NOHH-2G","jetpack-related-posts":[{"id":1812,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/how-to-restore-mysql-database-using-phpmyadmin\/","url_meta":{"origin":166,"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":1948,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/restore-mysql-database-phpmyadmin\/","url_meta":{"origin":166,"position":1},"title":"How to Import\/Restore MySQL Database backup Using phpMyAdmin","author":"Cavin","date":"July 3, 2024","format":false,"excerpt":"Restore MySQL Database - Backups are an important aspect of website maintenance. Backing up your files and databases weekly or monthly, or before making any significant changes, ensure that your files are secure and recoverable in the event of data loss. A backup MYSQL database will save all the data\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\/2024\/07\/cpanel.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1940,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/mysql-database-backup-phpmyadmin\/","url_meta":{"origin":166,"position":2},"title":"How to take MySQL Database backup Using phpMyAdmin","author":"Cavin","date":"July 2, 2024","format":false,"excerpt":"MySQL Database Backup - Backups are an important aspect of website maintenance. Backing up your files and databases weekly or monthly, or before making any significant changes, ensure that your files are secure and recoverable in the event of data loss. A backup MYSQL database will save all the data\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\/2024\/07\/phobackup.jpg?fit=742%2C417&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/phobackup.jpg?fit=742%2C417&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/phobackup.jpg?fit=742%2C417&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/phobackup.jpg?fit=742%2C417&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1961,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/how-to-enable-auto-login-for-phpmyadmin-via-directadmin\/","url_meta":{"origin":166,"position":3},"title":"How To Enable Auto-Login for PHPMyAdmin Via DirectAdmin?","author":"Cavin","date":"July 18, 2024","format":false,"excerpt":"Proper management of your website's databases is the key factor that allows stable operations. PHPMyAdmin, which is a database management tool that has gained popularity today, does the job for you. The autologin feature on PHPMyAdmin through DirectAdmin speeds up the login process, thus saving precious minutes while also avoiding\u2026","rel":"","context":"In "VPS"","block_context":{"text":"VPS","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/vps\/"},"img":{"alt_text":"Auto-Login for PHPMyAdmin","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/puttde.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/puttde.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/07\/puttde.png?resize=525%2C300 1.5x"},"classes":[]},{"id":399,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/installing-lamp-on-centos-7\/","url_meta":{"origin":166,"position":4},"title":"Installing LAMP on CentOS 7 (Apache, MySQL, and PHP)","author":"Cavin","date":"July 5, 2017","format":false,"excerpt":"This tutorial shows, Installing LAMP on CentOS 7 (Apache, MySQL, and PHP) Lets see the installation of the latest PHP versions (7.0 and 7.1) on CentOS 7.3. 1.Adding EPEL repo As a first step we need to add EPEL repo to install latest\u00a0phpMyAdmin by using. #rpm --import \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY* #yum -y\u2026","rel":"","context":"In "CentOS \/ REDHAT"","block_context":{"text":"CentOS \/ REDHAT","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/linux\/centos-redhat\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/centos-lamp.png?fit=811%2C276&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/centos-lamp.png?fit=811%2C276&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/centos-lamp.png?fit=811%2C276&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2017\/07\/centos-lamp.png?fit=811%2C276&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1816,"url":"https:\/\/www.webhostingchennai.co.in\/blog\/change-wordpress-admin-password\/","url_meta":{"origin":166,"position":5},"title":"How to reset\/change WordPress admin password","author":"Cavin","date":"February 21, 2024","format":false,"excerpt":"Change WordPress admin password - Everyone needs to reset one of their passwords from time to time. WordPress makes it easy to change your password if needed, but to do that, you\u2019ll need to have access to the email you used when you created your site. If you don\u2019t, things\u2026","rel":"","context":"In "Wordpress"","block_context":{"text":"Wordpress","link":"https:\/\/www.webhostingchennai.co.in\/blog\/category\/wp\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/reset-admin-password.jpg?fit=1200%2C529&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/reset-admin-password.jpg?fit=1200%2C529&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/reset-admin-password.jpg?fit=1200%2C529&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/reset-admin-password.jpg?fit=1200%2C529&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.webhostingchennai.co.in\/blog\/wp-content\/uploads\/2024\/02\/reset-admin-password.jpg?fit=1200%2C529&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/166","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=166"}],"version-history":[{"count":4,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/166\/revisions"}],"predecessor-version":[{"id":1466,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/posts\/166\/revisions\/1466"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/media\/1509"}],"wp:attachment":[{"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/media?parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/categories?post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhostingchennai.co.in\/blog\/wp-json\/wp\/v2\/tags?post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}