Archive | Databases RSS feed for this category

Run a Backup Before Upgrading WordPress

4 February 2011

Comments Off

When you run WordPress, cPanel backup utilities are useful and easy to use.  Back up your site and your database From the WordPress readme: Before you upgrade anything, make sure you have backup copies … This quote is from the WordPress readme.html file in the section “Upgrading Manually.”  Even if you use the automatic upgrader, [...]

Continue reading...

Work With Your Databases Through phpMyAdmin

10 July 2006

Comments Off

phpMyAdmin is a great browser-based application for working with MySQL databases. It simplifies working with databases and I highly recommend it.  Access phpMyAdmin from a link in cPanel. It lets you create and drop databases, work with tables (create, drop, alter), work with fields (delete,  edit, add), execute any SQL statement, manage keys on fields, [...]

Continue reading...

How To Create a Database and Add a User to a MySQL Database

26 June 2006

Comments Off

When you install an app for your site such as WordPress blog, one of the first steps is often create a database, create a user and add the user to the database. cPanel makes this fast and painless. Follow the link to the MySQL Databases section and you get to the MySQL Account Maintenance page. [...]

Continue reading...

Finding the Almost Hidden phpMyAdmin Link

21 June 2006

Comments Off

Work with your MySQL databases through phpMyAdmin, a great browser-based application you access through cPanel. I use it often and still have a hard time finding the link. When you are logged into cPanel: Click the link for MySQL Databases Scroll toward the bottom of the page (below the MySQL Account Maintenance section) Click the [...]

Continue reading...