MySQL

phpMyAdmin’s Visual Query Designer
MS ACCESS to MySQL
|Backing Up and Restoring using phpMyAdmin

Table is marked as crashed and should be repaired

In das Datenbankverzeichnis einstein:/var/lib/mysql/avanger wechseln und folgenden Befehl ausführen
myisamchk -r mitglieder.MYI
mysqlcheck
mysqlcheck -A -r -p

A quick note on MySQL troubleshooting and MySQL replication recovery

root Passwort von MySQL vergessen

First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.

mysqld_safe –skip-grant-tables

You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.

mysql –user=root mysql

update user set Password=PASSWORD(’new-password’) where user=’root’;
flush privileges;
exit;

Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.

Joomla admin Passwort ändern

mysql -u root -pmyschool -e "UPDATE jos_users SET password=MD5('password') WHERE username='admin';"

MySQL Datenbank überprüfen

mysqlcheck --check [Datenbankname] -p   
mysqlcheck -A -p für alle

MySQL Datenbank versuchen zu reparieren

mysqlcheck --repair [Datenbankname.Tabellenname] -p   
mysqlcheck -A --repair -p (für alle!)

Diverse Fehler

Table is marked as crashed and should be repaired
- In das Datenbankverzeichnis einstein:/var/lib/mysql/avanger wechseln und folgenden Befehl ausführen

myisamchk -r mitglieder.MYI

Resetting MySQL Root Password

Datenbank sichern und zurückschreiben

backup: mysqldump datenbankname > daten.sql -ubenutzername -p
restore: mysqldump datenbankname < daten.sql -ubenutzername -p