Tag Info

New answers tagged

0

Please try the below query, REPAIR TABLE 'nagios_servicechecks' Try the above query in terminal or check the below link to repair table or databases via phpmyadmin http://php.about.com/od/mysqladministration/qt/repair_mysql.htm


0

You have not uninstalled MySQL-server-5.6.19-1.rhel5.x86_64 and MySQL-server, maybe others. Please do not remove manually package files, as that would only make thing more problematic. I quote a similar answer I wrote some time ago: Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql Delete any packages like mysql, ...


1

You told it to generate html. $ mysql -H my_base The -H option is an alias for the --html option. I assume you were thinking of -h ... which is the shortcut for --host. http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_html


0

The "friendly name" functionality is available client-side through the Connection Service File: The file uses an "INI file" format where the section name is the service name and the parameters are connection parameters; see Section 31.1.2 for a list. For example: # comment [mydb] host=somehost port=5433 user=admin Clients based on ...


1

The PostgreSQL protocol cannot support hostname based virtual servers, because the client doesn't send the hostname of the server in the initial connection packet like HTTP does in the Host header. Your only option is to add additional Elastic IP addresses. You will need to be able to tell which traffic came from which IP. Because EC2 instances don't have ...


0

You maybe have several Oracle home in your server. Check your path environment: ORACLE_HOME/bin should be in first position.


0

I use and love Dbeaver for db2 databases from Linux and Windows.


1

Start with (use the appropriate install syntax for your distro) sudo apt-get install libaio1 and if that doesn't do the trick, do sudo apt-get install libaio libaio-dev Paul...


1

Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql Delete any packages like mysql, mysql-server, mysql-client, mysql-shared, mysql-shared-compat, mysql-libs. yum remove mysql-server You do not need to remove mysql library bindings like python-mysqldb, php-mysql, etc., unless they had a dependency with some of the previous ...


1

With your initial feedback (you are using innodb), I can tell you that your innodb_buffer_pool_size is too small (2M), so most of your queries may be using disk instead of memory. As a rule of the thumb, for a dedicated server, the usual recommendation is reserving between 60-85% of the available memory for the innodb buffer. Increase it by setting it in ...


0

DBCA can be invoked with dbca (lower case). check the bash file and found out they are correct No they are not. The line that defines ORACLE_HOME is commented out, this also makes PATH incomplete. navigate to bin file and hit dbca but still the same error message If you navigate to the $ORACLE_HOME/bin directory while not having it in PATH, use ...


1

BASH: DBCA: command not found DBCA should be lower-case.


0

Changing the datadir requires the following steps: 1) Stopping the service completely mysqladmin shutdown / service mysql stop. 2) Changing the options on the config file for everything that points to the old location to the new one 3) moving the actual files and directories at the old datadir manually to the new location with cp/rsync (make sure that it ...


0

Open terminal and edit /etc/mysql/my.cnf sudo nano /etc/mysql/my.cnf Underneath the [mysqld] section.add: lower_case_table_names = 1 Restart mysql sudo /etc/init.d/mysql restart Then check it here: mysqladmin -u root -p variables


0

But the central inventory location should be /u01/app/oracle/oraInventory, not what you have. It is much better to follow the recommandations of Oracle for directories naming (see OFA section in installation guide). check what is the id and the group of the user running the runInstaller, usually it is oracle:oinstall then as user root mkdir -p ...



Top 50 recent answers are included