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

Learn More

Trim Your SQL DBs Log Remotely

Last Updated on Saturday, 16 February 2013 11:36 Written by Naveed Ashraf Saturday, 16 February 2013 12:00

The SQL Log records transaction made into database. These log-entries can be used later to check the actions with database. It also used to ensure database integrity in the event of a system restore, includes but not limited to database queries, updating/insertion/deletion of the records. They are just like a temporary location where SQL Server engine temporary store transactions and at final commits the transaction to the database. To clear the disk space and clean the database log, we need to truncate/trim the database log frequently specially for a very active database. Many times the SQL log file grow very large and consume too much space over server. This might also cause to slow performance of a busy database. Here are steps to trim the SQL log remotely.
Learn More

How to Use HeidiSQL to Remotely Connect to Your MySQL Database

Last Updated on Friday, 11 March 2011 05:06 Written by Arian Jahansouz Friday, 11 March 2011 04:47

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Allow Remote Access to a MySQL Database in cPanel

This article will give you a step by step guide on how to use HeidiSQL to remotely connect to your MySQL database. HeidiSQL is a free MySQL client that you can use to remotely connect to your database. To do so, simply follow these steps:

1) Click HERE to go to the HeidiSQL website

Learn More

Search

Authors

Web Hosting

Linux Hosting
ASP .NET Hosting
Business Hosting
Reseller Hosting
E-Commerce Hosting
Dedicated Servers

Acceptable Use Policy
Terms of Service
Privacy Policy

Affiliate Program
Site Map

Blog Hosting

PostNuke Hosting
WordPress Hosting
b2evolution Hosting
Textpattern Hosting
Habari Hosting


CMS Hosting

CMS Made Simple Hosting
phpNuke Hosting
Geeklog Hosting
phpWCMS Hosting
phpWebSite Hosting
Shopping Cart Hosting

OpenCart Hosting
osCommerce Hosting
CubeCart Hosting
Buy Safe Hosting
Zen Cart Hosting


Video Sharing Software Hosting

iVidPlay Hosting
ClipBucket Hosting
ClipShare Hosting
osTube Hosting
vShare Hosting
Forum Hosting

XMB eXtreme Hosting
phpBB Hosting
Simple Machines Hosting
Vanilla Forum Hosting
AEF Hosting


Social Network and Community Website Hosting

SocialEngine Hosting
Jcow Hosting
Skadate Hosting
Dolphin Hosting
Elgg Hosting
Copyright © 2003-2013 Arvixe, LLC. All trademarks are property of their legal owner.