Cpanel does not support importing mysql big data and remote wget data under SSH

Some Cpanels do not support SSH, so how to wget remote data and restore mysql data? This can be achieved using the Cron Jobs feature.

1. Remote wget data

Enter the Cpanel panel and enter Cron Jobs.

The time can be set according to actual conditions. Generally, US time is 13 hours behind China.

In commend: enter

 wget -P /home/bkcrcnao/public_html/tu/ 76.72.xxx.xxx/xxx.sql

Among them, /home/bkcrcnao/public_html/tu/ means to put the file in the directory of the current Cpanel host.
76.72.xxx.xxx/xxx.sql refers to the remote file.

2. Restore MySQL data

Still at Cron Jobs.

In commend: enter

 mysql -ubkcrcnao_root -p123 bkcrcnao_tu < /home/bkcrcnao/public_html/tu/tu.sql

bkcrcnao_root is your database user name, 123 is the database password, and /home/bkcrcnao/public_html/tu/tu.sql is the .sql data storage path.