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 […]
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 […]
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 […]
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 […]
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 […]
ERROR: Error message 1 Data has changed since the Results pane was last retrieved. Do you want to save your changes now (Optimistic Concurrency Control Error) Click Yes to commit your changes to database anyway. Click No to discard your change and retrieve the current data for this row. Click Cancel to continue editing. Note […]
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. <!– –>
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 […]
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 […]
ABORT — abort the current transaction ALTER DATABASE — change a database ALTER GROUP — add users to a group or remove users from a group ALTER TABLE — change the definition of a table ALTER TRIGGER — change the definition of a trigger ALTER USER — change a database user account ANALYZE — collect […]