2. mysql --user=username --password database < dumpfile.sql
- Mitko Kostov
Thanks for your response. But, i need some elaboration on these. Because,when i tried the your first method above. the code seemed to work partially due to the fact that; after hitting my 'enter' key i was prompt for a password and i supplied the database password and recieved no error message after hitting the 'enter' key again.
However, my point of confusion remains the fact that i could not find any text file like 'mybackup.sql' saved in any directory on the system. Please, why is it so? Because in my understanding i feel it is the 'mybackup.sql' i am supposed to transfer to my production server.