Script to REPAIR and OPMIZE your database

Script to REPAIR and OPMIZE your database.

<?
$settings_dir = "./settings";
require_once("$settings_dir/database.php";
mysql_query("REPAIR TABLE categories , domains , keywords , links , link_keyword0 , link_keyword1 , link_keyword2 , link_keyword3 , link_keyword4 , link_keyword5 , link_keyword6 , link_keyword7 , link_keyword8 , link_keyword9 , link_keyworda , link_keywordb , link_keywordc , link_keywordd , link_keyworde , link_keywordf , pending , query_log , sites , site_category , temp";
mysql_query("OPTIMIZE TABLE categories , domains , keywords , links , link_keyword0 , link_keyword1 , link_keyword2 , link_keyword3 , link_keyword4 , link_keyword5 , link_keyword6 , link_keyword7 , link_keyword8 , link_keyword9 , link_keyworda , link_keywordb , link_keywordc , link_keywordd , link_keyworde , link_keywordf , pending , query_log , sites , site_category , temp";
?>

when you got the links table of 2.5 GB
it's no so good this comand
i will better use phpmyadmin
but anyway you have better ideas

HaVe FuN

i think this better
<?
// mod by CyBerNe7
$settings_dir = "./settings";
require_once("$settings_dir/database.php";
mysql_query("REPAIR TABLE " . $mysql_table_prefix . "categories , " . $mysql_table_prefix . "domains , " . $mysql_table_prefix . "keywords , " . $mysql_table_prefix . "links , " . $mysql_table_prefix . "link_keyword0 , " . $mysql_table_prefix . "link_keyword1 , " . $mysql_table_prefix . "link_keyword2 , " . $mysql_table_prefix . "link_keyword3 , " . $mysql_table_prefix . "link_keyword4 , " . $mysql_table_prefix . "link_keyword5 , " . $mysql_table_prefix . "link_keyword6 , " . $mysql_table_prefix . "link_keyword7 , " . $mysql_table_prefix . "link_keyword8 , " . $mysql_table_prefix . "link_keyword9 , " . $mysql_table_prefix . "link_keyworda , " . $mysql_table_prefix . "link_keywordb , " . $mysql_table_prefix . "link_keywordc , " . $mysql_table_prefix . "link_keywordd , " . $mysql_table_prefix . "link_keyworde , " . $mysql_table_prefix . "link_keywordf , " . $mysql_table_prefix . "pending , " . $mysql_table_prefix . "query_log , " . $mysql_table_prefix . "sites , " . $mysql_table_prefix . "site_category , " . $mysql_table_prefix . "temp";
mysql_query("OPTIMIZE TABLE " . $mysql_table_prefix . "categories , " . $mysql_table_prefix . "domains , " . $mysql_table_prefix . "keywords , " . $mysql_table_prefix . "links , " . $mysql_table_prefix . "link_keyword0 , " . $mysql_table_prefix . "link_keyword1 , " . $mysql_table_prefix . "link_keyword2 , " . $mysql_table_prefix . "link_keyword3 , " . $mysql_table_prefix . "link_keyword4 , " . $mysql_table_prefix . "link_keyword5 , " . $mysql_table_prefix . "link_keyword6 , " . $mysql_table_prefix . "link_keyword7 , " . $mysql_table_prefix . "link_keyword8 , " . $mysql_table_prefix . "link_keyword9 , " . $mysql_table_prefix . "link_keyworda , " . $mysql_table_prefix . "link_keywordb , " . $mysql_table_prefix . "link_keywordc , " . $mysql_table_prefix . "link_keywordd , " . $mysql_table_prefix . "link_keyworde , " . $mysql_table_prefix . "link_keywordf , " . $mysql_table_prefix . "pending , " . $mysql_table_prefix . "query_log , " . $mysql_table_prefix . "sites , " . $mysql_table_prefix . "site_category , " . $mysql_table_prefix . "temp";
?>

Database contains: 325 sites, 122837 links, 37 categories and 3307500 keywords
[www.cyberfun.ro]

could you please tell me wher should i put this code please, thanks in advance

Yes, please advise us where to put this code??

anyone please

You put the code in a PHP file and then execute it

And...? Is it working or must we be carefull? It sounds very good, but I don't want to mess up +500.000 links/database. It's alot of work

I've set it in a cron and it doesn't seem to mess it up (I'm using cybernet's code). Go for it.

thx!

thanks man

looks fine, but we should re-invent the wheel? the corruption of databases can be fixed by Recovery Toolbox for SQL Server application, for example. Get the best sql database repair tool and try to reindex the database beyond question

in the code, what does the "smile" gif mean?

thanks.

-tp

If you quote the message with the code in it you will see the code without the smiley.
Apparently the smiley is only a (

Willy Wrote:
-------------------------------------------------------
> If you quote the message with the code in it you
> will see the code without the smiley.
> Apparently the smiley is only a (


Thanks Willy.

But in some posts I remember it was indicated to read smiley as

and ),

Does this smiley means different in different posts then? O do mean just one thing as you indicated "(" (without quotation) in all posts? I am really confused on this. I just want to get it right.

Thanks again for your help.

-tp

I believe it should read as ) in all cases.

Anyway, the way to check the correct code is to quote the message and copy the code from there, I think.

Thanks Willy.
appreciate your help.

-tp

I know easier ways to restore corrupted databases, this task can be performed by the best mssql recovery program.

Thank for the code. It helps now. saved as PHP file and it doesn't make my site a mess. Nice one!

"Always turn a negative situation into a positive situation."
Editor @ Daily Reviews

suretalu Wrote:
-------------------------------------------------------
> I know easier ways to restore corrupted databases,
> this task can be performed by the best mssql
> recovery program.


SQL ist "not" MySQL!

SQL files may be fixed owing to mdf recovery. The tool can work with sql databases from local area network. It can't modify your source data during restoration. The utility supports all popular versions of Windows OS.

There are two most important files in SQL i.e. .mdf and .LDF. Any corruption in these files makes you database inaccessible. You will encounter several error messages while trying to execute the query. In serious situation you may even fails to launch the application. For the safety of data it is very essential for you to repair SQL database as soon as possible. In order to repair database you can try third party sql repair tool.


[img]http://4.bp.blogspot.com/_IfZogJM_8EM/TKqi8S3uOzI/AAAAAAAAACU/3RBDYbCG824/s320/sql.jpg[/img]