Reputation
774
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 13
Impact
~36k people reached

May
6
awarded  Notable Question
Mar
5
awarded  Popular Question
Feb
19
awarded  Nice Answer
Sep
30
awarded  Explainer
Jul
24
awarded  Yearling
Feb
28
comment Repair table field: Import/append records from specific backup field if they are not null
@square_eyes Without your database I can't even begin to tell you what such a query would look like. you would have to be able to uniquely identify each row in which data was lost (ideally by a primary key), extract the lost (presumably NULL) columns from your temp database, and UPDATE your main database with the missing data. The SELECT/UPDATE bit could be done with a short program in your favorite language (possibly even within MySQL itself, that's not my choice of database so I can't help there), but the identifying of rows & their missing columns nobody can do but you...
Feb
28
answered Repair table field: Import/append records from specific backup field if they are not null
Dec
10
comment Creating a mysql trigger without hard-coding database name
This is the default behavior on most database systems I've encountered: "If the database name / schema namespace is not specified, assume the current one."
Dec
10
answered best practices indexed views computed columns
Dec
10
revised Creating a mysql trigger without hard-coding database name
Improve title
Dec
10
suggested approved edit on Creating a mysql trigger without hard-coding database name
Dec
9
accepted Restoring SQL_ASCII dumps to a UTF8-encoded database
Dec
3
awarded  Popular Question
Jul
24
awarded  Yearling
Jun
8
comment Restoring SQL_ASCII dumps to a UTF8-encoded database
Hmm - this might be workable: I can use make a text dump of just the tables with strings in them & use this to try to determine if there is a consistent encoding. The problem is my database encoding is SQL_ASCII - the encodings of each string are indeterminate (because Postgres performs no encoding conversion when SQL_ASCII is specified, and this DB has been abused by a variety of applications of varying code quality) but I might luck out with the apps all being consistent :)
Jun
7
comment Need a log based replication / CDC solution to publish postgres to oracle subscribers
Is there a particular reason you need to move the data out (as opposed to querying your Postgres server from the other databases)? You could theoretically do CDC with triggers, or write something to process archived WAL segments, but both of those strike me as particularly nasty solutions...
Jun
7
comment Troubleshooting high CPU usage from postgres and postmaster services?
@asadz no, it was truncated (fixed now) -- If you have specific PIDs and want to see what they're running you can isolate them with a WHERE clause, but if you don't have a huge number of PIDs it's just as easy to search through the full output. The Postgres manual has additional detail on what you can get out of pg_stat_activity, as well as the other statistics-collector tables (which can help you if your problem isn't a user query).
Jun
7
revised Troubleshooting high CPU usage from postgres and postmaster services?
Finish query
Jun
7
asked Restoring SQL_ASCII dumps to a UTF8-encoded database
Jun
7
answered Troubleshooting high CPU usage from postgres and postmaster services?