User Tools

Site Tools


mysql

Datenbank anlegen

> mysql --user=root mysql --password='pwd'

mysql> create database wordpress;


mysql> GRANT ALL PRIVILEGES ON wordpress.* TO wp@localhost IDENTIFIED BY 'pwd' WITH GRANT OPTION; 
Query OK, 0 rows affected (0.03 sec)

Kaputte/gecrashte mysql Tables reparieren

myisamchk wp_*.MYI > /tmp/out
myisamchk -r wp_comments.MYI
myisamchk -r wp_options.MYI wp_ratings.MYI wp_sfsettings.MYI wp_sftopics.MYI wp_sftrack.MYI
mysql.txt · Last modified: 2014/09/10 21:22 (external edit)