Search results

You can follow below steps : You can create dump file : #mysqldump db_name table_name > table_name.sql You can create dump file from remote server: #mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql You can create dump file using phpmyadmin: Cpanel >>...

You can follow below steps to resolve this error, this error occur while running query in phpmyadmin. First you need root access to resolve this error. With root access you can make changes in configuration file with below command: vi /etc/my.cnf You have to add below line in this file...

We can change Mysql timezone by using CONVERT_TZ function. You have to use below SQL command to change timezone SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' ); If you want to change your timezone to USA new York, you can run below command. SELECT CONVERT_TZ(...

If you are getting error “YOU SHOULD UPGRADE TO MYSQL 5.5.0 OR LATER” in phpmyadmin then you can follow steps to resolve this issue. First check and go to below path to locate common.inc.php file. Windows server - C:\inetpub\wwwroot\phpMyAdmin\libraries\common.inc.php Linux server -...

You can check below steps to set UT8MB4 with phpMyAdmin . Login to cpanel account. You will get phpMyAdmin option under “Databases”. A new window will appear to manage your database. Here you have to select UT8MB4 Unicode and there is no need to save,it will be auto-saved.

If you want to repair corrupt MDF files then you have to use DBCC (Database console commands) in SQL server management studio. Many DBCC commands are available like DBCC CHECKDB, DBCC DBREPAIR. To resolve this issue you can follow below steps: Open SQL server management studio. Here you will...

You can follow below steps to rename mysql database: Login to cpanel. Search for “Mysql Databases” under Databases. Now select particular database which you want to rename from “Current Databases” list and click on “Rename” option. Enter your desired password and click on “Proceed” button. Now...

Login to SSH via root. Now you have to enter below command: mysql -u username –p You will see password prompt you have to enter password of your database. You have to enter below command to display all the databases and also you can see its size in MB. You can use this command to check single...

Open Outlook. Click the File tab > Account settings. Highlight your current POP3 account and click Change. Note: The window that opens will tell you what type of email account you have. (Look under Type.) Choose More settings and click on Advanced. You should see a check box titled “Leave a copy...

You can change upload path for your FTP through : Login to Plesk. After that click on “FTP Access”. Now you have to select desired FTP account of which you have to change path. You can change path of your directory here.

You can follow below steps to set the concurrent connection limit through: Open WinSCP and go to the Preferences section. Next to "Other general options" click on the "Preferences" button. Go to "Transfer" >> Background. In the right pane, simply edit the value next to "Maximal number of...

You can follow below steps to change Mysql root password: Login to WHM. Click on Mysql root password under “SQL services” tab. Now you have to enter new password of your Mysql database. You have to use STRONG and COMPLEX password for your database as everyone can access database. Do not use...

Mysql workbench is an Mysql client tool which helps to connect Mysql database. You can easily connect with mysql database from your computer with this mysql client. Here are the steps to use mysql client: Install mysql workbench and then open it. Click on “New Connection” and you will find...

Here are the steps to integrate Joomla website with CDN. Login to Joomla panel. Here you will find “Extensions” tab you have to click on Manage >> Install. You have to click on “Upload package file” tab, upload your zip file here and then tab on “Upload and Install”. After that you have to...

Basically set operators are used to join two statements. There are various types of set operators are available. Here are few set operators. UNION operators : You will get single result with combination of two SELECT statements. But this operator removes duplicate values from the result. UNION...

Here are the steps to export SSL certificate windows server: Login to RDP. Open IIS Manager. Here you will find “Server certificate” option, click on it. You will find all the SSL certificate hosted on server. Right click on the particular certificate which you want to export and click on...

You can follow below steps to install memcache in WHM: Login to WHM. Click on “Module installer” under “Software”, here you can see all the installed modules. Here click on “Manage” button in PHP Pecl module. You will find search bar in “Find a PHP Pecl”, you have to search “memcache” and click...

You can follow below steps to create CSR key. You have to login into DirectAdmin and go to domain account. Under Account Manager you have to click on “SSL Certificates”. Now a form will appear you have to fill this form and then click on “Save” button. After generating the CSR key you can see...

Login to DirectAdmin control panel. You can find another option “Create Administrator” link under “Server Management”, click on it. Fill up the following details: Username Email Address Password Re-type New Password Click on “Submit” button and your second administrator account is created.

You can follow below steps to create Mysql database. Login to DirectAdmin. Now click on “Mysql Management” link. Here you will find “Create New Database”, you have to click on it. Enter below details : Database Name Database Username Password of that user Re-type Password At last click on...