Archivo de la categoría: Programación

How to Setup MySQL Replication

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 is going on behind the scenes for every step (something I’ve found missing from other… Leer más »

Replication MySQL multiple DBs

============================= 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 | Position | Binlog_Do_DB mysql-bin.000963 1570 database_name_1,database_name_2,database_name_3 ============================= SLAVE: add lines to my.cnf ============================= replicate-do-db=database_name_1 replicate-do-db=database_name_2… Leer más »

PHP 5 OSCOMMERCE BUG

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; } } }

Hide intro text joomla

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 default. So, instead of setting it globally we edit administrator/components/com_content/content.xml change line 28 where it… Leer más »

Search and Reemplace

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

AUTO_INCREMENT

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 opción, inserte un registro de prueba con un valor que sea uno menor al deseado… Leer más »