Showing posts with label Selection. Show all posts
Showing posts with label Selection. Show all posts

Monday, 29 February 2016

How to Import a MySQL DatabaseIn Feburary 2016 29,

In Feburary 2016 29,
Install phpMyAdmin software on your computer if it is not already installed. You can find phpMyAdmin software online at the phpMyAdmin homepage (see Resources below).
Log onto the phpMyAdmin page from your Web space. You will need the username and password assigned to you by your Web-hosting provider.
Select the database you wish to import the old data into from the drop-down Database Selection box on the left of the page.
Click the SQL tab toward the top of the interface.
Click the Browse button located toward the bottom of the page.
Find the .SQL file where it is saved on your hard drive, select it and click 'Open.'
Click the Go button. The data in your SQL file has now been imported into your database.
Using the SSH Command Line
Contact your hosting provider to gain SSH access.
Log into your Web space using an FTP client. You will need to know your username and password.
Find your existing .SQL database and upload it to your Web space using your FTP client. It doesn't matter where in your Web space you upload it to, as long as you execute the SSH command when you're in this folder.
Close your FTP program.
Log into your Web space using the appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own database name, file name, username and password instead of the words in capitals.mysql -uUSERNAME -pPASSWORD DATABASENAME
In Feburary 2016 29,

Thursday, 11 February 2016

How to Unzip a File in cPanelIn Feburary 2016 11,

In Feburary 2016 11,
Log in to your cPanel account and click 'File Manager' under the 'Files' section. Click the 'Go' button in the 'File Manager Directory Selection' window that pops up. The 'File Manager' window displays.
Click the 'Upload' link along the menu bar at the top and click the 'Choose File' button in the 'Upload Files' window that appears. Find the compressed folder on your computer's hard drive, select it and click the 'Open' button. The folder uploads to your hosting server.
Go back to the 'File Manager' window and click the 'Refresh' or 'Reload' button in your browser. The 'File Manager' window reloads and the compressed folder now appears among your other files in the main window to the right.
Highlight the compressed folder by clicking on it and then click the 'Extract' link located at the top right of the menu bar. The 'Extract' window pops up. Click the 'Extract File(s)' button and the compressed folder unzips the files to the same location as the compressed folder.
In Feburary 2016 11,