Netzflut

Webdesign, Webentwicklung, Drupal & Zeuchs

MYSQL Kommandos

Inhaltsverzeichniss

    http://linux.die.net/man/1/mysqldump
    http://www.linux-fuer-blinde.de/84-0-datenbank--und-benutzerverwaltung.html
    http://www.pantz.org/software/mysql/mysqlcommands.html | LISTE AN COMMANDS

    CONSOLE

    Login
    mysql -u BENUTZERNAME -p DATENBANKNAME

    Tabelle erzeugen
    create database postfix;

    add user
    create user 'marco'@'localhost' identified by 'geheim';

    rechte gewähren
    grant all on nameOfyourDb.* to 'marco'@'localhost';

    alle datenbanken zeigen
    show databases;

    Datenbank wählen
    use dbname;

    Backup all databases

    mysqldump --all-databases -p > file.dump
    mysqldump --all-databases --user=root --password=mypassword > file.dump
    Example back up a db
    mysqldump testdbcase_oc2 -p > tc4.sql

    Backup einspielen
    mysql -u BENUTZERNAME -p DATENBANKNAME < PFAD_ZUR_DATEI

    Restore all databases

    mysql --user=root --password=mypassword < file.dump

    Checkn & Repair

    http://www.softwareprojects.com/resources/programming/t-how-to-fix-mysql-database-myisam-innodb-1634.html
    http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
    check

    artwaves:/var/www/WORKSPACE_DRUPAL# mysqlcheck --user=root --password=mypass texturesite_public

    Sample (userpoints)

    free_reset.sql

    UPDATE userpoints, users_roles SET userpoints.points = 15000 WHERE userpoints.uid = users_roles.uid AND users_roles.rid = 4

    crontable

    # m h dom mon dow command
    50 20 * * * /usr/bin/wget http://192.168.1.238/WORKSPACE_DRUPAL/artwaves_drupal_texturesite/cron.php
    */2 * * * * mysql --user=USERNAME --password=PASSWORT -D databasename < /home/www-data/free_reset.sql
    Design&Code: