For running SQL scripts, you can run the regular mysql command in combination with the program cat.
This is also a method of retrieving backup
made with mysqldump. If so, make sure the tables are not already existing.
cat filename.sql | mysql --binary-mode DATABASE NAME -uUSERNAME -hDATABASE NAME.mysql.domeneshop.no -p
You will be asked for your MySQL password. If you need to automate this, you may consider creating a .my.cnf file with your password. Make sure that the file is readable onlyfor your own Unix user!.
If the file is zipped with gzip:
zcat filename.sql.gz | mysql --binary-mode DATABASE NAME -uUSERNAME -hDATABASE NAME.mysql.domeneshop.no -p
Substitute file name.sql or file name.sql.gz with the file name of your SQL script.
support
+47 2294 3333 (open)
