I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Don’t. No really. Just don’t. It should be a very rare occasion when this is ever necessary. Assuming your data really is normalized to start with, the right way to solve the problem is to add a new table with a … Read more
the same as you do for any other repetitive task that can be automated – you write a script to do the backup, and then set up a cron job to run it. a script like the following, for instance: (Note: it has to be run as the postgres user, or any other user with … Read more
Sites Most of these are multiple purpose. For instance, articles + forums + blogs. This is by no means exhaustive. It’s a starting point as you’ll find a lot of other blogs and resources from these sites. SQL Server Central SQL Blog SQLServerPedia SQL Skills SQL Team SQL Server Performance IT Knowledge Exchange Books This … Read more
It’s this easy: update my_table set path = replace(path, ‘oldstring’, ‘newstring’)
Read Dynamic Management Views and Functions Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. There are two types of dynamic management views and functions: Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on … Read more
If you want to restrict to host and do not want to specify based on a subnet or wildcard using %, that’s the only way to do it. More details are available in the MySQL documentation. I am still trying to find ways to eliminate overhead when managing authentication to large MySQL installations and have … Read more
If you’ve got access to the mysql database, you can change the grant tables directly: UPDATE mysql.user SET Host=”%” WHERE Host=”localhost” AND User=”username”; …and an analogous UPDATE-statement to change it back. Also you might need to make changes to the mysql.db table as well: UPDATE mysql.db SET Host=”%” WHERE Host=”localhost” AND User=”username”; and then flush … Read more
Do not mess with the mysql db. There is a lot more going on there than just the users table. Your best bet is the “SHOW GRANTS FOR” command. I have a lot of CLI maintenance aliases and functions in my .bashrc (actually my .bash_aliases that I source in my .bashrc). This function: mygrants() { … Read more