For starters you really need to learn how to use the Windows CMD prompt. Most of your errors are caused by the lack of escaping filenames and from not referencing the executables correctly. You can only run "mysql" outside of the mysql/bin folder if the folder has been added to your PATH variable.
It would also be helpful if you copy/pasted the exact commands and output. That said, responses inline... On 2 July 2013 10:21, Wielbert Collinson <wielbert.collin...@hitisem.com>wrote: > I have tried the solution from Bogdan Iosif on the forum to run (*C:\Program > Files (x86)\OTRS\OTRS\scripts>mysql -uroot otrs < "C:\Program* > > *Files (x86)\OTRS\OTRS\scripts\DBUpdate-to-3.2.mysql.sql"*) and I have > received another error message.**** > > ** > Is mysql in the PATH? > Please note that if I run *C:\Program Files (x86)\OTRS\OTRS\scripts> * it > doesn’t open the sql window.**** > > This would seem to indicate it isn't in the PATH. > Example if I run *C:\Program Files (x86)\OTRS\OTRS\scripts>mysql –uroot > otrs. It *prompts with a n error message that it cannot find the MYSQL > file. > Again, not in PATH. > **** > > However, if I run *C:\Program Files (x86)\OTRS\mysql\bin>mysql -uroot > otrs *it opens the MYSQL Window. > Correct, you are in the folder that contains the executable. > **** > > I have tried the command and below is the error message.**** > > ** ** > > *C:\Program Files (x86)\OTRS\mysql\bin>mysql -uroot otrs < "C:\Program > Files (x86)\OTRS\OTRS\scripts\DBUpdate-to-3.2.mysql.sql".ERROR 1091 (42000) > at line 7: Can't DROP 'group_read'; check that column/key exists* > As Bogdan indicated, there is no need to re-run the DBUpdate files between minor versions. That error is normal as that column/key will have been dropped when you upgraded from pre3.2. > I have ran the perl update and it gave me the following error message**** > > ** ** > > *C:\Program Files (x86)\OTRS\mysql\bin>perl DBUpdate-to-3.2.pl Can't open > perl script "DBUpdate-to-3.2.pl": No such file or directory* > The DBUpdate-to-3.2.pl file is not in the mysql/bin directory (unless you copied it there?). Again you need to correctly reference files in the filesystem so the command you would have needed there would be "perl ..\..\OTRS\scripts\DBUpdate-to-3.2.pl" Steve
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
