I'm programming a PHP script to deploy a Wordpress DB in a Windows XAMPP server to an online Ubuntu server.
I was able to create the .sql file and now I need to import that into the Linux server.
I was thinking to use the exec() command... what do you think?
echo exec('C:\xampp\mysql\bin\mysql.exe -h $staging_db_server -u $staging_db_username $staging_db_password $staging_db < tmp.sql');
are there other options?
Thanks a lot