Do you need to import a big sql on your plesk and don’t know how to do?
It’s simple and very fast.
Connect throw ssh on your server and access to mysql console:
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Then is simple, just select the database and execute our sql file.
We must to upload on the server the .sql file that we want to import, if we can optimize the upload process we can upload a zipped sql so then on the server just execute:
unzip ourfile.sql.zip
Now select the database:
use name_database;
Execute the sql file:
source path_to_file.sql
In a few second the big sql is uploaded!
I am impressed with your work and skill. Thank you so much.
Amazing article. Your tutorial blog site is really helpful for us.