invent.life

  • hello
  • whoami
  • thoughts
  • sysadmin
  • artlab
Select Page

Dumping a sample from a MySQL instance or a database

databasesdumpingMariaDBMySQLmysqldumpsamplingSQL

h

by Bazyli Brzóska | April 29th, 2015 | Code & Security

Say you want to dump a database, or even all databases, but with just a sample of all the data, say, 10 000 records per table of each of the databases.…

Resetting MySQL password on Debian/Ubuntu

http://www.debian-administration.org/articles/442

Recreate debian-sys-maint user and the debian.cnf file

debianMySQLubuntu

h

by Bazyli Brzóska | September 15th, 2013 | Code & Security

If you accidentally lost the /etc/mysql/debian.cnf file, you can simply run:

Shell
1
dpkg-reconfigure mysql-server-5.0

Or the equivalent, e.g.:…

Converting MyISAM to InnoDB

http://jnrbsn.com/2011/08/using-sql-as-a-full-fledged-procedural-scripting-language

Upgrade MySQL to MariaDB

MariaDBmigrationMySQLupgrade

h

by Bazyli Brzóska | August 8th, 2013 | Code & Security

Shell
1
mysql_upgrade --verbose -udebian-sys-maint -p

…

Observium with MariaDB & nginx + client configuration

MariaDBMySQLnginxObserviumObservium Client

h

by Bazyli Brzóska | August 2nd, 2013 | Code & Security

Shell
…

Install iRedMail with a socket connection to an already installed instance of MariaSQL

iRedMaillxcMariaDBMySQL

h

by Bazyli Brzóska | July 24th, 2013 | Code & Security

Update 2: official solution
Update: apparently this is a better solution.…

LXC automatic mysql socket binding on container boot using upstart

containerlxcMySQL

h

by Bazyli Brzóska | May 20th, 2013 | Code & Security

Create a /etc/init/lxc-custom.conf with the following contents

Shell
1
2
3
start on mounted MOUNTPOINT=/run
 
exec ln -s /shared/run/mysqld /run/mysqld

This will automatically bind your shared mysql socket (if you have a set-up like mine).…

  • Facebook
  • Twitter
  • RSS

Copyright © 2009-2021 Bazyli Brzóska.