Skript pro Telnet

[I am browe]

expect 60 "login:"
output "seno^M"
expect 60 "Password:"
output "notone^M"
# Pripojeni k Mysql
output "mysql -h www.server.cz -u seno -p seno^M"
expect 60 "Password:"
output "chacha^M"
expect 60 "mysql>"

output "LOAD DATA INFILE '/tmp/1.txt' INTO TABLE recept FIELDS TERMINATED BY '\t' ;^M"
output "LOAD DATA INFILE '/tmp/2.txt' INTO TABLE recept FIELDS TERMINATED BY '\t' ;^M"
output "LOAD DATA INFILE '/tmp/3.txt' INTO TABLE recept FIELDS TERMINATED BY '\t' ;^M"
output "LOAD DATA INFILE '/tmp/4.txt' INTO TABLE recept FIELDS TERMINATED BY '\t' ;^M" 


atd… Souboru je asi 80.



------------- další část ---------------


Vitejte na serveru xxx
login: seno
Password:
Last login: Thu May 24 20:58:30 from xxx
mysql -h www.server.cz -u seno -p slama
www:~$ mysql -h www.server.cz -u seno -p slama
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is --- to server version: 3.22.27

Type 'help' for help.

;ysql> LOAD DATA INFILE '/tmp/1.txt' INTO TABLE recept FIELDS TERMINATED BY 't'
Query OK, 1 row affected (0.00 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 3

mysql> select * from recept;
+----+-------------------------------------------+-------------------+---------+
| id | nazev_koreni                              | text_up           | nazev_po|
+----+-------------------------------------------+-------------------+---------+
|  1 | erá dává pokrmům říz i vůni po mexickém s | ylu. Obsahuje mle | ou sladk|
+----+-------------------------------------------+-------------------+---------+
1 row in set (0.00 sec)

mysql> delete from recept;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
www:~$ exit
logout