Web Hosting Technology Blog by JodoHost

Tag overview for: 'database'

Entries on this site with 'database'

• Check space for a particular table in the MSSQL Database
  Use go sp_spaceused Note : It works with MSSQL 2000/2005/2008/2012
• Connecting PHP with the MSSQL database on IIS7
  Sometimes we have to connect PHP with MSSQL - most of the webhosts don't offer this on a shared environment but it is possible to have this facility on a dedicated server
• Steps to install the Gallery application manually with Linux hosting
  Please follow the steps below to install the Gallery application:- 1. Download the package from the official website or through any other means of Internet resources. 2. U
• MySQL Error: Prepared statement needs to be re-prepared
  To fix this error, first try to restart the MySQL services. Otherwise, try modifying any of the following database settings: tmp_table_size 32M=>64M join_buffer_size 256k=
• Steps to install nopCommerce on your domain
  Please follow the steps below to install nopCommerce on your domain. 1- Please upload all the nopCommerce files under the domain root folder. 2- After that, create a subfo
• MySQL Error 1129: Host 'xxx.xx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
  To fix this error, run the command below:- ]# mysqladmin -p flush-hosts � � � where -p = password of the MySQL admin (root) user.
• Taking a backup of a MySQL table and restoring it
  Use the command below to take a backup of only one table: # mysqldump -u db_username -p mydatabase table1 > table1.sql Use the command below to restore the table: #mysql -
• Steps to Reset the Database User Password from the Plesk Control Panel
  Please follow the steps below:- 1. Login to the Plesk control panel. 2. Go to Domains. 3. Select the Domain. 4. Go to Websites and Settings. 5. Find the database there. 6.
• DNS lookup optimization for the MySQL server: skip-name-resolve
  To increase the MySQL server performance if there are many hosts and if DNS is slow, consider disabling DNS lookups with --skip-name-resolve or consider increasing the val
• How to suspend or resume a MySQL abusive user in the H-Sphere cluster?
  1. Run the following command to suspend a user:- ? ? /hsphere/shared/scripts/mysql-suspend-user username 2. Run the following command to unsuspend a user:- /hsphere/shared
• How to restart MySQL from the server if it is taking many connections
  Steps to restart the MySQL service if it is taking many connections :- step1? pgrep mysql (it will show the processes' ids) step2? pgrep mysql > mysql.txt step3? for i in
• Steps to restart the MSSQL server services
  You can re-start the SQL server in 3 ways: 1. Management Studio - Open the Management Studio, connect to the server, right-click on the server name and click restart. 2. S
• Steps to reset/change the password of a MSSQL database user in the H-Sphere control panel
  Please follow the steps below: 1) Login to your H-Sphere control panel. 2) Select Database >>> MSSQL >> MSSQL logins. 3) On the next page that appears, you will be able to
• How to remove a MySQL database without removing its db user which is being used with another database as well?
  In H-Sphere, if we have several databases and have a common db user for all and at some point remove a database then this will remove the database user for all the databas
• Changing the MySQL password
  Please follow the command below to set your password for the first time for MySQL:- # mysqladmin -u root password YOURPASSWORD We can change the root password through the
• Transferring Data from One Table to Another
  This is to transfer data from one table to another within a single database To transfer all data from one table to another within the same database: "INSERT INTO TABLE2 SE
• How to see the records/contents of a MySQL database table?
  If you have your own server and have MySQL installed with some database, and would like to view the contents of a table in that database, then you can follow the steps bel
• How to take a MySQL database schema backup using the command line
  The following command can be used to take a MySQL database schema backup on the command line :- command : mysqldump -u dbusername -p passwd datbase_name --no-data=true >>
• Steps to increase the MySQL / MSSQL / PgSQL database quota in H-Sphere
  Please follow the steps below: 1) Login the H-Sphere control panel. 2) Select Database >> MySQL / MSSQL / PgSQL DBs. 3) On the page that appears, you can see the existing
• Steps for Joomla installation
  Preparations before installing Joomla:- 1- Make sure the Joomla files have been uploaded to the domain directory. 2- Make sure that the database has been created in H-Sphe
• How to change PostgreSQL database encoding
  To accomplish this task, we need to delete the existing database first and then re-create the same with the required encoding. Steps:- ? 1. Login to the respective Postgre
• MySQL DBA permissions
  Issue : While restoring the MySQL database using a third party tool like SQLyog, sometimes we get an error like this : Error occured at:2013-07-01 15:00:44 Line no.:XX Err
• How to move your database onto a new server
  1) First take backups of the databases which are in your account. 2) Remove the databases one by one and then disable the MSSQL resource and then again "enable" it. This w
• Installation Steps for WordPress
  1- Download the WordPress package from their website and put it under your domain root and extract it. 1- Open the index.php in your browser and follow the instructions. E
• Backup or Restore your Mysql Database using phpMyAdmin
  Taking a Backup or Export of your MySQL database using phpMyAdmin :- -------------------------------------------------------------------------------------------------- Ste
• How to restore a PgSQL database using the phpPgAdmin tool
  Below are the steps to restore a PgSQL database :- 1. Login to the H-Sphere control panel. 2. Go to databases --> PGSQL databases. 3. Click the name link of a database and
• How to change database schema to DBO
  SELECT 'EXEC(''sp_changeobjectowner @objname = '''''+ ltrim(u.name) + '.' + ltrim(s.name) + '''''' + ', @newowner = dbo'')' FROM sysobjects s, sysusers u WHERE s.uid = u.u
• How to kill Database Connections
  If you see your database is making too many connections, then use the query below to kill all connections in one go. ============= USE master GO DECLARE @dbname varchar(30
• Block listing of databases for users without access.
  All SQL logins are members of the 'public' server-level role, which by default has the VIEW ANY DATABASE permission. This will revoke that permission : REVOKE VIEW ANY DAT
• Some tips to secure your WordPress site from hacks
  Follow the prevention steps below to secure your WordPress blog or any general CMS site :- 1) Make sure your WordPress site is up to date with the latest version. 2) Keep
• How to create the special SQL view for a MSSQL database
  Steps to create the special SQL view for the MSSQL database: 1)? Login to the SQL Server for the database for which the SQL view is to be created. 2)? Open the SQL Server

Related tags

.htaccess, 1129, 2000, 2005, 2008, 2012, abusive, access, application, asp.net, backup, change, cluster, cms, code:1142, collation, command, commandline, connection, connections, contents, control, controlpanel, conversion, data, databases, dba, dbo, dedicatedserver, dns, domains, encoding, error, export, file, flush_hosts, gallery, hacks, hosting, hostname, hsphere, iis, iis7, iisrestart, import, install, installation, ip, ipaddress, jodohost, joomla, linux, linuxhosting, lookup, manually, many, microsoft, msc, mssql, mysql, mysqladmin, native, nopcommerce, optimization, panel, password, permission, pgsql, php, php.ini, phpmyadmin, phppgadmin, plesk, privilege, remove, reset, restart, restore, resume, schema, server, service, services, settings, site, skip_name_resolve, space, sql, sqlsrv, suspend, table, url, user, vps, windows, windowshosting, with, wordpress, wp

Flickr images for 'database'