Search Results for: phpmyadmin

For hosting PHP on your website, PHPMyAdmin might be the most important tool in your arsenal. It lets you effortlessly manage all of your databases on your server. Whether you use MySQL, MariaDB, PostgreSQL, or some other database storage mechanism, PHPMyAdmin lets you easily search, organize, import, export, and much more. PHPMyAdmin is also a great place to test out SQL queries. A built-in SQL editor lets you easily run advanced queries without having to log in to a command line session.

Getting Started With PHPMyAdmin

Here in the support center, we have everything you need to get started using PHPMyAdmin. It comes pre-installed in most accounts, but if you have a self-managed server, we’ve got you covered.

More Advanced PHPMyAdmin Tutorials

Moving on with your mastery of PHPMyAdmin, we have more tutorials that will help support you as you accomplish more demanding database tasks.

How to Kill MySQL Processes in phpMyAdmin

by InMotion Hosting Contributor

There are many ways to monitor MySQL performance. Your hosting plan and access levels are the main determining factors in how you’re able to view MySQL processes. If you’re using a content management system (CMS) (e.g. WordPress or Drupal), you may be able to monitor MySQL processes within its dashboard and 3rd party add-ons. Regardless Read More >

Create a Database Diagram in phpMyAdmin

by InMotion Hosting Contributor

phpMyAdmin is primarily used as a server database management application. But the MySQL/MariaDB software also has a basic entity relationship diagram tool for development and planning purposes. For many this can prevent the need to download desktop software for visualizing relationships between database tables (one-to-one, one-to-many, many-to-many). That is, unless you need highly customized entity Read More >

Managing a MySQL Database in cPanel with PHPMyAdmin

by John-Paul Briones

In this guide, we will introduce you to phpMyAdmin, a web based mySQL client you can use to manage your databases. There are many tools and features that phpMyAdmin includes, but in this article we’re only going to cover a few basics as it relates to php hosting. How to log into phpMyAdmin Log into Read More >

How to Import a Table using phpMyAdmin

by Arnel Custodio

phpMyAdmin is a useful database tool that can be used for a variety of MySQL database operations. The following tutorial covers the import feature. Before you make any changes, be sure that you make a current backup of your database before making any changes. Importing a table means that you will be bringing data and/or Read More >

How to Export a Table in phpMyAdmin

by Arnel Custodio

phpMyAdmin is a powerful MySQL database client that has many capabilities. We will be showing one of its features – the export table option. Exporting a table means that you will make a copy of the table structures and its data. Caution should be taken whenever working with your database. Make sure that you make Read More >

Resetting a Database in phpMyAdmin

by Scott Mitchell

Resetting a database the hard way When working with programs such as WordPress, PrestaShop or even custom coded ones you sometimes need to do manual work within the databases. This may mean having to perform testing with existing data and altering the content or even clearing the database altogether. One of the more common things Read More >

Running MySQL statements in phpMyAdmin

by Scott Mitchell

When working within your PhpMyAdmin tool, you have the ability to create and run custom MySQL statements. This can be very helpful if you are performing things like a site move or creating a test site and need to change specific site information stored in the database. Follow the instructions below as we demonstrate how Read More >

How to Delete or Drop a Table in phpMyAdmin

by Scott Mitchell

When working with databases, you can use the phpMyAdmin tool to create database, tables, and add content. Along with normal data addition, you may also need to reorganize the way your data is stored. This may involved removing data, or even deleting tables from you databases. This tutorial will guide you on the process of Read More >

Resetting your Zen Cart 1.5 Admin Password in PHPMyAdmin

by Carrie Smaha

If you forget your administrator login credentials for Zen Cart, you will need to reset it. The password reset will be done through PHPMyAdmin in cPanel. We cannot reset your password since Zen Cart is third party software. How to Reset your Zen Cart Admin Password Log into cPanel and go to phpMyAdmin Click on Read More >

How to Import a MySQL Database using phpMyAdmin

by Brad Markle

Are you planning to share a locally-developed database from your web server? Maybe you’re migrating a database for WordPress or another content management system (CMS) for development purposes. Whatever the case, phpMyAdmin has a simple process for importing a database file after creating the database in cPanel. In this tutorial, we will show you how Read More >

How to Export a Database using phpMyAdmin

by Brad Markle

When you export a database, you are creating a backup file of the database. This backup file is usually a .sql file (a text file), and can be used to copy and import the database onto another server. In this article we’ll show you how to export your database. Log into phpMyAdmin If you are Read More >

Installing phpMyAdmin on your Account

by Carrie Smaha

If you have a web designer and they are designing your website with a content management system (CMS), the designer may need access to the databases. Until now, the easiest solution was to provide them with the cPanel username and password to access phpMyAdmin. For security purposes, this may not be the best solution since this Read More >

How to Check and Repair a Database in phpMyAdmin

by John-Paul Briones

There may be times when troubleshooting your website that you need to check and repair a database in cPanel using phpMyAdmin. This can help you identify and fix corrupted database errors on your website.. Before continuing, be sure that you make a backup of the database you are working with in the event this does Read More >

How to Use phpMyAdmin To Optimize a Database

by Carrie Smaha

Optimizing databases can be important for many reasons, most importantly to speed up the rate in which your database displays results. By optimizing the databases, you can dramatically affect how fast your website loads. Typically, optimization will only produce noticeable results if you have a large database. If your database has tables with over 10,000 Read More >

Migrating WordPress Manually to Platform InMotion

by Jesse Owens

When you’re getting started with your new UltraStack WordPress VPS on Platform InMotion, you have two options to begin with: Migrating Manually is the most reliable way to get your website transferred to Platform InMotion. Use this option, and Platform InMotion will install a fresh copy of WordPress on your VPS, and you’ll be able Read More >

The Ultimate Guide for Migrating WordPress Websites

by Harry Jackson

If you own a WordPress website, chances are that you will have to move it from one host to another at some time during its lifetime. You could be moving to a new host for a variety of reasons. Better performance is usually a driver for this type of change. Moving a website from a Read More >

Need More Help?

Current Customers

Chat: Chat with Sales
Call: 757-416-6575 x2
Ticket: Submit a Support Ticket

Get Reliable Web Hosting

Chat: Chat with Sales
Email: [email protected]
Call: 757-416-6575 x1

Get web hosting that grows with your business. Our all-in-one hosting platform gives you everything your website needs to scale - so you can focus on the next big thing for you and your business.