andkirby/mage-db-helper

Database Helpers (Magento)

Magento Database Helpers

Overview

There are DB procedures/functions to help work with Magento DB., _(*1)

Composer installation

$ composer global require andkirby/mage-db-helper

global parater can be ommited if you won't use this installation globally., _(*2)

Install scripts

$ mage-db-helper install -d dbname -u dbuser -p password1

If parameter --mysql-password (-p) (MySQL password) is ommited you may set it in dialog to make this command secured. Also you may skip asking password with parameter --no-password (-o);, _(*3)

More

To get full help about parameters please use standard --help (-h) parameter., _(*4)

$ mage-db-helper install -h

Usage Helpers in Database

There are available helpers: - DropAllTables, - ResetBaseUrl. - ResetAdmin., _(*5)

DropAllTables

Remove all tables from database. It useful to prevent reinstalling exists procedures (like these ones)., _(*6)

CALL dbname.DropAllTables();

ResetBaseUrl

Reset base URLs in core_config table. It useful when you migrate database., _(*7)

CALL dbname.ResetBaseUrl('old-server.example.com', 'new-one.example.com');

ResetAdmin

Reset password, username (set to admin) and locking of first admin user (ID #1) in admin_user table. It useful to reset admin user quickly., _(*8)

CALL dbname.ResetAdmin('your-new-password');

Note: dbname could be omitted in examples if you run use dbname; before., _(*9)