Import sql file

Hello,

I have a sql file on my server.

I want to import it daily into a mysql database... (and erase the old data)

It seems quite easy... but I just can't do it!

I tried using this cron job :

/usr/bin/mysql -hlocalhost -uusername -ppassword /home/user/public_html/test.sql

But it just won't work.

Thanks in advance if you can help me a bit.

Alex

Take a look at the manual for "mysqldump" and "load data infile"

Try to change the command to:

/usr/bin/mysql -hlocalhost -uusername -ppassword < /home/user/public_html/test.sql

The < is very important in this case.

Thomas

Thanks! It worked...