Category Archives: PHP mySQL

en estos simples pasos se puede resetear el password de root de mysql el cual me tuvo batallando con manuales y no lo lograba esto lo probe en mi centos 4.4 y me funciono a la perfeccion, pero me imagino … Continue reading →

http://forge.mysql.com/tools/tool.php?id=16

This tutorial will go through the setup of MySQL database replication. I will also talk about how to get everything working smoothly again after a server crash, or if you wish to switch databases. I will try to explain what … Continue reading →

============================= MASTER: add lines to my.cnf ============================= binlog-do-db=database_name_1 binlog-do-db=database_name_2 binlog-do-db=database_name_3 ============================= MASTER: SQL SYNTAX ============================= GRANT REPLICATION SLAVE ON *.* TO ‘user’@'%’ IDENTIFIED BY ‘password’; FLUSH PRIVILEGES; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; SHOW MASTER STATUS; output> file | … Continue reading →

http://www.howtoforge.com/mysql_database_replication

PHP 5 Oscommerce BUG Hello! D:\xampplite\htdocs\linux\shop\admin\includes\classes\ipload.php on line 31 i did this: instead of this: ________________________ // self destruct $this = null; return false; } } } ________________________ biggrin.gif i did this: ________________________ // self destruct unset($this); return false; } … Continue reading →

Hide Intro Text we usually set the defaults in the relevant XML files for the user to make it easier when they are adding and editing new content. Like you, we often find we’re wanting Hide intro text on by … Continue reading →

 update esalud_content set introtext = replace(introtext,CONVERT( _utf8 ‘%{ }%’ USING latin1 ),’ ‘)

{moseasymedia media=/consulta/banner.swf height=195 width=170}

El valor inicial para AUTO_INCREMENT para la tabla. En MySQL 5.0, sólo funciona para tablas MyISAM y MEMORY. También se soporta para InnoDB desde MySQL 5.0.3. Para inicializar el primer valor de auto incremento para motores que no soporten esta … Continue reading →