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.…
If you accidentally lost the /etc/mysql/debian.cnf file, you can simply run:
1 | dpkg-reconfigure mysql-server-5.0 |
Or the equivalent, e.g.:…
1 | mysql_upgrade --verbose -udebian-sys-maint -p |
…
…
Update 2: official solution
Update: apparently this is a better solution.…
Create a /etc/init/lxc-custom.conf with the following contents
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).…