Versions Compared

    Old Version 1

    changes.mady.by.user John Burk

    Saved on

    compared with

    New Version 2

    changes.mady.by.user Unknown User (czerouni)

    Saved on

    Key

    • This line was added.
    • This line was removed.
    • Formatting was changed.

    ...

    (replace the ip address in the command with the ip address of your old server)

    Test the access from the OSX OS X host:

    Code:
    mysql -u root -h <newHostName> -B -e "SELECT USER()"

    ...

    Note
    titleWindows
    1. Windows users must specify a port while running this command. Windows mysqlclient uses port 3300 by default whereas Linux and OSX OS X assumes 3306. To specify a port, add "-P 3306" to the end of the above command
    2. If the old supervisor is running on Windows and you have not installed cygwin (or some other *nix shell utility), you cannot pipe commands to other commands, nor can you do command substitution with backticks. In this instance you'll need to hand-enter the list of qube databases, send the output of mysqldump to a file on the old supervisor, then read that file on the new supervisor. The commands would look something like:
    	old supervisor: mysqldump --opt --databases 1qube 2qube 3qube ... qube > some_file.sql
    	new supervisor: mysql -u root < some_file.sql

    The list of qube databases (1qube 2qube 3qube, etc) can be found by looking in c:\Program Files\pfx\qube\mysql\data for all files that contain the word "qube".

    ...

    You should start to see some qube databases with numbers in front of them, like 12qube. Run the command every minute or so, and the list of databases should be growing.

    Once the mysqldump command has finished on the OSX OS X server, you'll need to do a bit of maintenance on the new tables on the linux server.

    On the linux server:

    ...