Fulltext results:
- MySQL: Create Database
- ====== MySQL: Create Database ====== ==== Create Database ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; </code> ==== Create Database and Grant Rights to a User ==== <code sql> CREATE DATA
- MySQL: Backup
- ====== MySQL: Backup ====== ===== Export a Database ===== <code bash> # set or replace the variables $USER... ${USER} -p${PASS} ${DB} </code> ===== Export all Databases individually ===== <code bash> # set or replace... bles $USER and $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases') for db in ${DATABASES} do mysqldump --add-
- MySQL: Remove Database
- ====== MySQL: Remove Database ====== ==== Remove Database ==== <code sql> DROP DATABASE IF EXISTS `{db}`; </code> {{tag>admin database mysql sql}}
- Database Administration
- ====== Database Administration ====== {{indexmenu>.}}