Sunday, May 25th, 2008
Goodbye MySQL
I was optimistic that I could make http://www.cenite.com, a price monitoring website to use the fulltext search of mysql. Unfortuntly I have found so many drawbacks that I have to leave this idea. The main source for information for me was:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
http://devzone.zend.com/node/view/id/1304#Heading14
At first the speed was wonderfull. I was searching ...
Posted in Databases | No Comments »
Tuesday, May 20th, 2008
Status
SHOW status where Variable_name like 'Th%' or Variable_name like '%Connec%' ;
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr]
Check/Repair tables
mysqlcheck -u root -p***** --auto-repair --check --optimize --all-databases
Dump
pg_dump -U test arachnid_archiv_test --inserts -h chaos.spider.bg --encoding=utf8 -f pgsql.sql
mysqldump -c -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASS -r $tfile --add-drop-table $DB
mysqldump -c -h ...
Posted in Databases, Uncategorized | 1 Comment »
Sunday, April 13th, 2008
It was time to migrate http://www.cenite.com database from cp1251 -> utf8, I have prepared one nice script which will show you step by step the commands that you should run in order to migrate your database.
Copy the content to cp1251toUTF8.sh or use the commands manually
The script is making echo instead ...
Posted in Databases, Uncategorized | No Comments »