Archivo de la categoría: PHP mySQL

with process privileges: without process privileges (process privilege error) –no-tablespaces

For those who have their wordpress root folder under their home folder: Ubuntu/apache Add your user to www-data group: CREDIT Granting write permissions to www-data group You want to call usermod on your user. So that would be: sudo usermod -aG www-data yourUserName Assuming www-data group exists Check your user is in www-data group: groups… Leer más »

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)

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’)

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 »

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 »

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

============================= 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 »

http://www.howtoforge.com/mysql_database_replication