| |||||||||||
Location of SQL files for submittion through... Posted by mr_yogi (mr_yogi), 6 June 2007 MYSQL command Line client?Hi, I am accessing a Linux server remotely with the following CMD line from a Win32 machine: ->MYSQL -h<ip> -u<username> -p<password> I can create, drop, modify tables and databases fine. However I want to be able to use the "source" command on a .SQL file which is located on the Linux Server, is this possible? I know I can use "source" when connected to localhost and the .SQL file is located on a local drive. Any help appreciated. Cheers Kristin Posted by admin (Graham Ellis), 6 June 2007 "Source" is not an SQL command but rather a facility of the mysql (command line) program on the client, so it's not "naturally" going to work with a file of commands on the server. I've had a quick look at the "MySQL cookbook" and not come up with any direct solution, but you could always FTP the file to your local hostThis page is a thread posted to the opentalk forum
at www.opentalk.org.uk and
archived here for reference. To jump to the archive index please
follow this link.
|
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho |