My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
DropCreateMysqlDatabase  
Command line database drop and create.
Phase-Deploy
Updated Jan 23, 2013 by jenifer....@gmail.com
    mysql --user=${mysqladminuser} --password=${mysqladminpass} \
      --execute="DROP DATABASE ${seven_mysqldrupaldata}"

    # Create database.
    mysql --user=${mysqladminuser} --password=${mysqladminpass} \
      --execute="CREATE DATABASE ${seven_mysqldrupaldata} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci"

        # Grant permissions.
        mysql --user=${mysqladminuser} --password=${mysqladminpass} \
      --execute="GRANT ALL ON ${seven_mysqldrupaldata}.* TO '${seven_mysqldrupaluser}'@'localhost' IDENTIFIED BY '${seven_mysqldrupalpass}'"

    # Load latest backup into empty database.
        mysql \
            --user=${seven_mysqldrupaluser} \
            --password=${seven_mysqldrupalpass} \
            --database=${seven_mysqldrupaldata} \
            < /var/local/backups/linode/seven-20130122203111.sql
Powered by Google Project Hosting