...
| No Format |
|---|
mysql -u root -h <newHostName> -B -e "SELECT USER()" |
It should return something like:
| No Format |
|---|
USER() root@192.168.1.1 |
Now that you can access the MySQL server on the new supervisor from the MySQL server on the old supervisor, it's time to push the dump across from the old supervisor to the new one.
On the old supervisor:
You need to build a list of all the *qube databases. The simplest way is to 'cd' into the mysql data directory and list them with "ls"
...
| No Format |
|---|
mysqldump --opt --databases `\ls -d *qube` qube pfx_dw pfx_stats` | mysql -u root -h <linux ip address> |
...
| No Format |
|---|
SHOW DATABASES LIKE '%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 old supervisor, you'll need to do a bit of maintenance on the new tables on the new supervisor.
On the new supervisor
| No Format |
|---|
mysqladmin -u root flush-privileges |
...
Once that's done, you should start the supervisor service.
Verify that the jobs are present:
| No Format |
|---|
qbjobs -u all |
Verify that you can see the logs for a random job:
...