A critical vulnerability (CVE-2019-10149) was found in Exim mail server. It allows to execute some code on victim's server with root privileges. This vulnerability affects versions from 4.87 to 4.91. If you are using Exim and haven't ordered managed service, you should urgently upgrade your version of Exim to 4.92.
How to import a .SQL file when a specific user creates a database?
-
lucasbustamante
- Posts: 5
- Joined: Sat Feb 04, 2017 7:35 pm
How to import a .SQL file when a specific user creates a database?
I'm building one of those free trial SaaS, I have managed to create a database programatically with Vesta's API command v-add-database, but now I would like to automatically import a .SQL file into it.
To import the SQL file when a database is created, I'm using a PHP script that read a file and queries line by line, but it's taking an average 90~100 seconds to process the entire default database, which has around 5k lines.
I feel like I could achieve this with a bash script, but I suck at Linux. Can someone give me a sample of such script?
To import the SQL file when a database is created, I'm using a PHP script that read a file and queries line by line, but it's taking an average 90~100 seconds to process the entire default database, which has around 5k lines.
I feel like I could achieve this with a bash script, but I suck at Linux. Can someone give me a sample of such script?