Archivo de la categoría: Programación

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 »