Results 1 to 6 of 6

Thread: Need WordPress database skills

  1. #1
    Join Date
    Feb 2010
    Posts
    763

    Need WordPress database skills

    Hi all,

    WordPress has a wealth of plug-ins, themes, the main build a successful blog tool for the broad masses, WordPress blog is supported by MySQL, and in the process of writing the blog, sometimes have to involve some of the MySQL database operations, although plug-ins and code changes also help us solve the problem, but it is also treating the symptoms not the root cause of the rich, free, rational use of phpMyAdmin to carry out data operations are necessary. So can anybody suggest me some WordPress database skills. Thanks in advance,

  2. #2
    Join Date
    May 2008
    Posts
    2,134

    Need WordPress database skills

    Database backup for owners is very necessary, this network involves a lot of turmoil, Webmaster, if the site back up, then it can be restored in a short time together, let's will, your site also OVER, and, of course, you can also use the WP-DB-Backup plug-in implementation of the database backup is very convenient, WordPress users can install this plug-in and regularly back up data. All the best.

  3. #3
    Join Date
    Oct 2005
    Posts
    2,358

    Need WordPress database skills

    Wordpress strong interaction is also one of its advantages, this advantage could be been used by a lot of spam, but by a simple delete statement, we can solve this problem, execute this command:
    Code:
    DELETE from wp_comments WHERE comment_approved = '0 ';
    So, all the junk ads can be deleted is completed. Check and reply.
    I'm the Proud Owner of the most dangerous weapon
    known to man kind: Human Brain

  4. #4
    Join Date
    Apr 2008
    Posts
    2,572

    Re: Need WordPress database skills

    Wordpress in order to increase security, will be automatically generated is not easy to break a secret, however, the main Bo will also appear at times forget the password to happen, it is that we can, through phpmyadmin to re-modify the password, use the following command can be a :
    Code:
    UPDATE `wp_users` SET `user_pass` = MD5 ( 'PASSWORD') WHERE `wp_users`. `User_login` = `admin` LIMIT 1;
    This password change successful. All the best.

  5. #5
    Join Date
    May 2008
    Posts
    2,792

    Need WordPress database skills

    As the WordPress domain name is stored in the database, so in order to bring new domain name and blog link, you must change the database, use the following command to modify:
    Code:
    UPDATE wp_options SET option_value = replace (option_value, 'http://www.oldsite.com', 'http://www.newsite.com') WHERE option_name = 'home' OR option_name = 'siteurl';
    Use the following statement to replace all of the log of the relative URL (guid Globally Unique Identifier)
    Code:
    UPDATE wp_posts SET guid = replace (guid, 'http://www.oldsite.com', 'http://www.newsite.com');
    Search wp_posts table and replace one of the URL, in order to ensure that no old URL exists:
    Code:
    UPDATE wp_posts SET post_content = replace (post_content, 'http://www.oldsite.com', 'http://www.newsite.com');

  6. #6
    Join Date
    Apr 2008
    Posts
    2,277

    Need WordPress database skills

    wordpress upgrade relatively fast, so do not have to upgrade another great blog, if the modification or upgrade a blog or other causes of data loss or damage, I hope you have a backup of the database, so you can back up the database into the database in order to cover the losses. You can also use it to "change the log properties" and other operations, on the whole, phpmyadmin function is very strong, it can help you make better use of Mysql database. All the best.

Similar Threads

  1. How to Convert phpBB database to WordPress
    By Ilampirai in forum Technology & Internet
    Replies: 5
    Last Post: 11-06-2011, 10:17 AM
  2. plugin to import the donnee from csv file to wordpress database
    By manjava in forum Technology & Internet
    Replies: 2
    Last Post: 09-06-2010, 04:30 AM
  3. How to change wordpress database connection
    By Valerian in forum Networking & Security
    Replies: 3
    Last Post: 26-05-2009, 01:54 PM
  4. Error establishing a database connection in Wordpress
    By Anikait in forum Windows Software
    Replies: 5
    Last Post: 25-05-2009, 05:32 PM
  5. what is wordpress? How to install Newer versions of wordpress.
    By Gill_christ in forum Technology & Internet
    Replies: 3
    Last Post: 21-05-2009, 02:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,724,657.02998 seconds with 17 queries