Find out more about what phpMyAdmin is and the way to employ it as an administrative instrument for all your MySQL databases.
phpMyAdmin is a feature-rich tool written in PHP, that will give you complete control over a MySQL database. You can do practically anything - create fields, rows and tables, delete them or modify their content, export or import an entire database or just a specific part of it, and execute MySQL commands. The tool is essential if you would like to switch hosting companies, as you could very easily generate a full backup of a database in several formats (SQL, CSV, XML). You'll end up with a single file that contains the whole content of the database, so you can 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 internet site will look exactly the same, because all script applications store their data in a database. With phpMyAdmin you may also effortlessly search and replace information of your choice across the entire website - a word, an expression or a link, for example.
phpMyAdmin in Shared Hosting
phpMyAdmin is part of every Linux shared package
we offer and it's accessible from our in-house made Hepsia Control Panel. A tiny phpMyAdmin icon shall be displayed on the right side of every database which you create inside 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 application automatically in a new tab of your Internet browser. Then you can do everything you'd like - export the whole or part of the data, import a database, run SQL queries, search and replace terms. If you do not want to go through the CP, you shall also be able to log in through a direct phpMyAdmin login page, but you need to know the database account information. The last feature is beneficial if you have to grant access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
phpMyAdmin is among the software instruments that come with our Linux semi-dedicated hosting packages
. You can easily log into it and handle your MySQL databases if you click on the phpMyAdmin icon situated on the right side of each and every database that you have created using your Hepsia web hosting CP. You will not need to do anything else, as our system shall log you in automatically and you may proceed with the tasks you should do - import a database file from another website hosting company, modify some content, and so on. You may access a database by using our direct phpMyAdmin login page too, but in cases like this you'll need to input the correct details. You may use this option if you hire a web designer, as they can work on your Internet site without accessing your website hosting CP. This way, all files and e-mails you have inside the account will be secure.