phpMyAdmin Database Manage And Export mysqldump

phpMyAdmin Databases is a complex and confusing process for non-technical users who are looking first time in the Bluehost control panel. Fortunately, the phpMyAdmin offers to do any changes, which not affect your site can be done an easy way, and easy to understand how to use interface to administer your database(s). It is available through Bluehost login cPanel and to access you need to go into your account under the manage databases section.

Now here you will get a direct MyAdmin table access link or need to go on respective site database to access their tables. phpMyAdmin is a tool that is written in core PHP and worked via a web browser to handle the administration of MySQL. It supports a wide range of SQL queries and operations to work directly through the SQL run panel in the MySQL database. The most commonly used supported SQL operations are managing databases, tables, fields, relations, indexes, users, permissions, etc. These operations have the ability to directly run SQL statements and make changes in your database tables.

PHPMyAdmin - database - relational database

Basic Functions of phpMyAdmin

Here we will be going to tell you about some basic function which is used by experts on a daily basis and complete their work without going into backend of the site. These functions will help them to do their work fast and on time. the list of functions are:

Creating a database & their user

Before you move on phpMyAdmin, you have to have one database where you want to run all SQL run. For Database creating & assign users, we have already shared a tutorial in our previous guide, you can follow that guide to make your site database within the Bluehost cPanel.

bluehost database phpMyAdmin

Accessing phpMyAdmin

Once you have a database you can log in to your Bluehost phpMyAdmin via control panel under the Database section. The database section comes through your Bluehost advance menu which is on their left side.

Selecting the Database and View screen

Now you will see options for many functions like collation, language, structure, export, import, SQL, and search. There are also get Documentation for the workflow to make your work easy. To view the structure of each database, you need to click on the database name. The structure will find in the left column or databases tab at the top of the screen. Clicking on the database name, you will get the structure of the database with table names that you will make up manually or by install WordPress on Bluehost.

Browse the Database

Once you have selected the database, click on the import database you don’t have any table inside the DB. Here you will get import database tables with zipping or SQL file. The SQL file, you got from the exported database from your localhost or from another web hosting. Now click on the bottom “Go” button to import table structure with their privilege. After importing or WordPress installation your database is ready to browse.

View MySQL Processes

Once you imported all tables and connected to your website, You may able to view MySQL processes in the “Processes” tab of phpMyAdmin. You can kill the all viewable process by click on the ‘kill’ link.

Export DB by mysqldump for backup

Here is the command which you can use to export your database as a backup if you have made a lot of change and want to see also on your local. The command “mysql” use to import database and “mysqldump” used for exporting large database(s).

The Export command syntax and example is:

C:/> mysqldump -u [user name] –p[password] [database_name]> [dumpfilename.sql]

C:/> mysqldump -u root –pNZSW#456erQ dbnameroot > dbnameroot.sql

The Import command syntax and example is:

C:/> mysql -u [user name] –p[password] [database_name] < [dumpfilename.sql]

C:/> mysql -u root –pNZSW#456erQ dbnameroot < dbnameroot.sql

Conclusion

The database and user creation is a simple process but to run with SQL commands you have to get knowledge of SQL. Without any knowledge, if you will try to work with phpMyAdmin than you may lose your database. Hope this article will help you to get more knowledge on today’s topic & now you are able to do those operations.

If you have any questions you can contact us or comment in the comments section for getting an answer or solution.

Stay in touch. Ask Questions.
Lean on us for help, strategies and expertise.

Leave a Reply

Your email address will not be published. Required fields are marked *