How to Find Out Where Your SQL is Hosted

Last Updated on Saturday, 11 May 2013 06:14 Written by Andrew Cross Monday, 13 May 2013 12:00

Do you require a script to install a database for you?

Are you faced with a problem of knowing it location?

Here is a quick guide on how to find the location of your SQL Database.

This Guide is based around CPanel but the instruction are very much the same for other Control Panels.

How to Manage MySQL Databases Remotely

Last Updated on Thursday, 18 April 2013 02:34 Written by Anand Narayanaswamy Wednesday, 24 April 2013 12:00

It is possible to manage MySQL databases using PHPMyAdmin but it has limitations. You will not be able to execute huge databases since it will cause timeouts. Hence, it is advisable to make use of remote MySQL client software such as SQLyog.

With the help of SQLyog, you will be able to execute and manage MySQL databases from within your computer.

For Linux hosting, you should first add your IP address by following the steps below

How to Backup a Database with Microsoft SQL Server 2012

Last Updated on Monday, 4 February 2013 03:11 Written by Rodolfo Hernandez Tuesday, 5 February 2013 12:00

In this new video, brought to you by Arvixe, I will show you how to backup your MSSQL or MySQL database with Microsoft SQL Server 2012

How to Manually Reset an Admin Password in SocialEngine 4

Last Updated on Sunday, 16 December 2012 12:00 Written by Andrew Cross Sunday, 16 December 2012 12:00

If the administrator password is forgotten and the associated email account is inaccessible, the password can be manually reset through the MySQL database.

Solution
To reset an administrator password:

How to See MySQL Query Errors in PHP

Last Updated on Tuesday, 20 November 2012 12:45 Written by Richi González Thursday, 22 November 2012 12:00

Hello,

Some people create queries that do not work and don’t have a clue why they don’t, as no error is displayed. I’ll show you how to display the MySQL error, if any, when the query is run. A must know for programmers. Great tool for debugging queries.

1. Open the file where you have your query. For this article, I will be using the following code: