1. First, check the current values: SELECT * FROM wp_options WHERE option_name = “siteurl”;  SELECT * FROM wp_options WHERE option_name = “home”; 2. Then modify the values: UPDATE wp_options SET option_value=”http://[new domain name or ip address, without trailing slash]” WHERE option_name = “siteurl”; UPDATE wp_options SET option_value=”http://[new domain name or ip address, without trailing slash]” WHERE option_name […]

First, back up the server (including the database) by creating the image. This way if anything goes wrong, you can always try again. Then use this fast and easy fix: mysqlcheck –repair –all-databases Or, as is the case at Amazon account that I manage: mysqlcheck -u root -p –repair –all-databases Password: the root MySQL password.  If […]

PHP automates inserting data into MySQL table by using INSERT command within PHP code.

Use asterisk character in the SELECT statement like this: SELECT * FROM name_of_table

SELECT field_name, another_field_name FROM table_name

INSERT INTO table_name (column_name1, column_name2, …) VALUES (‘value1’, ‘value2’, …) Important: there should be no comma after the last element within both sets parentheses; single quotes must be used for any string values; order of columns should correspond to the order of values. 

mysql> CREATE TABLE `name_of_table` ( `first_field_name` varchar (100),  `second_field_name` varchar(100), `and_s0_on` );

mysql> CREATE DATABASE nameofdatabase;

MySQL terminal and phpMyAdmin.

Structured Query Language.