cPanel Tutorial 8: Importing Large MySQL Database Files Using Clock Guard Jobs

According to different scripts, when we install the system, the default PHPMYADMIN import MYSQL database has a size limit. Snail has seen 2M or 50M. What should we do if the data we need to import is larger? If we are using a VPS host, we can use the article I shared before "Linux VPS Quickly Import/Backup MYSQL Database Using Commands" article reference to directly use SSH commands to set up import or backup.

If we are using cPanel panel management, we can also use the specific time guard job function in the panel to operate. This is unique to the CP panel. For example, the DA panel does not seem to have this function.

The first step is to FTP the MYSQL file that needs to be uploaded and imported to the root directory of the host. At least you need to know where it is, because you will need to reference it later.

The second step is to find "Clock Guard Job" on the panel.

The third step is to set the execution time.

Fill in the command here on the command line:

mysql -u username -p password [-h database host] database < /home/username/public_html/database.sql

We are quite familiar with this command, and it is also used in VPS SSH backup data and import data. After we add the job, it will operate according to the time we set. We only need to set it up once, so the above operation time needs to be adjusted manually.

To summarize, this is the eighth cPanel panel tutorial. It has basically covered all the basic tutorials on how to build a cPanel website. Generally, we will not use other tutorials. If necessary, you can explore by yourself, and the snail will do it. End the CP tutorial first.

Recommended site search: free cloud hosting, free US hosting, all-purpose virtual hosting, foreign servers, cloud server vps, how to register a website, the latest free proxy ip, domain name price, mainland China php space, registered international domain name