In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article will explain in detail how to use the telnet method to export and import the forum mysql database, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article.
one. The method introduced here is mainly applicable to VB and so on.
Use the TELNET method to export the database on the existing server, and then import this data into another server, using this method to realize the migration of the forum on the two servers, or move the existing forum on the server to this machine for additional functions and HACK installation and debugging, without affecting the operation of the forum on the server.
I have used this method to move all the files and databases of my entire website (with forums, press releases, and other personal home pages) to this machine, so that I can back up files and databases. At the same time, multi-function and multi-operating system testing can be carried out on this machine.
two. There are many ways to export and import mysql database, but I failed to use PHPmyadmin, perhaps because the database is larger than 5MB. No detailed analysis was carried out.
three. Run the telnet program to connect the local machine to the remote machine:
If you are using the windows system: start (Start)-> run (Run), type telnet, and you will see:
Telnet >
This is the telnet prompt. It indicates that the program is running and is waiting 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 Unix system, which uses SSH (Secure Shell) to connect, and the other one uses SecureCRT3.3.
4. After connecting to the host, back up the existing database:
Type the instruction mysqldump-uUSERNAME-pPASSWORD databasename > / your path / dump.sql
This process takes about 30 seconds, depending on the size of your database.
After that, check if the / dump.sql file exists.
five. Transfer dump.sql files to a new server or local machine:
It can be transmitted by FTP. You don't have to go into details.
six. Copy the VB forums on the new server:
Run the telnet program to connect to the server (remote machine)
Type the instruction mysql-uUSERNAME-pPASSWORD newdbname < / your path / dump.sql
After that, you can use PHPmyadmin to check the database import.
Reconfigure admin/config. File, upload to the server.
Run admin/index.php to enter the administrator control panel,-- > Forum options, make forum settings: forum URL, URL of the home page, etc., and then "Save changes".
On "how to use telnet method to export, import forum mysql database" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.