Drupal backup quick tips
When I had to backup a large database I realized that timeout is a great enemy. I usualy do the following in order to avoid […]
Category Archives: Transact SQL
Add composer to a Drupal 8 website
I have a customer with a version of Drupal 8 that did not support composer, as it became necessary to have it with newer versions, […]
How to import a mysql database from command line
TLDR It’s simply telling mysql: which user is doing the database import using -u to which database it should be imported using -p and finally […]
Replacing WordPress URLs with SQL command
WARNING – Always make a backup before modifying your database. This came really handy when you have to manually migrate a WordPress website to another […]
Get list of tables with total row number
Imagine that a customer calls you and complains that your application is becoming too slow. There might be tons of reasons for that, in some […]