Showing posts with label import. Show all posts
Showing posts with label import. 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,

Wednesday, 10 February 2016

How to Check if a Folder Exists in Vb.NetIn Feburary 2016 10,

In Feburary 2016 10,
Type 'Dim pathName As String' in your VB.NET code to define a string variable to hold the path to the folder that you want to look for. This string variable is called 'pathName.' As an example, set the value of the string variable 'pathName' to 'C:\TestFolder.' This can be implemented using the following code; 'pathName = 'C:\TestFolder'.'
Type 'Imports System.IO' in the first line of your code page to import the 'System.IO' library into your VB.net code. The 'System.IO' is a .NET framework class library that is available to all .NET based code. As the code is being developed in VB.NET, this library is also automatically available for use to the developer. A class library is a collection of classes with various functions that programmers can use in their software applications.The 'DirectoryInfo' class is a part of the 'System.IO' class library that exposes functions for creating and moving through directories and sub-directories.
Type the line 'Directory.Exists(pathName)' to use the 'Exists' function of the 'DirectoryInfo class' to check if the 'C:\TestFolder' folder exists on your computer. The 'Exists' function will return a true boolean value if the folder exists, and it will return a false boolean value if the folder does not exist. To catch this boolean value, define a boolean variable by using the following code line: 'Dim answer As Boolean.' Use this 'answer' variable to accept the return value of the 'Exists' function by using the following code line: ' answer = Directory.Exists(pathName).'
Build and compile your code by clicking on the 'Project' option on the top tool bar and then clicking on 'Build.' Execute the code by clicking on the 'Debug' option on the top tool bar and then clicking 'Run.' The VB.net code will execute, check if the 'C:\TestFolder' exists on your computer and return an appropriate true or false value.
In Feburary 2016 10,