Forums / Install & configuration / running upgrade scripts
Halvor M
Wednesday 21 December 2005 4:25:45 pm
I seem to be having problems actually running the upgrade scripts. Once I enter the command, I get a lot of text running over my screen (basically the commands for mysql), and the whole process lasts for only a second.
This is what i wrote:D:\www\_site\update\database\mysql\3.5>d:/wamp/mysql/bin/mysql -u <username> -p <password> <databasename> < dbupdate-3.5.1-to-3.5.2.sql
username, password and databasename were all supplied correctly. I suspect there is a very easy fix to this (wrong path or something like that).
Appreciate any input, been losing way to much sleep over this upgrade...
Friday 23 December 2005 1:11:53 am
I've been trying a lot of variations here, but without success.
Seems like my comp is just reciting the file, not actually executing it...
Any ideas out there?
Hans Aikema
Friday 23 December 2005 12:24:53 pm
You might try changing the buffer-size of your CMD prompt:in the CMD window menu (left side of the titlebar) choose properties, on tab 'layout' change the value for the 'height' of the screenbuffer size (e.g. 500), it's the number of lines you can still scroll back in the window.
That way you're at least able to tell what all the replies from mysql are
I did some upgrades myself to get a site from 3.4.1 (or something like that) all the way to 3.7.1 when my hosting provider suddenly decided to upgrade to PHP 4.4. The transition from 3.5.1 to 3.5.2 went smoothly as far as I can recall
you might also enable logging on your mySQL server. See the MySQL website for more info on achieving this:http://dev.mysql.com/doc/refman/4.1/en/log-files.html
Friday 23 December 2005 3:37:50 pm
Thank you so much for your reply - it gave me the "go" to fool around some more.This resulted in the scripts running and my system being operational again :-)
the error was the <database> part, which I deleted and everything was fine. Took 1,5 min to run the various scripts... !!!
Thanks mate!