• phpMyAdmin 4.3.8 released

    phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement, manage indexes on columns. phpMyAdmin 4.3.8 changelog Undefined constant PMA_DRIZZLE Wrongly positioned date-picker while Grid-Editing ¬†Forced ORDER BY for own sql statements Undefined […]
    • by
    • 2 Years ago
    • 0
  • Backup all SQL instance databases

    I had a situation where I needed to backup hundreds of databases to a USB drive. In this circumstance the GUI was out of the question. After some searching online I found this script: [sourcecode language="sql"]<br />DECLARE @name VARCHAR(50) -- database name<br />DECLARE @path VARCHAR(256) -- path for backup files<br />DECLARE @fileName VARCHAR(256) -- filename […]
    • by
    • 5 Years ago
    • 0