MyTechForum
database
-
How do I find active queries in my Oracle database?
To find active queries in your Oracle database, you can use the following command: SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time FROM...
-
How do I install SQLPlus on Mac OS X Lion?
Having SQLPlus installed on your Mac is very handy! Follow the steps below to install it. 1. First you’ll need to go...
-
How do I install the Oracle 10g client on a RedHat Enterprise Linux 5 server?
To install Oracle 10g on a RHEL 5 server, you need to perform the following steps as root: //create user and groups...
-
How do I reset the MySQL root password on my Unix server?
If you lose or forget the root password for your MySQL database, you can use the procedure below to reset it. 1....
-
How do I clean up MySQL bin logs?
If you are NOT replicating, you can disable bin logging by changing your my.ini or my.cnf file. # vi /etc/my.cnf Find a...
-
How Do I Set Up Database Replication In MySQL?
MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all...
-
How do I kill a MySQL process?
To kill a process in MySQL, you can login to the database and do the following: show processlist; or show processlist\G; Find...
-
How do I run a MySQL query in a script?
To use a MySQL query in a script, you can do so like this: #!/bin/bash echo “use testdb; select Name, Address from...
-
How do I analyze the MySQL slow log?
You can use a command called mysqldumpslow to analyze the slow login in MySQL. To you use it, you must first enable...
-
How do I check and repair MySQL tables?
To check a certain table for consistency with MySQL after you select the database, you can run: mysql$ CHECK TABLE table_name; If...