Articles - Frequently Asked Questions, Information, How-To's and Articles
'80004005' Could not use ''; file already in useThis usually means the .ldb file cannot be created - the main cause of this happens when you have...
DSNless connection to MS AccessHere are some examples of DSNless connections to MS Access - this is highly recommended over...
DSNLess connection to MS SQLBelow is an example connection string for access your MSSQL database via a DSNLess...
error '80004005' Could not find installable ISAMThis error can occur if there is a typo in your connection string or path to your database, for...
How can I BACKUP a MySQL database from the command line?
Performing a MySQL Database Dump From your SSH command prompt type ... mysqldump -u {username}...
How can I RESTORE a MySQL database from the command line?Importing a MySQLDUMP From your SSH command prompt type ... mysqladmin -u {username} -p...
How do I backup and restore my Website and Databases.
Backup your site Login to your old cpanel and click "backup" Once in backup...
How do I create a MySQL database in Cpanel ?MySQL databases can be created through the cpanel control panel: Login to your control panel...
How do I create a MySQL database in DNP ?MySQL databases can be created through DotNetPanel: Login to your control panel Hover the mouse...
How do I create a MySQL database in Plesk ?MySQL databases can be created through the plesk control panel: Login to your control panel...
How do I create a MySQL Database in the Ensim control panel ?To add a database (subject to hosting plan resources available) through your Ensim control panel:...
How do I move a MySQL Database from one host to another using phpMyAdmin ? Backup and Restore using phpMyAdmin.How to Backup and Restore your MySQL Database using phpMyAdmin The following are the steps to...
How do I repair a damaged MySQL table, rebuild index or prepare for backup ?It is always worth trying a repair of MySQL tables before backing them up to shrink the...
How do I REPAIR all MySQL databases on my virtual / dedicated server?Repairing All Databases You can repair your databases using mysql as the root user with the...
How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk.Microsoft Access Database Permissions Login to the Plesk control panel and open the File...
How do I use a Microsoft Access database on Windows Plesk Hosting.Uploading your database Login to your the Plesk Control Panel and open the File Manager....
How to Backup your MySQL DB databasesBackup command for mysql databases For those looking to get a regular backup of your MySQL...
I cannot login / access phpMyAdminIf you are using IE you need delete the cookies for this site... 1. On...
Microsoft JET Database Engine error '80040e14', Syntax error in...If you get an error like this is it possible you are using a reserved word in your SQL - please...
MySQL Alter Table - How to rename table names and column names in mysql ?
If you have access to a web administration tool like phpAdmin then you can use that to rename...
What is MySQL?Included on Personal-2 plans and above. The natural database of choice when working with PHP,...
What is PHP?One of the world's most popular programming languages, included with every hosting account. PHP...
What is phpMyAdmin?A must-have tool for anyone who uses MySQL databases. This excellent web application...
Why does my PHP/MySQL based website / blob / forum / wiki show MySQL errors ?There are some circumstances in which your MYSQL databases may become corrupt or tables not...
