Archivo de la categoría: PHP mySQL

Cursos de PHP y MySQL, Tips y ejemplos

respaldar usuarios joomla

Para respaldar los usuarios hay que copiar 3 tablas: jos_users jos_core_acl_aro jos_core_acl_groups_aro_map (assuming that jos is your prefix)

search and reemplace mysql mover wordpress a otro sitio

Sintaxis de MySQL update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); Para mover wordpress a otro sitio web update wp_posts set post_content = replace(post_content,’sitioviejo.com’,’sitionuevo.com’) update wp_posts set guid = replace(guid,’sitioviejo.com’,’sitionuevo.com’) update wp_options set  option_name = replace(option_name,’sitioviejo.com’,’sitionuevo.com’) update wp_options set  option_value = replace(option_value,’sitioviejo.com’,’sitionuevo.com’)

50 things to know before migrating Oracle to MySQL

A while back I was at a seminar on migrating database applications to MySQL. A lot of the attendees were Oracle users. Based on their questions, comments and conversations during lunch, I made the following list of things Oracle users need to know about migrating to MySQL. Most of these are “gotchas” that would be… Leer más »

Reset MySQL Password

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 que puede funcionar en otras distribuciones lo pongo para cualquiera que tenga el mismo problema… Leer más »

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 »