Once Again "Database Crash"

[Dark Warrior]

Idk if you remember my last post i had a data base crash.... talatauren helped me... but now im havin truble again now theres no "repair option"
Just Flush Table and i did it already and nothin wrong..

Help me plaxord

 

[ntmr]

Repair it and change the storage engine from MyISAM to InnoDB.

 

[Dark Warrior]

Repair it and change the storage engine from MyISAM to InnoDB.

Aha but how i can repair it? theres no option to repair can you please read my post before posting?

 

[ntmr]

Execute that on the query window:

REPAIR TABLE player_items;

 

[Dark Warrior]

Execute that on the query window:

REPAIR TABLE player_items;

you are the man XD!!! thanks mate another thing how i can change to inodb?? when i click on Storage Engine theres no "Innodb"

 

[ntmr]

If you can't see that option, you will need to change the mysql server configuration and restart the server.

Search for my.ini on your xampp folder, open the file and search for skip-innodb and change to #skip-innodb

Restart xampp/mysql.

Now you will be able to change the storage engine to InnoDB.

Remember to change all tables!

 

[Dark Warrior]

my ini where? i don't see it

 

[ntmr]

On the xampp folder (I don't know where, never used xampp), maybe on xampp/mysql/my.ini.

 

[Dark Warrior]

On the xampp folder (I don't know where, never used xampp), maybe on xampp/mysql/my.ini.

Theres no ini file there...
If some1 got xampp thats know wheres that ini file please posts...

 

[ntmr]

xampp/mysql/bin/my.cnf

You need to be ninja to open that file on a text editor

After edit it, run xampp/mysql/mysql_installservice.bat

xampp is realy a big shit...

 

[Dark Warrior]

xampp/mysql/bin/my.cnf

You need to be ninja to open that file on a text editor

After edit it, run xampp/mysql/mysql_installservice.bat

xampp is realy a big shit...

theres no my.cnf

 

[ntmr]

The "my, SpeedDial, 6 KB" is the my.cnf.

As I said, you need to be a ninja to open that file on a text editor

The way I done to edit that file:

1 - open a windows command window.
2 - browse to the xampp/mysql/bin folder (cd C:\xampp\mysql\bin)
3 - copy my.cnf my.txt
4 - edit the my.txt and save
5 - copy my.txt my.cnf