Skip to main content

Posts

Showing posts with the label Red Hat Enterprise Linux

Exposing Oracle Database Connection

 Exposing Oracle Database Connection After Installation, your connection to the Oracle database is not yet exposed so you'll need to configure it inside Oracle .

Download and Install Java SDK 6u12

 Download and Install Java SDK 6u12 Click this link to download jdk-6u12-linux-i586-rpm.bin To install the downloaded bin file, simply enter these commands: [root@localhost~]# chmod a+x jdk-6u12-linux-i586-rpm.bin [root@localhost~]# ./jdk-6u12-linux-i586-rpm.bin # accept the license agreement presented by the installer, then # wait for the installation to finish

How to backup and restore MySQL Database

How to backup and restore MySQL Database Backup MySQL Databaase Syntax: mysqldump -u root -h localhost -p [database name] > [script file name].sql after entering this command, MySQL will ask for root password. Simply supply password and press enter. To Restore MySQL Database to your newly created database: Make sure that the name of your new database is the same with the name of your old database. mysql -u root -h localhost -p [dataabase name] < [script file name].sql after entering this command, MySQL will ask for root password. Simply supply password and press enter.

Configure MySQL 5.1 to RHEL 4

Configure MySQL 5.1 to RHEL 4 This is how i do to configure MySQL to RHEL 4 using terminal MySQL will automatically start after the successfull installation to the machine.   1. Since i can't find the my.cnf file and this message always appear [root]# /etc/init.d/mysql status /etc/init.d/mysql: line 412: test: 20424: binary operator expected MySQL is running but PID file could not be found [FAILED] , i download it from the net...here is the code: [mysqld] datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=32M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 64MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1M...