Skip to main content

mysql

Drupal, fast dump

During development, it's comfortable to have a command in bash history to create a quick development dump:

Create phpmyadmin local instance

wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip -O phpmyadmin.zip

unzip phpmyadmin.zip && rm phpmyadmin.zip

ORDER BY Flexible

Soooo nice:

SELECT * FROM `menu` WHERE weight != 0 ORDER BY (CASE type WHEN 118 THEN 2 WHEN 54 THEN 4 END) DESC