phpmyadmin, automating import, sql & export

I use phpmyadmin to import a file that was created with mysqldump. Then I run a few lines of sql on the data, including a li开发者_开发百科ne which creates a view. Then I export the view as a csv.

Can I automate that in any way? I don't see any way to do it, from looking within phpmyadmin or doing a websearch.

Failing that, does phpmyadmin at least have any way to save sql queries?

phpMyAdmin is not really the right tool for automation. You better do that using cron and mysql command line tool.