Welcome to UltratechHost Forum, Guest. Please take the time to register if you haven't, or click

Tags
Author: UltratechHost - Replies: 0 - Views: 4659
Backup/Restore MySQL Databases via SSH
Backup/Restore MySQL Databases via SSH

Ok , in this pretty morning I will learn you how to backup or restore your mysql databases with ssh commands . It is very useful when you have a big data base because you cannot restore big databases with phpmyadmin . (in usual servers)

Ok lets start ,



Creating a dump of your Database via SSH

Connect to your ssh client with putty or any more ssh client programs . (In linux yomust use terminal)

Code:
# cd public_html

Now you are
Author: UltratechHost - Replies: 0 - Views: 4242
How to change MySQL root password from WHM
To change MySQL root/admin password from WHM one need to perform below mentioned steps:

1) Login into WHM of the server.
2) Click on MySQL Root Password from SQL Services.
3) Provide new password or generate password and set it.
4) Click on Change Password.
Author: UltratechHost - Replies: 0 - Views: 3845
How to restore MySQL backup using phpMyAdmin
1. Login into WHM
2. Click on phpMyAdmin from SQL Services section.
3. Select the database from phpMyAdmin section.
4. Click on Import tab.
5. Click on Browse button from the location of the text field.
6. Select the destination and click on open button.
7. Click on Go button.
Author: UltratechHost - Replies: 0 - Views: 4620
How to download MySQL backup using PhpMyAdmin
1. Login into cPanel
2. Click on phpMyAdmin from SQL Services section.
3. Select the database from phpMyAdmin section.
4. Click on Export tab.
5. Select type SQL from Export section.
6. Click on zipped radio button.
7. Click on Go button.
8. Select the destination and click and save button.
Author: UltratechHost - Replies: 0 - Views: 4731
MySQL: Connect From an Other System or Computer
How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?

First, you need to turn on the remote access for your database server.

Sample Setup

Consider the following sample setup:

[php] +----------- server1 192.168.1.6
|
+------------ tomcat1 192.168.1.7
|
+------
Author: UltratechHost - Replies: 0 - Views: 3436
Tweaking MySQL
There are a couple of good scripts out there that will help you to tune your mysql usage for better perfomance. I’ve used both of these, and they are very intuative. Personally, I prefer the latter, however, I still use both for tweaking.

“This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…”
to produce sane recomendations for tuning server variables.”

Installation:

Code:
root@server [~/downloads] # wget http://day32.com/MySQL/tuning-primer.sh

[c
Author: UltratechHost - Replies: 0 - Views: 5823
How to install pdo.so and pdo_mysql.so
Source:
Code:
http://www.directadmin.com/forum/showthread.php?t=24448

I just recently had to do this so I thought I might as well share. There are a few threads already with some info, but it's not entirely complete in my opinion.

Let's get started.

1) First off, issue this command to check your pear/pecl config:

Code:
pecl config-show

This will show you your config. Now if your /tmp is mounted noexec, skip the following and jump to step 2) now.

My /tmp is mount
Author: UltratechHost - Replies: 0 - Views: 5244
How To Install MyTOP - a top clone for MySQL
In this howto i will describe how to install mytop package on CentOS 5.7. MyTOP is top command clone to monitor mysql performance including queries, threads etc. You can get source of it from here to build or you can use rpmforge repositories for pre-build rpms. The machine i used to demonstrte is in production and getting very high mysql access, its running on CentOS 5.7.

1 Setting Up RPMForge Repository

RPMForge repository (http://