Importing my sql databse using SSH command

I'm trying to upload a file and import a database to my php admin but SSH is saying no such file or directory.

I'm using the following

The file is in the directory of the specific site should it be somewhere else?

Any help would be awesome!

Thanks,

Brian

 

I doubt that you have the correct path. It should be something along the lines of:

/home/user/public_html/file.sql

You are specifying an absolute path. If you are already in the users home directory, you would use something like this:

public_html/file.sql

As that would be relative to the location you are in.

 

Right now I'm logged in SSH as root!

I uploaded the file I need to import to the root of the websites /public_html/ folder.

When you mentioned /home/user/public_html/file.sql

Should I replace the /user/ with the website database username? Or should it be kept simply /user/

Could it be because the import file isn't named the same as the database I'm trying to import it to?

 

You should replace it with the user name for the website. If you are in ssh, tell me the output of this command:

pwd

 

why dont u use cd command and get into the directory first and then just specify the name

 

That actually sounds like a good idea

I ended up taking the database in 7 sections and imported each section at a time.