Use telnet to export and import the Forum mysql database _ MySQL

Use telnet to export and import the Forum mysql database bitsCN.com

Author: November 10 [E.S. T] Source: evil baboons. China

1. The methods described here are mainly applicable to forums such as VB.
TELNET can be used to export the database on the existing server, and then import the data to another server. this method can be used to migrate the Forum on two servers; or, you can move the existing forum on the server to the local machine to add features and install and debug HACK without affecting the operation of the Forum on the server.
I have used this method to migrate all files and databases of my entire website (including forums, news releases, and other personal homepages) to my local machine, and back up files and databases, at the same time, you can test multiple functions and multiple operating systems on the local machine.

2. There are multiple ways to export and import mysql databases, but I failed to use PHPmyadmin. maybe it is because the database is larger than 5 MB. No detailed analysis is performed.

3. Run the telnet program to connect the local machine to the remote machine:

If you are using a windows system: Start --> Run, type telnet and you will see:
Telnet>
This is a telnet prompt. It indicates that the program is running and waits for you to enter a command. To connect to a remote machine, enter open and attach the address and port of the remote machine. For example:

Open XXXX.com 23
Provide user name and password
Login: XXXXXX
Password: XXXXXX

The Web Host server used by my friend is a Unix system. it must be connected using SSH (Secure Shell), and SecureCRT3.3.

4. after connecting to the host, back up the existing database:

Type the command mysqldump-uUSERNAME-pPASSWORD databasename>/your path/dump. SQL
This process takes about 30 seconds, depending on the size of your database.
Then, check whether the/dump. SQL file exists.

5. Transfer the dump. SQL file to the new server or local machine:
It can be transmitted through FTP. Don't go into detail.

6. Copy the VB forum on the new server:

Run the telnet program to connect to the server (remote machine)
Type the command mysql-uUSERNAME-pPASSWORD newdbname </your path/dump. SQL
Then, you can use PHPmyadmin to check the database import status.

Reconfigure the admin/config. php file and upload it to the server.
Run admin/index. php to enter the administrator control panel, --> Forum options, set forum URL, home page URL, and other information, and then "Save changes ".

OK! All done!

BitsCN.com