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
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
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
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
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
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 = ',
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:
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
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
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
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
11 matches
Mail list logo