Tag Info

New answers tagged

2

You can see if a dump is running from within PostgreSQL by checking for pg_dump or pg_dumpall as the application_name in pg_stat_activity. It's not perfect though, since the client has to connect to each DB in turn, so there might be a period with no visible connection. I haven't verified whether pg_dumpall maintains its connection throughout, while running ...


0

I prefer using ucarp for VIP management in conjunction with DRBD I have some posts advocating MySQL, DRBD and ucarp Feb 10, 2014 : MySQL High Availability for InnoDB Oct 17, 2012 : Creating High Availability Cluster with PostgreSQL Dec 19, 2011 : Best way to setup master to multi master replication What might interest you the most is my old post ...


0

I've had the same issue you are facing. solution was: mkdir -p /u01/app/oraInventory chown -R oracle:oinstall /u01/app/oraInventory chmod -R 775 /u01/app/oraInventory I hope it works for you.


0

You can force case sensitivity with lower_case_table_names Add this to your my.ini [mysqld] lower_case_table_names=0 Since lower_case_table_names is not dynamic, you must then restart mysql as Administrator with C:\> net stop mysql C:\> net start mysql The MySQL Documentation says the following You should not set this variable to 0 if you ...


1

Your max_connect_errors is way too low. You have it at 1000. That means after 1000 consecutive connect failures, you cannot connect to MySQL any longer. Your status variable Aborted_connects should be the dead giveaway if it climbs fast. When you can no longer connect to MySQL even with bunch of open DB Connections, you would have to execute FLUSH HOSTS; ...


0

After thorough research, we determined that the problem was that WordPress was being attacked and it was causing MySQL to use the maximum amount of memory allotted to it in the configuration files. Even caching of WordPress pages could not stop this illegitimate traffic from using all of the memory because of the sheer volume of IP addresses the attackers ...


1

If you're running on Linux (any with awk), you could run: awk '!/^DROP TABLE IF EXISTS/{print}' db_dump_sql | mysql -u $user -p --force --database=$db PD: I added --force that means: --force, -f Continue even if an SQL error occurs. Test: root@onare:/home/onare# touch db_dump_sql root@onare:/home/onare# echo "DROP TABLE IF EXISTS/" >> ...


2

cat 1.sql | grep -v "DROP TABLE" | mysql --force Assuming no other string contains drop commands this should work.. Updated: use --force to ignore errors by CREATE TABLE.


0

InnoDB: Unable to lock ./ibdata1, error: 11 Perhaps another copy of mysqld is still running? Only run it as a service.


0

This problems seems to permission issues or change the mysql data direcory to other location then /var/lib/mysql. Try to run with sudo Looks like /var/lib/mysql is owned by the mysql user and the group is set to mysql as well. $ sudo chown -R mysql /var/lib/mysql $ sudo chgrp -R mysql /var/lib/mysql $ sudo chmod 755 /var/lib/mysql Have you checked ...


0

Sorry for the above wrong input. I had not followed the question. Here is another set of solution for the above problem: Step 1: create .monetdb file in the home directory as below: cat << EOF > $HOME/.monetdb user=monetdb password=monetdb EOF Step 2: Replace the above content with your monetdb username and password. Step 3:Change the file ...


1

From My Oracle support, Doc ID 1304727.1 Red Hat Enterprise Linux 7 - 11.2.0.4 only Oracle Unbreakable Enterprise Kernel:3.8.13-35.3.1.el7uek.x86_64 or higher Red Hat compatible kernel: 3.10.0-123.el7.x86_64 or higher So, unless you are installing 11.2.0.4, you will have compatibility issues on RHEL7. Either install 11.2.0.4 and up on ...


2

Oracle 11g R2 Database Release 2 only support Windows, Linux, and Solaris. So if you want to using Oracle 11g R2 on a Mac OS you will need to using something like Virtual Box or VMware Fusion. You can read more about installing Oracle 11g R2 on these operating system here.



Top 50 recent answers are included