Home > Article > Backend Development > phpmyadmin operation process_PHP tutorial
phpmyadmin operation process_PHP tutorial
- WBOYOriginal
- 2016-07-21 16:08:484045browse
phpmyadmin is a client software used to remotely connect to a MySQL database. Users can refer to the following
steps to configure the phpmyadmin software:
Please download the phpmyadmin.rar file to your local computer;
Use winrar to decompress the file and generate a phpmyadmin directory;
Please use notepad and other software on the local host to edit the file config.inc.php in the phpmyadmin directory (add customer database link information ), modify the following settings:
$cfgServers[1]['host'] = 'localhost'; (The system default host name is 'localhost
does not need to be modified)
$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 modifying the configuration file, upload the phpmyadmin directory and all the files in the directory to the customer via ftp
Under the directory of the website; (It is best to change the name slightly, so that others can not modify your data casually)
Type 'http://your domain name/phpmyadmin' in the browser. Can manage and create customer's MySQL
database.
Use PHPMYADMIN to manage MYSQL database
1. After you create your database (or the database name given to you by the service provider), click to select it, and then click "Manage this database", you will enter The web management interface of the database,
can create tables, manage content, etc.;
2. Double-click your database, the data table in the database will be displayed, and at the same time, in the right half of the screen The operation section will display the operations of each data table:
3. You can operate each table according to the prompts in the right half;
Browse: All records in the data table can be displayed;
Select : is to display the records in the data table based on conditions. You can enter certain query conditions here. The system will
display the corresponding records according to the query conditions you entered;
insert: is to add a record;
attribute : You can change the attributes of each field in the data table, add indexes and other operations;
Discard: delete this data table. Note that it cannot be restored after deletion, and do not delete it easily;
Clear: means Delete all records in the data table
Run the SQL statement in the database specified below:
refers to entering the standard SQL statement, which can be operated according to your SQL statement; you can also choose your local SQL statement file, and then
click the "Start" button to proceed;
4. There are four options to view the structure and summary information of the database
1) Only Select structure: It does not contain data, it is just the structure of the data table, and it is displayed on the screen
2) Structure and data: It refers to the structure and data content of the data table,
3) Send: It only sends the system The contents are output to a file.
5. Create a new data table:
Name: refers to the name of the newly created data table
Fields: refers to the number of fields contained in the newly created data table
Click the "Start" button to enter the new interface. Enter the name and type of each field. After completing the input, click "Save" and the system will
automatically return to the previous interface;
6. Discard the database: This refers to deleting the database. Please do not operate it at will to avoid problems;
7. Above we talked about the operation of the database, below we will operate on a data in a database Table operations describe the role of PhpAdmin;
8. Double-click a data table in the database, and the structure of the data table will be displayed in the right half of the screen;
9. The page displays the properties of this data table. In the operation column, there are:
1) Change: refers to changing the name of this field
2) Discard: refers to deleting this field
3) Key name : Refers to whether to change this field to the primary key
4) Index: Refers to index data records according to this field
5) Unique: The content of this field is unique in the data table, and there are no duplicate records;
10. Browse: refers to displaying records; selection: refers to entering query conditions and querying records according to your query conditions; insert: adding a record;
11. Reading data from a text file: refers to importing a local text file into this data table. Regarding the format of the text file, you can use spaces
or semicolon, etc.;
12 . Check the structure information of the data table: you can send the structure or structural data record of the data table to the screen or a standard file to
facilitate your data backup;
13 . Change the name of the data table: It means to change this data table to a new data table name;
14. Copy the data table: It means to create a data table that is the same as this data table.
About the backup and recovery issues of vbb forum data! ! !
When I used it myself, I didn’t know how to do it, so I encountered many problems for many years. Now I finally know how to do it. I will write an explanation and share my experience with you!
1. You need to be able to use Myphpadmin. It is a very good tool. Most spaces that support mysql are installed for you, so you can use it directly. For its installation and use, please refer here:
http://www.im286.com/showthread.php?s=&threadid=46001
You can also check it out at Juba.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
VBB is a very excellent PHP+MYSQL forum. The Laggard Forum has been using VBB since its establishment. But for most users, MYSQL backup is a troublesome problem because most space providers do not provide permissions for remote connection to the database. At the same time, the PHP program takes 30 seconds to run. Limitation, making the backup of a slightly larger MYSQL database a very troublesome problem. Based on the data backup experience of the Laggard Forum, Yuxian uses PHPMYADMIN as an example to describe the backup of MYSQL data.
The following contents are all Based on ztsky Chinese VBB 2.20 and phpmyadmin 2.26 version
ztsky Chinese VBB can be downloaded from http://www.chinavbb.com
phpmyadmin can be downloaded from http://sourceforge.net/project/show...elease_id= 85832 Download
VBB 2.29 has a total of access, adminlog, adminutil, announcement, attachment, avatar, bbcode, calendar_events, customavatar, forum, forumermission, icon, moderator, poll, pollvote, post, privatemessage, profilefield, replacement, replacementset, search, searchindex, session, setting, settinggroup, smilie, style, subscribeforum, subscribethread, template, templateset, thread, threadrate, user, useractivation, userfield, usergroup, usertitle, word 43 tables.
Among them Relatively important are the
post and thread tables, used to save forum posts;
poll and pollvote tables, used to save the voting part of the forum - generally not backed up
privatemessage table, used to save messages between users. Whisper ---Generally, all tables starting with
user are not backed up. They are used to save information related to registered users of the forum. ------There are several, and they must be downloaded together.
fourm is used to save forum categories. Without him, your classification is incomplete, so you should also back it up together.
When backing up, you just need to save the important ones above.
Next, let’s restore the forum data.
Enter myphpadmin and restore the backed up data above.
Note: If you have several tables in the restored data, you must first delete the existing tables. , discarded, otherwise there will be no mistakes. For example, if you put several user data together in a zip file, then you need to delete those data together when restoring. This is good!
The above is my own experience in management. If it is good, please support me! ! Please also give your comments and suggestions!
Another way to back up forum data is to back it up directly in the background. In fact, it’s the same! ! !