phpMyAdmin is a feature-rich tool written in PHP, that will give you 100 % control over a MySQL database. You may do practically everything - set up fields, rows and tables, delete them or modify their content, export or import a whole database or only a certain part of it, and execute MySQL commands. The tool is necessary in case you want to switch hosting companies, because you may conveniently create a full backup of a database in different formats (SQL, CSV, XML). You will end up with a single file which contains the whole content of the database, so you could download it from the present provider, upload it to the server of the new one and import it via the same tool on their end. Your website shall look exactly the same, because all script apps 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, a phrase or a link, for instance.
phpMyAdmin in Cloud Hosting
phpMyAdmin is a part of each and every Linux cloud package that we provide and it is accessible through our tailor-made Hepsia Control Panel. A small phpMyAdmin icon will be shown on the right side of any database you create inside the MySQL Databases section of the CP and by clicking on the icon for the database which you want to access, you shall be logged into the application automatically in a new tab of your browser. Then you can do everything you would like - export the whole or a part of the content, import a database, run SQL queries, search and modify 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 must know the database account information. The last function is handy if you have to give access to a database to a third-party.