Category Archives:
MySQL Archives - Page 2 of 4 - OWS KB

This article will help you in understanding of how to restore a MYSQL database. Follow the below steps to restore a MySQL database: Step 1: Login to your control panel www.yourdomain.com/cpanel Step 2: Click on ‘Backups’ in ‘Site Management’ Step 3: Click on ‘Browse’ to locate the Database you want to restore then click ‘Upload’ […]

This tutorial contain the process of changing MySQL database user password from cPanel. Following are steps to change the MySQL database user password from cPanel : 1. Enter in your cPanel account. 2. You will enter into the cPanel homepage. You have to Select the “Database” section and click on the “MySQL Databases” icon from it. 3. Find the […]

In this tutorial, we will see how you can export the database from SSH. In situations like moving your site this can be useful, as it can help you to export the entire database, or need to upgrade a website. Generate a Database Backup: Step 1: Connect to your server via SSH. Step 2: In the command […]

In this article you will learn how to install PHP5, Apache and the database manager in MySQL PHPMyAdmin, just in simple 5 steps: 1 – The first command to execute is: sudo apt-get install apache2 apache2-utils libapache2-mod-php5 php5 php5-mysql php5-cli php5-gd 2 – Proceed with the installation and wait for it to end, remembering that […]

In this tutorial you will learn how to creating MySQL tables for a database in phpMyAdmin. Follow the steps for the same as mention below Login to the ‘Manage MySQL Tool’. In the section – ‘Current MySQL Databases’, click on a login name for the database in order to log into phpMyAdmin. Click on the […]

You might have to be needed to copy or duplicate an existing database for testing the changes made on your web site or for the other similar reason. In this tutorial you will understand the steps for copying or duplicating an existing database through phpMyAdmin without breaking your website: Login to your cPanel control panel. […]

In this article you will learn to copy MySQL database using phpMyAdmin. Steps to Copy MySQL Database In order to copy a MySQL database using phpMyAdmin, follow these steps: 1. Log in to cPanel account. 2. Under the Databases section of the cPanel home screen, click on phpMyAdmin. The phpMyAdmin administration page will get displayed in a new […]

This tutorial helps you to understand the steps for resetting your WordPress password through phpMyAdmin. Requirements: You will need the name of your WordPress database. You will need your cPanel login credentials (username and password). To Identify the Database for your WordPress Website: Login to your cPanel account. Click File Manager on the cPanel dashboard. Browse to the location of your […]

Uploading browser-based file will fail just in case the file size that you simply try to upload is larger as compared to the HTTP post size configuration on the web server. In case this happens, your MySQL database can be restored just by logging onto your account via SSH client (or if you would like […]

Many times, the root cause of crashes, slowdowns, or other unexpected behavior in MySQL can be checked by analyzing its error logs. The default location for the MySQL on Ubuntu systems is /var/log/mysql/error.log. In several cases, the error logs are most easily read with the lessprogram, which is a command line utility that enables you […]