• Connecting your local disk drives to your VPS

      • Scraping
    • admin

    In order to gain access to your local files through your VPS, follow these simple steps:On your local machine, open your "Start Menu", point to All Programs (or Programs), point to Accessories, point to Communications, and then click on "Remote Desktop Connection". Click the "Options" button, and then click the "Local Resources" tab. Click on […]

  • How to Repair a Corrupted MySQL table

      • Scraping
    • admin

    Open a command prompt on your Windows server and enter the following: (replace the values with your MySQL username, password, and database name)   mysqlcheck -u<USERNAME> -p<PASSWORD> –databases <DB-NAME> (Note there are no spaces before the username and password)   This will then check your database and if you do have a corrupt table you […]

  • How to Import and Export a MySQL database using HeidiSQL

      • Scraping
    • admin

    HeidiSQL is a free tool that can be downloaded from: http://www.heidisql.com/download.php       How to Export a MySQL database using HeidiSQL First, connect to your database in HeidiSQL.   Replace the Hostname, User, and Password fields with your database server and login details:             Once connected, RIGHT-CLICK on your […]

  • How to connect, administer, and migrate MySQL databases

      • Scraping
    • admin

    This article is to demonstrate how to use MySQL Front software to connect to a MySQL database and also to export and import a database from one MySQL database host to another.   MySQL Front is a freeware GUI client for interfacing with MySQL databases that you download on your computer. Download it directly from their […]

  • How to backup mysql databases from the command line on windows

      • Scraping
    • admin

    MySQL is an extremely popular database engine on windows today and a common question our team fields is "How do you backup mysql databases on windows?"    The easiest way to backup a database on windows is using the mysqldump command. you’ll execute the command as follows:   mysqldump database-name > database-script.sql -u USERNAME -p […]

  • Where do I download Microsoft SQL Server Management Studio or SQL Server 2005 Express?

      • Scraping
    • admin

    To download Microsoft SQL Server Management Studio (SMS) please visit: http://www.microsoft.com/express/sql/download/default.aspx and click the download link that says SQL Server Management Studio Express. If you run a VPS or a dedicated server and would like to run SQL Server 2005 Express edition, it can be downloaded for free from the same location. <!– –>

  • SQL Server 2005 is not installed on a Windows Web Server 2008-based system

      • Scraping
    • admin

     MS SQL 2005 Will not install on Windows 2008 server and as a result you will get the following warning message. SQL Server Edition Operating System Compatibility (Warning) Messages:SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see ‘Hardware and Software […]

  • MS SQL – Full Text Search / Full Text Indexing

      • Scraping
    • admin

      On MS SQL 2008 databases, Full-Text indexing is already enabled on the database.  For MS SQL 2005 please contact us with the request and your database name and database server name so we can enable it if needed on your specific database. You would then create your full text catalog either through SQL Management […]

Prev Next