172 reputation
8
bio website None
location Michigan
age 35
visits member for 3 years, 10 months
seen Dec 12 at 19:25
Trying to figure out this Android stuff...

Nov
5
awarded  Self-Learner
Oct
8
accepted Setting up mail() in PHP for multiple domains
Oct
5
comment Setting up mail() in PHP for multiple domains
Yeah, I've used -f, I'm just hoping there is a way to set a default value that's different for each site. Otherwise we'll have to set the default to something that isn't site specific.
Oct
5
awarded  Commentator
Oct
5
comment Setting up mail() in PHP for multiple domains
Yeah, I know about that... I was just hoping to have a way to make a different default for each domain, and then use the -f to customize it as needed.
Oct
5
accepted Transfering BLOBS on a MSSQL -> MySQL Linked Server
Oct
5
revised Setting up mail() in PHP for multiple domains
am a noob
Oct
5
asked Setting up mail() in PHP for multiple domains
Sep
2
comment Transfering BLOBS on a MSSQL -> MySQL Linked Server
Weird bug. When a MEDIUMTEXT field is the last column, it refuses to set the ID column to anything other than 0 when an insert is started over the linked server. If I change the field order so that any non TEXT field is last (Int, Varchar, whatever) it inserts the ID correctly.
Sep
2
awarded  Editor
Sep
2
revised Transfering BLOBS on a MSSQL -> MySQL Linked Server
added an edit
Sep
1
awarded  Teacher
Sep
1
comment Transfering BLOBS on a MSSQL -> MySQL Linked Server
ODBC 3.51.28 doesn't have an option for Don't Optimize Column Widths. I think you are right about it being an issue with ODBC, but it looks like the other version (5.1.8) might solve the problem.
Sep
1
answered Transfering BLOBS on a MSSQL -> MySQL Linked Server
Sep
1
comment Transfering BLOBS on a MSSQL -> MySQL Linked Server
It might be a duplicate, but I don't think so, and the answer is not useful. The differences are that my MSSQL field is already a Varchar, and actually for testing I'm putting in with an insert statement insert into MYSQL...Test(Name,Details)values('Test','Test!!') Which is not longer than MySQL Varchar(max) length. Also, I can't change the MySQL datatype to Varchar everytime I want to do an insert because it would crop the existing data.
Sep
1
asked Transfering BLOBS on a MSSQL -> MySQL Linked Server
Sep
1
comment Linked server to MSSQL from MySQL
Yeah, this is how we used to do it when we were on MySQL a while back. Our hosting has provided MSSQL for a while, but we're exploring cutting some costs. The down sides are of course the burden of keeping things synchronized without it taking hours each time it needs to update, esp when you are dealing with huge data sets, and with the small differences of datatypes. I had kinda hoped that MySQL had a new option in the last 3 years. The only other possibility would be to do some kind of flat file data transfer, which would get around the linked server BLOB issue.
Aug
31
asked Linked server to MSSQL from MySQL
May
17
accepted Getting data out of a Suspect database
May
17
comment Getting data out of a Suspect database
So the bad news is that when we tried to put it into emergency mode, the database got detached, and we couldn't reattach it. We ended up just restoring from backup, and a good chunk of the missing data had been uploaded to the webserver, so we were able to just reimport it from there. the rest wasn't a huge loss. it would be nice if there was a way to reattach it now with another name, just for future reference, but thankfully the emergency seems to have passed.