Homebrew installed MariaDb too many open files

Submitted by clemens on Fri, 2020/11/13 - 9:08am

MariaDB broken

It happened again.

I did brew update/upgrade a while ago then weeks after that restarted MariaDB then days later tried to access MariaDB.

MariaDb too many open files

Trying to get info over the config file seems not easy.

homebrew
mariadb
mysql

Updating mysql for Drupal 8

Submitted by clemens on Sun, 2015/05/10 - 6:05pm

As Drupal 8 now required a mysql version higher then my current manually installed version 5.1.46 released on April 23, 2010 I have to try yo get rid of that version and install the latest through homebrew.

mysql
homebrew

Who is currently online

Submitted by clemens on Thu, 2011/01/13 - 11:06am

I want to run svn up on the site but I need to offline it first. So who is online?

SELECT name, mail, (unix_timestamp()-access)/3600 AS hours
  FROM users
  HAVING hours < 1
  ORDER BY access;

Or for short

drush sql-query "select name, mail, (unix_timestamp()-access)/3600 as hours from users having hours < 1 order by access;"

drush
drupal
mysql

mysql on mac

Submitted by clemens on Tue, 2011/01/11 - 8:56am

(this is my scratchpad)
I installed mysql on a mac straight from mysql website. Not sure whether that was a wise decision.

cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
vi /etc/my.cnf 
/Library/StartupItems/MySQLCOM/MySQLCOM stop
/Library/StartupItems/MySQLCOM/MySQLCOM start
free form: 
mysql
osx

Dumping all tables with drush

Submitted by clemens on Thu, 2010/05/20 - 12:46pm

I want a clean database without clicking.

echo "\
SELECT concat('drop table ', table_name, ';') \
  FROM information_schema.tables \
  WHERE table_schema=schema()" \
| `drush sql-connect` \
| grep "^drop table " \
| `drush sql-connect`

This work only for single drupal / single schema installs.

drush
grep
mysql

Create and Fill the database

Submitted by clemens on Tue, 2009/06/23 - 11:23am

Just follow README.mysql.txt

mysqladmin -u root -p create drupaljam_demo
mysql -u root -p 
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON drupaljam_demo.* TO 'drupaljam_demo'@'localhost' IDENTIFIED BY 'drupaljam_demo';

Prepare settings.php

mv default.settings.php settings.php 
chmod 777 settings.php

Add the site to apache (my steps)

cd /etc/apache2/sites-available/
cp drupaljam.dev drupaljam.demo
vi drupaljam.demo
a2ensite drupaljam.demo
vi /etc/hosts
# add 127.0.0.3 drupal.demo

free form: 
mysql
mysqladmin

Relocating the files directory

Submitted by clemens on Tue, 2009/02/03 - 11:10am

Trying best practices I occasionally move the files directory from DRUPAL_ROOT/files/my-site.com to DRUPAL_ROOT/sites/my-sites/files

Doing this has some implications for the files table content. All file-path are pointing to the wrong location.

Quick solution for this is an mysql replace update query.

select replace(filepath, 'files/my-site/', 'sites/my-site/files/') from files;
# update files set filepath=replace(filepath, 'files/my-site/', 'sites/my-site/files/')"

Or through drush

free form: 
drush
mysql
planet drupal

mysql cycle

Submitted by clemens on Mon, 2008/03/03 - 12:18pm

I still forget how to do the database and user creation and drop goes. So why not make a note.

Creating

create database test;
create user 'test' identified by 'pwtest';
grant all on test.* to 'test'@'localhost' identified by 'pwtest';

Cleaning up

drop user test;
drop database;

Yeah ... call me stupid ;-)

installation
mysql