Showing posts with label phpMyAdmin. Show all posts
Showing posts with label phpMyAdmin. Show all posts

Friday, August 28, 2015

How to Restore SQL Backup (5 Steps)


Log in to your web hosting CPanel or equivalent. This will vary depending on your host. A common example is http://www.yoursite.com/cpanel. If you do not have these details, you will need to contact your web hosting provider.
On your hosting CPanel, find the section labeled 'Databases.' Click the icon marked 'phpMyAdmin.'
Select the name of the database you wish to restore from the list of databases on the left side of the phpMyAdmin screen. In this example, the database is named '_test.'
Select the option marked 'Import' that is above the details of your database.
On the import page, press the 'Browse' button, and locate the SQL backup file from which you will be restoring. Compression will be automatically detected. Once the backup file is selected, press 'Go.' The backup may take some time to import successfully.
VPS Hosting

Monday, August 24, 2015

How to Create a MySQL Database


Log into the phpMyAdmin interface on your Web space. You will need the username and password assigned by your Web-hosting provider.
Find the text 'Create New Database' on the main frame of the page.
Enter a name for your new database into the blank text field provided.
Click 'Create.' You will get a confirmation page telling you that your database has been created.
VPS Hosting