mytab.ru under construction...

some useful things:

-----------------------------------------------------------------------------
1) replace tabs in files with 4 spaces

==== file: rmtabs.sh ====
#!/bin/bash
for i in `find $1 -name $2 `; do
echo $i
expand -t4 $i > $i"_"
cp -rf $i"_" $i
rm $i"_"
done;
=========================

rmtabs.sh /var/www/somedirhere *.php

-----------------------------------------------------------------------------
2) export struct, export data, import file

mysqldump -uroot -p12345678 --no-data test > full.sql
mysqldump -uroot -p12345678 --skip-extended-insert --disable-keys --no-create-info --skip-triggers test > data_full.sql
mysql -uroot -p12345678 test < data_full.sql

-----------------------------------------------------------------------------