Saving mysql data

My server provider does not have the best backup system in place, so I would like to periodically save all the data from my table and table descriptions. Therefore if I need to reload info after a server crash I can use the LOAD INFILE feature. I do not have FILE priveldges so I can not use the SELECT * INTO OUTFILE method.

Any thoughts on the matter?

Use mysqldump instead.

mysqldump -u user -ppassword dbname > /path/to/your/dir/dump.sql

to restore:

mysql -u user -ppassword dbname < /path/to/your/dir/dump.sql

Note you'll have to 'drop' and 'create' dbname before restoring.