Table Overview

Source: https://codex.wordpress.org/Database_Description
WordPress 3.8 Tables (11)

There are all together 11 tables by default. They are :

• wp_options
• wp_users
• wp_links
• wp_commentmeta
• wp_term_relationships
• wp_postmeta
• wp_posts
• wp_term_taxonomy
• wp_usermeta
• wp_terms
• wp_comments

series

Cpanel Open

DAtabase Chk:

file manager

doamin Find -- go

wp-config.php

Edit

databasename

copy

BAckup of Wp-content

FIle manager

doamin Find

Click

Wp-content

Right Click

COompress

Zip

Wp-content

Right CLick

Download

Database backup

Phpmyadmin

click

DAtabase Chk

click on database

export

custom chk

drop table unchked check

Go

Database Donwload

how to change reset Through phpMyAdmin

Through phpMyAdmin

This article is for those who have phpMyAdmin access to their database. Note: use phpMyAdmin at your own risk. If you doubt your ability to use it, seek further advice. WordPress is not responsible for loss of data.

Begin by logging into phpMyAdmin and clicking databases.

Image #2

• A list of databases will appear. Click your WordPress database.

Image #3

• All the tables in your database will appear. If not, click Structure.
• Look for wp_users in the Table column.
• Click on the icon for browse.
• Locate your Username under user_login
• Click edit (may look like a pencil icon in some versions of phpMyAdmin)

Image #4

• Your user_id will be shown, click on Edit
• Next to the user_pass is a long list of numbers and letters.
• Select and delete these and type in your new password.
• Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
• In this example, the new password will be 'rabbitseatcarrots'
• Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.

Image #5

• Check that your password is actually correct, and that MD5 is in the box.

• Click the 'Go' button to the bottom right.
• Test the new password on the login screen. If it doesn't work, check that you've followed these instructions exactly.

 

PHP Warning: POST Content-Length of 53160843 bytes exceeds the limit of 33554432 bytes in Unknown on line 0

Error establishing a database connection in local server?

problem is having multiple WordPress installation in one database.

You must install WordPress manually in order for this to work. Most one click programs like Fantastic would not let you choose the prefix.

During the installation in your config.php phase, you want to change the prefix “wp_” in order to allow multiple installation. So it can be wpchris_ and the next one can be wpben_ you can use different prefix and use them to create as many installation as you need.

how to host site

Visual Composer: Page Builder for WordPress

Visual Composer is a fantastic plugin developed by WP Bakery that adds a drag & drop page builder to your WordPress theme.
need to be able to create complex page layouts without needing to touch a single line of code.
How Visual Composer Works, And What It Can Do
Just add a new page and you will see new buttons so that you can toggle between classic mode and builder mode as well as a button to take you to the live front-end editor.

the builder also supports four awesome third party plugins: Layer Slider, Revolution Slider, Gravity Forms and Contact Form 7.



Rows
Page Elements

Drag & Drop
Row Options: Format, Clone & Delete Rows
Frontend Editor
Extensions
 read CodeCanyonr:   http://www.wpexplorer.com/out/codecanyon
Visual Composer Settings Options

WordPress Visual Composer Features

Intuitive Drag and Drop Interface
Easily Extendable
Frontend Editor
Backend Editor
Object Oriented Code
Multilingual Ready
Template System
Responsive Design
User Role Manager
Custom Post Types Support
Lifetime Update – Free of Charge
Professional Dedicated Support
Design Options
Shortcode Mapper
Multi-language Support
SEO Friendly
Woo Commerce Support
Advanced Grid Builder
Full Width and Height Rows
Parallax Background for Rows
Image Filters
Video Background
Element Presets
Column Height, Gaps and Position
Advanced Custom Fields Support
Icon Sets and Social Icons
Hide Content

How to Eliminate Render Blocking CSS in Above-the-Fold Content in WordPress

How to fix - Site Loading Speed Test

In order to resolve this problem you are advised to:

• Minimize HTTP requests
• Use Gzip compression
• Use HTTP caching
• Move all CSS style rules into a single, external and minified CSS file
• Minify all JS files and, if possible, try combining them into a single external JS file
• Include external CSS files before external JS files
• Place your JS scripts at the bottom of your page
• Optimize images
• Reduce redirects
• Reduce the number of plug-ins

Plugin contact 7 intalled

plugin error

Installing Plugin from uploaded file: countdownpro13.rar

Unpacking the package…

The package could not be installed. PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature

Fatal error

Fatal error: Allowed memory size of 12345678 bytes exhausted (tried to allocate 2345678 bytes) in /home/your-username/public_html/wp-includes/plugin.php on line 1000

The uploaded file exceeds the upload_max_filesize directive in php.ini.

1. Locate the php.ini file inside the wp-admin directory (if you can’t find this file see notes below)
2. Find this line in the php.ini file “upload_max_filesize = 2M” and replace it with a higher value (e.g. “upload_max_filesize = 64M”)
3. You may also want to increase your max post size. Look for this line in your php.ini file “post_max_size” and increase it as well.
4. Save the changes to the file inside your wp-admin directory.
5. Try the upload again
6. If you still have issues, look for this file in your root directory and make the same changes

I have Sort out that problem.

The uploaded file exceeds the upload_max_filesize directive in php.ini.

WordPress Features

WordPress is a powerful semantic publishing platform,
. We are proud to offer you a freely distributed, standards-compliant, fast, light, and free content management system, with sensible default settings and features, and an extremely customizable core.

At a Glance

Proven 

WordPress powers nearly a quarter of new sites today, is the content management system (CMS) of choice for more than two thirds of the top million sites 

Easy to use 

At the core of WordPress is a simple interface similar to the desktop publishing software you use today. With no coding experience or expert knowledge necessary, 

Built for Publishing 

WordPress makes sharing content and attracting readers to your site a breeze. 

WordPress is not simply a website, but rather a content-publishing platform. With a single click, you have a powerful megaphone to broadcast your message to the world.

Backed by Community Support 

WordPress is supported by a vibrant community of users who have already solved many of the toughest challenges to sharing information today. 

With a library of more than 20,000 free, open-source plug-ins and themes growing each day, and hundreds of core contributors each release cycle, the WordPress community is an ecosystem built around the platform’s viability and proven success.

Multisite 

WordPress can be extended to MultiSite feature on demand base. You are able to develop and maintain multiple sites using single WordPress installation. Multisite is a feature of WordPress 3.0 and later versions that allows multiple virtual sites to share a single WordPress installation. When the multisite feature is activated, the original WordPress site can be converted to support a networkof sites