10 recommended articles about remote machines

When using mysql recently, I often encounter the situation of exporting or importing data. For some simple ones, you can directly use navicate to export the results directly. However, many times, because the machine is on the remote side and is an online machine. In this case, when MySQL cannot be linked to MySQL after a jump, Navigate cannot use this method to export. I searched some articles on the Internet and summarized the import and export of MySQL, as follows: 1. , Export the database mysqldump -h 127.0.0.1 -u name -p dbname >name.sql Export the database dbname of 127.0.0.1 to the name.sql file 2. Export a table of the database mysqldump -h 127.0.0.1 -u username -ppassword 

1. mysql remote machine import and export data lock table does not lock part of the table data or all

Introduction: When using mysql recently, I often encounter the situation of exporting or importing data. For some simple ones, you can directly use navicate to directly export the results, but many times, Since the machine is on the remote side and is an online machine, Navigate cannot use this method to export when mysql cannot be connected after a jump. I searched some articles on the Internet and probably converted mysql to A summary of the import and export situation is as follows: 1. Export database mysqldump -h 127.0.0.1

2. PHP solution to obtain files in the specified directory on the remote machine

Introduction: Can PHP obtain files in a specified directory on a remote machine using the fsockopen function to only obtain a fixed file (such as the homepage) on the remote host? I want to get a specified file such as http://ip/dir/filename. What should I do? ------Solution--------------------allow_url_fopen This needs to be turned on. . ----

3. PHP restarts the remote machine

Introduction: PHP restarts the remote machine 1. In The code can be executed normally in the local CMD environment shutdown -r -m \192.168.1.113 -t 0 -f2. The code can be executed in the PHP environment 3

4. PHP solution to obtain the files in the specified directory on the remote machine

Introduction: When PHP obtains files in a specified directory on a remote machine, can the fsockopen function only be used to obtain a fixed file (such as the home page) of the remote host? I want to get a specified file such as http://ip/dir/filename. What should I do? ------Solution--------------------allow_url_fopen This needs to be turned on. . -----

5. Solution to the file_get_contents timeout problem in php

Introduction: file_get_contents timeout me The most well-known reason is that your machine is too slow to access the remote machine, causing the php script to time out, but there are many other reasons. Let me summarize the solutions to the file_get_contents timeout problem.

6. MySQL: Unable to create user ERROR 1045

Introduction: Today, when I was cleaning up the redundant users after installing MySQL, I accidentally deleted root@localhost, and then re-added it. Then I wanted to add users for remote machine connection, and the result was

7. Configuring MySQL remote access under Linux

## Introduction: MySQL cannot be accessed through a remote machine by default. Use the following The configuration can enable remote access. My MySQL environment is Ubuntu 10.04+MySQL 5.1 1. Modify /etc/m

8. [Translated from mos article] From the remote machine When connecting to db on windows, error ora-1217

Introduction: error ora-12170 when connecting to db on windows from a remote machine. Reference original text: Windows: ORA-12170 Attempting to Connect from Remote Client (Doc ID 748461.1) Applicable to: Oracle Net Services

9. Using mysql in Ubuntu 12.04.04 server environment

Introduction: 1. Mysql remote access settings Mysql default It cannot be accessed through a remote machine. You can enable remote access on the MySQL Server through the following configuration: Execute cd /etc/mysql sudo vi my.cnf and change the bind-address to 0.0.0.0. Execute the sudo mysql command to enter mysql. Command mode, mysql use mysql; mysq

10. SQL Server database backup (off-machine)

Introduction: A simple remote remote database backup function. Through this stored procedure, databases on other remote machines can be backed up locally. The main principles are: 1. Execute Windows commands through XP_CMDSHELL to map the shared directory of the local machine to the network drive of the remote machine. 2. Back up the database to a network drive via SQL script. 3. Execute through The command?

The above is the detailed content of 10 recommended articles about remote machines. For more information, please follow other related articles on the PHP Chinese website!