What do you do in the situation where your data has spaces in it?
Since select into outfile space seperates columns, any columns you
have with spaces in the data will not import correctly. Exampl:
mysql> create table t (name varchar(100), address varchar(100));
Query OK, 0 rows affected (0.01 sec)
We have built an alternative save restore process. First we take all of the
.frm files and build
"select * into outfile '/path/tablename.txt' from tablename"
statements. We also dump the structure only and put it in the same
directory. This runs much faster than myysqldump and every t
