Database
MSAcess DB access
I would recommend that you import your MS-Access database into a sole MSSQL database (as MS-Access is now considered obsolete anyway) you can use any of the following ways; ...
How to repair a DB on MySQL
REPAIR TABLE & Database On MySQL ============================== The REPAIR TABLE method is only applicable to MyISAM, ARCHIVE, and CSV tables. You can use REPAIR TABLE if the table checking operation indicates that there is a corruption or that an ...
How to import/export mysql via SSH commandline
Managing Databases via Command Line (SSH) Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import or export a MySQL database into an existing database on your account. Please note ...
Restoring MSSQL Databases Shared/Reseller Hosting
All shared/reseller MSSQL enabled servers come standard with a web based mylittleadmin utility. However, this utility does not allow for importing databases (only working with databases once they have been imported) Since we cannot allow MSSQL ports ...
How to copy an ASP/MS SQL site to a local machine
Customer wants to copy his/her site to a local PC to show off in a "live" demo. You might want to look at http://www.w3schools.com/asp/asp_install.asp. It has a brief tutorial on how to set up Personal Web Server on a PC/Laptop which supports ASP ...
Uploading DB via phpmyadmin fails
Unable to import MySQL DataBase via PhpMyAdmin. Symptoms include a hanging screen or time-out errors The cause of this is the DB file is too large to import via phpmyadmin and can only be imported via the command line by a cartikahosting.com ...
MSSQL Admin Tools
I would like to manage my MSSQL database. How can I do this? On some of our MSSQL servers we have installed a tool called MyLittleAdmin. This web application allows you to edit your database, back it up and restore it from a backup (MSSQL 2005 & 2008 ...
Extract or backup a MSSQL database to a .sql file using EMS Sql Manager Lite
How do I extract or restore an MSSQL database to a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer. Start EMS Sql ...
Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite
How do I restore an MSSQL database from a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer. Start EMS Sql Manager. If ...
How to repair a crashed MySQL table/database
Symptoms: If your site/application is displaying something similar to: Table './user_dbname/dbprefix_table' is marked as crashed and should be repaired Resolution: 1. Access phpMyAdmin (link can be found in your control panel under Database -> MySQL ...
Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only
To restore a MSSQL database to your VPS or dedicated server, you would do the following steps: 1) Login to MS SQL Studio via remote desktop -- you will want to use an admin login and if you do not have this please contact us. 2) Right click the ...
How do I backup a MySQL database?
Backing up your MySQL database can be done couple different ways. Method #1 Using the phpMyAdmin web interface included in the Hsphere CP Method #2 Using command line utility "mysqldump" Using the phpMyAdmin Method: To access phpMyAdmin, you will ...
Shrink mssql db with mylittleadmin
How to truncate mssql logfiles using mylittleadmin: 1) login into mylittleadmin 2) Select the Tools option 3) Under Tools click on : Shrink Database 4) Select your database 5) Under the option “Currently allocated space”, change the value with a ...