Phpmyadmin operation process. Phpmyadmin is a client software used to remotely connect to the MySQL database. you can configure phpmyadmin by following these steps: Download the phpmyadmin.rar file to your local computer; phpmyadmin is the client software used to remotely connect to the MySQL database. you can refer to the following steps:
To configure the phpmyadmin software:
Download the phpmyadmin.rar file to your local computer;
Decompress the file using winrar to generate a phpmyadmin directory;
Ask the customer to use notepad and other software on the local host to edit the config. inc. php file under the phpmyadmin Directory (add the customer database link information) and modify the following settings:
$ Pipeline servers [1] ['host'] = 'localhost'; (the default host name is 'localhost '.
No need to modify)
$ Login servers [1] ['user'] = 'database administrator name ';
$ Login servers [1] ['password'] = 'password ';
$ Pipeline servers [1] ['only _ db'] = 'database (database administrator name _ db )';
After modification, save the config. inc. php file;
After modifying the configuration file, upload all the files in the phpmyadmin directory and its directory to the customer through ftp.
The Directory of the website. (it is best to modify the name slightly, so that no one else can modify your data at will)
In the browser, type 'http: // your domain name/phpmyadmin' to manage and create your MySQL
Database.
Use PHPMYADMIN to manage MYSQL databases
1. after you have created your database (or the database name given to you by the service provider), click Select and then click "Manage this Database, the web management interface of the database is displayed,
You can create tables and manage content;
2. double-click your database. the data table in the database is displayed, and the operation of each data table is displayed in the right half of the screen:
3. you can operate each table based on the prompt in the right half;
Browsing: displays all records in a data table;
Select: displays records in the data table based on the conditions. you can enter certain query conditions here. The system displays the query conditions you have entered,
Display corresponding records;
Insert: Adds a record;
Attribute: you can change the attributes of each field in a data table and add indexes;
Discard: delete the data table. do not delete the data table easily;
Clear: deletes all records in a data table.
Run the SQL statement in the following database:
It refers to the input of standard SQL statements, which can be operated based on your SQL statements; you can also select your local SQL statement file, and then click
Click Start to perform the operation;
4. there are four options for viewing the database structure and summary information
1) select only structure: it refers to the structure of a data table that does not contain data and is displayed on the screen.
2) structure and data: it refers to the structure and data content of a data table,
3) send: only the system content is output to a file.
5. create a new data table:
Name: the name of the newly created data table.
Field: 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, and click save.
Automatically returns to the previous interface;
6. discard the database: delete the database. do not operate it at will to avoid problems;
7. the operations on the database are described above. The following describes the function of PhpAdmin to operate a data table in a database;
8. double-click a data table in the database. The structure of the data table is displayed in the right half of the screen;
9. the properties of the data table are displayed on the page:
1) change: changes the name of this field.
2) discard: This field is deleted.
3) key name: whether to change this field to a primary key
4) index: indicates that data records will be indexed according to this field.
5) unique: the content of this field is unique in the data table and there are no repeated records;
10. browsing: displays records. Select: enter query conditions to query records based on your query conditions. Insert: add a record;
11. read data from text files: import a local text file to this data table. the format of the text file can be a space.
Or semicolon;
12. view the structure information of a data table: you can send the structure or structure data records of a data table to the screen or a standard file.
Back up your data;
13. change the data table name: The new data table name;
14. copy a data table: create a data table that is the same as this data table.
About vbb Forum data backup and recovery !!!
I didn't know it when I used it myself, so I encountered a problem over the past year. now I am able to explain it and share my experiences with you!
1. you need to use Myphpadmin. it is a good tool. generally, all space support mysql has been installed for you, so that you can use it directly, for installation and use, refer to the following:
Http://www.im286.com/showthread.php? S = & threadid = 46001.
You can also go to the meeting to see it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
VBB is an excellent PHP + MYSQL Forum. it has been used since its establishment. however, for most users, MYSQL backup is troublesome, because most space providers do not provide database remote connection permissions, and due to the 30-second running limit of PHP programs, this makes it very troublesome to back up a slightly larger MYSQL database. taking PHPMYADMIN as an example to describe how to back up MYSQL data.
The following content is based on ztsky ing VBB 2.20 and phpmyadmin 2.26
Ztsky Chinese vbb can be downloaded to http://www.chinavbb.com
Phpmyadmin can be downloaded by the http://sourceforge.net/project/show...elease_id=85832
VBB 2.29 has a total of access, adminlog, adminutil, events, attachment, avatar, bbcode, calendar_events, events, forum, forumpermission, icon, moderator, poll, pollvote, post, privatemessage, replacement, replacementset, search, searchindex, session, setting, settinggroup, smilie, style, subscribeforum, subscribethread, template, templateset, thread, threadrate, user, useractivation, userfield, usergroup, usertitle, 43 word tables.
Which of the following is relatively important?
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 private messages between users-generally, it is not backed up.
All tables starting with a user are used to save information about the forum's registered users-several tables must be obtained together.
Fourm saves the category of the Forum. without fourm, your category is incomplete and you need to back up the category together.
During backup, you only need to replace the above several important backups,
Next, we will restore the Forum data.
Log on to myphpadmin and restore the backup data,
Note: If you have several tables in the restored data, you must first delete the existing tables and discard them so that no errors will occur, for example, if you have stored several user data together in a zip file, you need to delete these data together for restoration!
The above is my own experience in management. if you have a good experience, please support it more !! Please also provide comments and suggestions!
Another way to back up Forum data is to back up data directly in the background. The same is true !!!
Configure the phpmyadmin software in Step 1: Download the phpmyadmin.rar file to your local directory...
