TAG: databases

Backup and Restore MySQL Databases Using mysqldump

mysqldump lets you quickly and efficiently take a backup of a single database, multiple databases or even all of the databases on your server. This requires shell access to the server you wish to perform the commands on and the mysql login credentials for your user(s).   Backing up a Single Database Usage: mysqldump -u user…

Definition of Databases Icons

The Database section in cPanel allows you to administer every aspect of your MySQL database. Using this interface you can do things such as create new databases, add users to existing databases, and manage database tables to name a few. It is suggested to create all new databases through cPanel before working with them directly.…

How to Create a Database/User in zPanel

How to Create a Database Follow these instructions to create a database in zPanel.   Click the MySQL Database icon in the Database Management section on the ZPanel home page as shown below     You’ll now see Create a new MySQL® database – Put in the name you’d like for this database Click Create  …

Adding a MySQL user to a database

How do I Add a User to a MySQL Database? You can easily add a user to specific MySQL databases in cPanel by doing the following instructions below.    Go to Home > Databases > MySQL Databases     Scroll to the Add User To Database section Pick the desired user and database from the…

Creating a MySQL User

How do I Create a MySQL User? To create a MySQL user follow the guide below.  This guide assumes you have created a MySQL database already.  If you haven’t created a database and are unsure how to do it, please see our doc on creating a MySQL database. Go to: Home > Databases > MySQL…

MySQL Databases and Users Overview

Around the world wide web properties such as Facebook, Twitter, YouTube and more use the world’s most popular open source database MySQL to help them run.  MySQL is a database management system that allows a database filled with all kinds of data to add, access and process that data. Databases make it easy to store…