-
Recent Posts
Recent Comments
Archives
Categories
Meta
Monthly Archives: April 2011
MYSql copy tables
create table tablename_new like tablename; -> this will copy the structure… insert into tablename_new select * from tablename; -> this would copy all the data
Find and replace in MYSQL
Updating Data in MYSql update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘); For moving wordpress installs to repair the guid UPDATE wp_posts SET guid = replace( guid, ‘web/’, ” ) ;
Posted in MySQL, Wordpress
Tagged data manipulation, data transfer, mysql, sql, wordpress
Comments Off
WordPress Super Loop
// if everything is in place and ready, let’s start the loop <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?> // to display ‘n’ number of posts, we need to execute the loop ‘n’ number … Continue reading
Moving Virtuemart
When moving virtuemart from a build directory Edit administrator\components\com_virtuemart\virtuemart.cfg.php define( ‘URL’, str_replace(“/administrator/”,”/”,JURI::base())); define( ‘SECUREURL’, str_replace(“/administrator/”,”/”,JURI::base()));
Chmod Web directories from the command line
find /path/to/base/dir -type d -print0 | xargs -0 chmod 755 find /path/to/base/dir -type f -print0 | xargs -0 chmod 755 these guys rock http://superuser.com/questions/91935/how-to-chmod-755-all-directories-but-no-file-recursively
