command line...

[cwfie]

Hi,

I tried what this thread says - http://www.directadmin.com/forum/showthread.php?s=&threadid=7375&highlight=command+line+sql

I have to move a 80 MB user database to another server, but it doesn't work.

- I uploaded the .sql database to my root/admin public_html directory
- I tried command line to restore the database of another user..

It says... no such file or directory..

Can anybody help me? Where do I have to put the .sql file?

mysql - u username -p database < filename.sql ... do I need to give up the path to the database?

Thanks!!

 

[Icheb]

What is the output of 'whereis mysql' ?
I guess your mysql client binary is missing or outside the searchpath.
If you think your .sql is nonexistant, you can check it by using "ls -al" in the directory where it should be.

Oh btw, the space between - and u should not be there.
(Don't forget you have to add a user and db first in DA, common mistake )

 

[cwfie]

filename.sql, I changed it to the complete path... but the only problem now is -> 'bigger than max_allowed_packet'. Do I need to change that setting? And where can I do that ?

 

[cwfie]

changed my.cnf, working again ! Thanks for the help!