running upgrade scripts

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