phpMyAdmin Operation Flow _php Foundation

phpMyAdmin is used to remotely connect to the MySQL database client software, users can refer to the following steps
To configure phpMyAdmin software at a glance:

Please download the Phpmyadmin.rar file to your local;

Use WinRAR to extract the file and generate a phpmyadmin directory;

Ask the customer to use software such as Notepad on the local host to edit the file config.inc.php (add customer database link information) in the phpMyAdmin directory, and modify the following settings:
$cfgServers [1][' host '] = ' localhost '; (System default host name is ' localhost
No modification required)
$cfgServers [1][' user '] = ' database administrator name ';
$cfgServers [1][' password '] = ' password ';
$cfgServers [1][' only_db '] = ' database (database administrator name _db) ';
After the modification is completed, save the config.inc.php file;

After the configuration file is modified, all files under the phpMyAdmin directory and its directory will be uploaded to the customer via FTP
The directory of the Web site; (It's best to change your name slightly so that others can change your data in a dozen.)

Type ' http://your domain/phpmyadmin ' in the browser to manage and create MySQL for customers
Database.

Using phpMyAdmin to manage MySQL databases
1, after you create your database (or service provider to your database name), click to select, and then press "Manage this database", will enter the database Web management interface,
Can create table, manage content, etc.;


2, double-click your database, the data table in the database will be displayed, and in the right half of the screen will display the operation of each datasheet:
3, can be based on the right half of the prompts for each table to operate;

Browse: You can display all the records in a datasheet;
Selection: is based on the conditions of the data table to display records, where you can enter a certain query conditions, the system according to the query you entered the conditions,
Display the corresponding record;
Insert: is to add a record;
Properties: You can change the properties of each field in the datasheet, you can increase the index and other operations;
Discard: Delete this data table, note that after deletion can not be restored, do not easily delete operations;
Empty: Means to delete all records in a datasheet

Run the SQL statement in the database specified below:

refers to entering standard SQL statements that can be manipulated according to your SQL statement, or you can select your local SQL statement file, and then click
Click on the "Start" button to operate;


4, look at the structure of the database and summary information in the four kinds of choices
1 Select structure only: refers to the structure of the data table, which does not contain data, is displayed on the screen
2 structure and data: refers to the structure and data content of the data table,
3) Send: is only the content of the system output to a file.


5, the establishment of a new data table:
Name: Refers to the name of the newly created datasheet
Field: Refers to the number of fields that the newly created datasheet contains

Click the "Start" button, enter the new interface, enter the name and type of each field, after the input and click "Save" after the system will
Automatically return to the previous layer of interface;

6, discard the database: refers to the deletion of the database, please do not arbitrarily operate to avoid problems;


7, above we tell about the operation of the database, we have a database in the operation of a datasheet to tell the role of Phpadmin;


8, double-click a data table in the database, the right half of the screen will display the structure of the data table;


9, the page shows the properties of this datasheet, in the operation of the column are:
1) Change: means to change the name of this field
2) Discard: means to delete this field
3) Key Name: refers to whether to change this field as the primary key
4) Index: refers to the data records that will be indexed according to this field
5 Unique: The contents of this field are unique in the datasheet, there is no duplicate record;


10, browsing: Refers to the display of records; Select: Refers to the input query conditions, according to your query criteria query records; Insert: Add a record;


11. Reading data from a text file: refers to importing a local text file into this datasheet, and the format of the text file you can be a space
or a semicolon, etc;


12, view the structure of the data table information: The data table can be structured or structured data records, etc. sent to the screen or a standard file, square
Then you do data backup;


13, change the data table name: is to change this datasheet to a new data table name;


14, copy data table: refers to the establishment of a data table with the same data table.

About VBB Forum data backup and recovery issues!!!
I use the time, the original will not, so encountered and years more problems, now I finally will, write a note out, to share my experience!
1, you will use Myphpadmin, he is a very good tool, the general space support MySQL has to you installed, so you can directly use, his installation and use can refer to here:
http://www.im286.com/showthread.php?s=&threadid=46001

We can get together and see.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
VBB is a very good php+mysql forum, the laggards forum since its inception has been the use of VBB. But for most users, MySQL backup is a hassle, because most space vendors do not provide remote access to the database, and because of the PHP program's 30-second operating limit, Making a slightly larger MySQL library backup becomes a very troublesome issue. Fish is now on the laggards forum data Backup experience, with phpMyAdmin as an example to tell the MySQL data backup.

The following fish are based on the Ztsky VBB 2.20 and phpMyAdmin 2.26 version of the story
Ztsky VBB can be downloaded to http://www.chinavbb.com
phpMyAdmin can be downloaded by http://sourceforge.net/project/show...elease_id=85832

VBB 2.29 A total of access, Adminlog, Adminutil, announcement, attachment, Avatar, BBCode, calendar_events, Customavatar, forum, F Orumpermission, Icon, moderator, poll, Pollvote, Post, Privatemessage, Profilefield, replacement, ReplacementSet, search , Searchindex, session, setting, Settinggroup, Smilie, style, Subscribeforum, subscribethread, template, Templateset, THR EAD, threadrate, User, useractivation, Userfield, UserGroup, usertitle, Word 43 tables.

Which is relatively important
Post and thread tables, for saving forum posts
Poll and Pollvote tables, for saving the voting part of the forum--not normally backed up
Privatemessage table, used to hold whispers between users---generally do not back up
All tables at the beginning of user to save information about registered users of the forum-----A couple of them.
Fourm is to save the Forum classification, without him, your classification is not complete, so also to back up together.


When you back up, you just have to keep some of the important ones up.
Below, we will restore the forum data.

Go into the myphpadmin and restore the data from the backup above,

Note: You have a few tables in the restored data, then you must first delete the existing table, discard, you will not be wrong, such as you put a few user data together in a zip file, then restore to put those several deleted together, so good!

The above is my own in the management of the time summed up the experience, good words please support more!! Please also give comments and suggestions!

Backup forum Data There is another way is to directly back down in the background, but also the same!!!