Showing 30 Result(s)

How To Reset MySQL Auto Increment Column

MySQL database provides a beautiful feature of Auto Increment Column index. Database table can define its primary key as Auto Increment number and MySQL will take care of its unique value while inserting new rows. Each time you add a new row, MySQL increments the value automatically and persist it to table. But sometime you …

What is a WordPress Theme Text Domain ?

In this example ‘my-theme-textdomain’ is the defined as textdomain for the Theme. Text Domain is used to make the Theme translatable. (Codex reference: load_theme_textdomain()). Define the Theme’s textdomain load_theme_textdomain( ‘my-theme-textdomain’, TEMPLATEPATH.’/languages’ ); Define translatable strings in the template. This is done using one of a few translation functions: __() (for returned strings), _e() (for echoed …

Setting up new hostname with WordPress database

For setting up new hostname with WordPress database is required while moving site to new hostname. For this following SQL commands. In following example we are moving site with hostname dev.example.com to hostname www.example.com. UPDATE wp_options SET option_value = REPLACE(option_value,’http://dev.example.com’,’http://www.example.com’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,’http://dev.example.com’,’http://www.example.com’); UPDATE wp_posts SET guid = REPLACE(guid,’http://dev.example.com’,’http://www.example.com’);