Telnet program remote data call

Source: Internet
Author: User
Tags telnet program

It is very convenient for Telnet programs. I can remotely manipulate the application of this program. Here we will mainly explain how to use Telnet to export and import the Forum mysql database. The application is summarized as follows:

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; you can also 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 on my entire website including forums, news releases, and other personal homepages to my local machine to 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 you are waiting to enter a command. to connect to a remote machine, enter open and attach the address and port of the remote machine. For example:

OpenXXXX. com23

Provide user name and password

Login: XXXXXX

Password: XXXXXX

The WebHost server used by my friend is a Unix system and is connected using SSHSecureShell. The other is SecureCRT3.3.

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

Type the command mysqldump-uUSERNAME-pPASSWORDdatabasename>/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 via FTP. You don't need to talk about it in detail.

6. Copy the VB forum on the new server:

Run the Telnet program to connect to the remote server)

Type the command mysql-uUSERNAME-pPASSWORDnewdbname </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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.