Phpmyadmin, import automation, sql & export

Question

I am using phpmyadmin for a importfile that was created using mysqldump. Then I run a few sql rows for the data, including the row that creates the view. Then I exportkind of like a csv.

Can I automate this in any way? I see no way to do this, from phpmyadmin searches or web searches.

Otherwise, phpmyadmin can at least save SQL queries in some way?

Answer 1

phpMyAdmin is not the most suitable automation tool. You better do this with the cron and mysql command line tool.