Forums / Install & configuration / running upgrade scripts

running upgrade scripts

Author Message

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...

Halvor M

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

Halvor M

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!