Use "source <filename>" from the mysql command line Start mysql in the bin directory, switch to the db in use via "use <dbname>" and run the command "source <path_to_file><filename>"
Or read the manual section "3.6 Using mysql in Batch Mode" Cheers > -----Ursprungliche Nachricht----- > Von: Terry Riley [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 2. Juni 2003 11:38 > An: [EMAIL PROTECTED] > Betreff: How to run a script? Newbie alert.. > > > I've not been at this MySQL stuff too long, so bear with me.. > (4.0.13 running on Windows XP/Apache). > > Most of my work has been in Windows, and almost always with a > GUI, so that > when presented with the instruction to 'run mysql_fix_privilege_tables' > script, I am totally clueless as to how to go about it! > > Tried going to a command box, getting to the c:\mysql\bin directory, type > mysql, get mysql fired up, but I can't figure out (and yes, I have read > the (mainly *nix oriented) manual without success) how to get a script in > the \scripts sub-dir to run. Everything I try, in my ignorance, ends with > a 'SQL query error' or similar. > > Help, please, I'm not used to this command-line stuff! > > Terry Riley > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
