No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I'm boring.
- PC Specs
- MacBook Pro
5 Posted Topics
 | 'history' is a bash function built into the shell. If your unix system has bash you should be able to simply run bash and then have access to it. Ksh also implements this.  |
| | You can configure an SSH tunnel using PuTTY or similar such that localhost:5555 maps to your.server.com:3306 via an ssh tunnel. Then just point Visual Studio at localhost:5555 as though there were an actual mysql service listening there. |
| | error 150 reports itself as "Foreign key constraint is incorrectly formed". On first glance the only issue I see is that there is no 'alart_types' table listed (doesn't mean you don't have one but it is referenced by the second foreign key constraint in the table definition). You can try … |
 | admitedly, I've never seen anyone use double-zeros in this field before. Can you try it with single 0's in the time fields? |
 | if by "offline" you simply mean not in active use by the application then I'd recommend replication with simple replication filters for the few databases / tables you want to keep in sync. If not, then a periodic pt-table-sync command should do it as well. This is from the percona-toolkit … |
The End.