Phabricator offers a bin/storage shell command. It allows to run the mysql client with the options from the application configuration. That’s useful in a modern distributed environment, when it’s not always straightforward to know what server contains what databases and what credentials to use. In a Docker container, for example, that could be a linked […]
Read moreFollow-up: a BASH script to split a MySQL dump by database
In this post, we’ve seen how to split a large MySQL dump by database. I’ve been asked a script to automate the process. Here you are. Note: On FreeBSD, replace AWK=awk by AWK=gawk and install lang/gawk port, so we can use GNU awk. #!/usr/bin/env bash AWK=awk REGEX_NAME=”Current Database: \`(.*)\`” # Checks argument and prints usage if needed […]
Read moreSplit a large SQL dump by database
You created a MySQL backup of a large server installation with dozens of databases and wish to get the schema and data for one of them. You now have to deal with a file of hundreds of MB in a text editor. How convenient. Split a dump into several files You can quickly split this […]
Read more