Exporting Databases and Tables with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 12, 2018
Category: Tutorials | Tags: data management, database, mariadb, mysql, phpmyadmin

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Let’s learn how to export a database.

Click the database you wish to export here.
Then click the Export button.
In this case, we want to export the entire database in SQL format, so we can easily import it later. This is a good way to backup your database.
Be sure to check any options you want before proceeding.
Check the Save as File check box, then click Go.
That’s it! The demo1234_members database has been exported to our local computer.
If you only wanted to export a table, and not the entire database select the table you want to export and export just as you would a database.
Remember that exporting tables only exports the selected tables within a database, whereas exporting a database will export all tables as well the data schema(provided they’re all selected).
That’s it! The details table has been exported to its own file.

Importing Databases and Tables with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 14, 2018
Category: Tutorials | Tags: data management, database, import, mariadb, mysql, phpmyadmin, table

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin.
Now let’s learn how to import a database.
Click the database you wish to import here.
Let’s assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data.
Therefore, let’s first delete the existing details table from our database.
Now let’s import the saved copy of our database, which includes the details table.
That’s it! The demo1234_members database has been successfully imported, as indicated here.

Creating Tables in a Database with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 12, 2018
Category: Tutorials | Tags: mariadb, mysql, phpmyadmin

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Let’s learn how to create a table within a database.

Select the database here.
Enter a Name for your new table.
Then enter the number of fields this new table is to have. Click Go.
Now enter the details of each field within the new table.
The first field will be called id, and it will be an integer that’s 4 characters in length.
We also want this first field to be the Primary key that will be automatically filled in (auto_increment) when new entries are added to the table. Selecting this option makes the id field the Primary key in the table.
The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accomodate the fields.
When finished, click Save.
That’s it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here.

Searching Through a Database with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 14, 2018
Category: Tutorials | Tags: data, data management, database, find, mariadb, mysql, phpmyadmin, search

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to use the Search feature.

Click the database you wish to search here.
Then click the Search tab and enter words or values to search for in the database.
There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here.
When ready, click Go to perform the search. This search found one match. Click Browse.
We can now make changes to the record that was found.
Click Go when finished.

Running SQL Queries on a Database with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 14, 2018
Category: Tutorials | Tags: data, data management, database, mariadb, mysql, phpmyadmin, query

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to run SQL queries on a database.
Click the database table you wish to run a SQL query on.
Click the SQL button here.
Then type your SQL command. Click Go when finished.
In this case, we’re going to delete the address field from the details table using the command:ALTER TABLE details DROP COLUMN address;
That’s it! The SQL command is executed when you click Go. Let’s go take a look.
The address field is no longer in our details table.
You can also click the SQL button directly from the table view. Doing so presents a SQL query window that is partially filled in.

Deleting Tables from a Database with phpMyAdmin

Posted on May 16, 2016 by dpepper | Updated: September 12, 2018
Category: Tutorials | Tags: data management, database, mariadb, mysql, phpmyadmin, tab

Tutorial: phpMyAdmin

I. Becoming Familiar with Databases in phpMyAdmin
II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to delete a table from a database.

Select the table you wish to delete here.
You can delete individual fields from this table by selecting them here then clicking the delete icon here.
However, in this tutorial, we’re going to demonstrate how to delete the entire table and everything in it.
Click the Drop button here. Then click OK to confirm.
The addresses table has been deleted (or dropped) from the database.
The addresses table is no longer listed in our database’s list of tables.

How To Delete a MySQL Database User in cPanel

Posted on May 8, 2016 by dpepper | Updated: September 12, 2018
Category: Tutorials | Tags: cpanel, data management, database, mariadb, mysql

cPanel Tutorial: MySQL

I. How To Set up a Database using the MySQL Database Wizard in cPanel
II. How To Create a MySQL Database in cPanel
III. How To Delete a MySQL Database in cPanel
IV. How To Create a MySQL Database User in cPanel
V. How To Assign a User to a MySQL Database in cPanel
VI. How To Change a MySQL Database User’s Password in cPanel
VII. How To Remove a User from a MySQL Database in cPanel
VIII. How To Delete a MySQL Database User in cPanel
IX. How To Check a MySQL Database for Errors in cPanel
X. How To Repair a MySQL Database in cPanel
XI. How To Manage a MySQL Database with phpMyAdmin in cPanel

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to delete a database user.

Click the “MySQL Databases” icon.
Locate the “Current Users” section at the bottom of the page, and click the “Delete” icon next to the user you want to delete.
Then click “Delete User” to confirm.
That’s it! The database user has been deleted.

How To Check a MySQL Database for Errors in cPanel

Posted on May 8, 2016 by dpepper | Updated: September 12, 2018
Category: Tutorials | Tags: cpanel, data management, database, errors, mariadb, mysql, mysqlcheck

cPanel Tutorial: MySQL

I. How To Set up a Database using the MySQL Database Wizard in cPanel
II. How To Create a MySQL Database in cPanel
III. How To Delete a MySQL Database in cPanel
IV. How To Create a MySQL Database User in cPanel
V. How To Assign a User to a MySQL Database in cPanel
VI. How To Change a MySQL Database User’s Password in cPanel
VII. How To Remove a User from a MySQL Database in cPanel
VIII. How To Delete a MySQL Database User in cPanel
IX. How to Check a MySQL Database for Errors in cPanel
X. How To Repair a MySQL Database in cPanel
XI. How To Manage a MySQL Database with phpMyAdmin in cPanel

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Now let’s learn how to check a database for errors.

Click the “MySQL Databases” icon.
Under “Modify Databases”, and in the “Check Database” drop-down box, select the database you want to check.
Then click “Check Database”.
That’s it! The check has been completed, and no errors were found.

How To Remove a User from a MySQL Database in cPanel

Posted on May 8, 2016 by dpepper | Updated: September 14, 2018
Category: Tutorials | Tags: cpanel, data management, database, delete, mariadb, mysql, remove, user management

cPanel Tutorial: MySQL

I. How To Set up a Database using the MySQL Database Wizard in cPanel
II. How To Create a MySQL Database in cPanel
III. How To Delete a MySQL Database in cPanel
IV. How To Create a MySQL Database User in cPanel
V. How To Assign a User to a MySQL Database in cPanel
VI. How To Change a MySQL Database User’s Password in cPanel
VII. How To Remove a User from a MySQL Database in cPanel
VIII. How To Delete a MySQL Database User in cPanel
IX. How To Check a MySQL Database for Errors in cPanel
X. How To Repair a MySQL Database in cPanel
XI. How To Manage a MySQL Database with phpMyAdmin in cPanel

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to remove a user from a database.

Click the “MySQL Databases” icon.
In the table of databases, locate the database you wish to remove a user from, locate the specific user assigned to that database that you want to remove and click the delete icon.
Click “Revoke User Privileges from Database” to confirm.
That’s it! The user has been removed from the database.
The user hasn’t been deleted … you can see it’s still listed in the list of current users. It has simply been removed from that database.