Good call on the WHERE email_address IS NULL thing. Also occurs to me
you could do a SELECT DISTINCT instead of just a SELECT to eliminate
duplicate update commands.
Glad this was useful.
Dan
On 10/14/06, Ferindo Middleton <[EMAIL PROTECTED]> wrote:
Thanks Dan. This does help. This a pretty
That's a little trickier, but definitely possible. I can think of 3
ways to do it, I'm sure there are others.
Approach #1, works if your dumpfile is a manageable size:
- make a copy and work from the copy
- open the copy in a text editor, and find the line where your
database starts. Delete eve
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields in the format -MM-DD even if I formated the f
Thanks Dan. This does help. This a pretty straight-forward idea. I could
even save the results of this query to a text file and possibly review it a
little before running it so I don't acidentally do anything funky and I
could see the impact this would have on the data before applying it. I think
That worked! It's there! Now...how can I rebuild *just* that database (which
was removed from my MySQL server) without affecting the other databases?
TIA,
Ted
- Original Message
From: Dan Buettner <[EMAIL PROTECTED]>
To: Ted Johnson <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Sat
Ferindo, I had a similar task recently, and the problem you'll run
into is that you can't select from and update the same table at once.
What I ended up doing was doing a SELECT to build the update queries
for me.
Something like this:
SELECT CONCAT(
"UPDATE bowler_score SET email_address = '", em
Ted, if you're on a *NIX variant, you could use grep. Something like:
cat DUMPFILE | grep Database: | grep Host:
A dump file I have laying about has a line like this:
-- Host: localhostDatabase: outsell_web_prod
and the command above finds that line. Getting a little fancier with
grep cou
Chris, it's somewhat common for hosting companies to restrict outbound
connections like what you describe. They may have a firewall
preventing what you are trying to do.
From your hosting account, can you telnet to your machine on port 3306 ?
I get something like this:
$ telnet 192.168.2.4 33
107Hi;
Is there a command by which I can read the names of databases in a mysqldump
without expanding the dump into my mysql instance (and thus overwriting
databases already extant)?
TIA,
Ted
Hi Brigitte,
I have tried some REGEXP expressions to get right truncated phrases.
Apparently the following query gives me the right truncated result:
SELECT Description FROM products WHERE Description REGEXP 'olive oil';
This query does include products with "olive oil" and "olive oils",
and excl
I have set up a hosting account on godaddy and they have a ridiculously
old version of mysql so I am trying to set it up to use the my server
instead. But it refuses to connect. I can't figure out what could be
the problem. I have tried connecting to my machine from a few other
servers and t
11 matches
Mail list logo
