PDA

View Full Version : why~???


1001story
2-2-06, 06:01 PM
hello:~

my English is poor~

wish you can understand what I say~::



theres some problem in my mysql database today:

Error
SQL query:

SELECT COUNT( * ) AS num
FROM `phparticle`.`twbb_session`

MySQL said:

#1016 - Can't open file: 'twbb_session.MYI' (errno: 145)


would you please check it for me~~thanks^^"
my domain:1001story.com

mitchind
2-2-06, 07:10 PM
You can try running this script from your htdocs directory if you want. Save it as a .php file and run from your browser. Make sure to replace all your database info at top.
<?php
//
// mysql-auto-repair.php
//
$host = 'mysqlxx.powweb.com'; // database host address
$dbuser = 'your_db_username'; // database user name
$dbpswd = '****'; // database password
$mysqldb = 'your_db_name'; // name of database
//
// ************************************************** *********
//
system( "/usr/local/bin/mysqlcheck --user=$dbuser --password=$dbpswd --host=$host --auto-repair $mysqldb",$result);
?>