HOW TO CONFIQURE WAMP, MAMP OR LAMP TO YOUR LOCALHOST QUICKLY

What is AMPPS ?

AMPPS is an easy to install software stack of Apache, Mysql, PHP, Perl, Python and Softaculous auto-installer that can be used on Desktops and office servers. 

AMPPS Features

A complete package on your desktop, same like the server that provides many open source web applications. 
Application Management,     Domain management, Database management, etc are provided in a secure environment to ease your development.

With Softaculous

Softaculous is ready for your desktops with AMPPS to boost your development. Like servers, now auto-installation is possible on your desktop too. 

 WAMP, MAMP OR LAMP  are wampserver, xamp similar softwares that you can confiqure so as you can edit or develop your site offline.

AMPPS Stack

AMPPS is a stack of the Apache Web Server, MySQL, PHP, Perl, Python and SOFTACULOUS. 

Databases

You can create multiple MySQL databases and manage them easily with phpMyAdmin. SQLite Management tools are also available in AMPPS.

Watch the videos below for detailed information: 

HOW TO RESTORE YOUR DATABASE FROM BACKUP USING MYSQL COMMANDS

What is MySQL

MySQL is the world’s most popular open-source database for the cost effective delivery of reliable, high-performance and scalable e-commerce and database system used with PHP.

The restore process consists of unarchiving your archived database dump, and importing it into your MySQL database.

You May Also Read: HOW TO RESTORE YOUR DATABASE FROM BACKUP USING PHPMYADMIN

Assuming your backup is a .bz2 file, created using instructions similar to those given for Backing up your database using MySQL commands, the following steps will guide you through restoring your database:
1. Unzip your .bz2 file:

user@linux:~/files/blog> bzip2 -d blog.bak.sql.bz2

Note: If your database backup was a .tar.gz file called blog.bak.sql.tar.gz, then

tar -zxvf blog.bak.sql.tar.gz

is the command that should be used instead of the above.
2. Put the backed-up SQL back into MySQL:

user@linux:~/files/blog> mysql -h mysqlhostserver -u mysqlusername
-p databasename < blog.bak.sql

Enter password: (enter your mysql password)

user@linux~/files/blog:>

Thank You.

HOW TO RESTORE YOUR DATABASE FROM BACKUP USING PHPMYADMIN

What is phpMyAdmin?

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL, MariaDB and Drizzle. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

You May Also Read: HOW TO INSTALL AND BUILD YOUR WEBSITE OFFLINE WITH MAMP SOFTWARE
The program manipulates databases remotely through a web interface. A good hosting package will have this included. For information on backing up your Website database.
Information here has been tested using phpmyadmin 4.0.5 running on Unix.
Restore Process
Using phpMyAdmin, follow the steps below to restore a MySQL database.
1. Login to PhpMyAdmin.
2. Click "Databases" and select the database that you will be importing your data into.
3. You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
4. Across the top of the screen will be a row of tabs. Click the Import tab.
5. On the next screen will be a location of text file box, and next to that a button named Browse.
6. Click Browse. Locate the backup file stored on your computer.
7. Make sure SQL is selected in the Format drop-down menu.
8. Click the Go button.
Now grab a coffee. This bit takes a while. Eventually you will see a success screen.
If you get an error message, your best bet is to post to the support forums like Website to get help.
PhpMyAdmin is also very deeply documented in a book written by one of the developers – Mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish.
To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages.
phpMyAdmin has won several awards. Among others, it was chosen as the best PHP application in various awards and has won every year the SourceForge.net Community Choice Awards as "Best Tool or Utility for SysAdmins".
phpMyAdmin is a sixteen-year-old project with a stable and flexible code base; you can find out more about the project and its history. When the project turned 15, we published a celebration page.
Hope to hear from you pals!

HOW TO BACKUP YOUR DATABASE USING CPANEL IN YOUR WEBHOST

What is a Database?

Database management systems (DBMSs) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

You May Also Read: HOW TO INSTALL AND BUILD YOUR WEBSITE OFFLINE WITH MAMP SOFTWARE


Process to Backup using cPanel X
cPanel is a popular control panel used by many web host. The backup feature can be used to backup your MySql database. Do not generate a full backup, as these are strictly for archival purposes and cannot be restored via cPanel. Look for 'Download a MySQL Database Backup' and click the name of the database. A *.gz file will be downloaded to your local drive.
There is no need to unzip this file to restore it. Using the same cPanel program, browse to the gz file and upload it. Once the upload is complete, the bottom of the browser will indicate dump complete. If you are uploading to a new host, you will need to recreate the database user along with the matching password. If you change the password, make the corresponding change in the configuration or settings file.