phpMyAdmin
Learn more about what phpMyAdmin is and how to make use of it as a management tool for all of your MySQL databases.
phpMyAdmin is a feature-rich tool developed in PHP, which shall provide you with 100 % control of a MySQL database. You could do practically anything - set up fields, rows and tables, remove them or change their data, export or import an entire database or just a certain part of it, and execute MySQL commands. The tool is essential in case you want to switch web hosting providers, because you can easily create a full backup of a database in a variety of formats (SQL, CSV, XML). You shall end up with just one file containing the entire content of the database, so you could download it from the present provider, upload it to the hosting server of the new one and import it through the same tool on their end. Your website shall look exactly the same, for the reason that all script applications store their content within a database. With phpMyAdmin you may also conveniently search and replace information of your choosing across the entire website - a word, an expression or a link, for instance.
phpMyAdmin in Shared Website Hosting
phpMyAdmin is a part of every Linux shared website hosting package we offer and it's accessible via our custom-made Hepsia Control Panel. A little phpMyAdmin icon will be shown on the right side of each database you create in the MySQL Databases section of the Control Panel and by clicking on the icon for the database that you want to access, you will be logged into the app instantly in a new tab of your Internet browser. Then you can do everything you'd like - export the whole or part of the content, import a database, run SQL queries, search and replace terms. If you do not want to employ the CP, you will also be able to sign in through a direct phpMyAdmin login page, but you ought to know the database account information. The last feature is helpful if you have to provide access to a database to a third-party.