Ok so here is the story.
I have a virtual hosting account w/ Cpanel and SSH/Shell access on.
So here is the question and problem. I have a designer that designed a website and used mysql database with the website...thats fine... now he designed the site on his computer in the office along with the database.
So I get the site uploaded to the server thats fine...then he tells me what the database U/P needs to be and the database name ok..
So go into Cpanel and set that up...not a problem..
Then he emails me several files with the following extenions .frm .MYI .MYD each one of the extenions has the same filename and there are few files like that. Now he tells me he got the files right out of the database program he is using to develop the MySql and says all I have to do is copy them into the folder on the server where the MySql database is stored but having a virtural account I don't have access to that directory.
In the past I emailed the files of the database to the tech host and they put them in the database or imported them what ever they did.
Question is, is there anyway I can do it from my computer or Cpanel. I heard of one way in the shell access with the following command but need a little more explaintion to it.
mysql -u "User" -p "Pass" "Databasename" < "dumpfile"
It looks simple but how or where do I have to have the files for the server to find them if I use a "dumpfile"....in the SSH/Shell its not going to popup a browse option to find the file on my computer...
So any ideas?
wc2
