well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this hel
try updating the table like this...
update TABLE set COLUMN = replace(COLUMN, >,);
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 3:30 PM
To: MySql
Subject: remove trailing character
I managed to mess up and email storage addresses are in t
I think you mean that you want to import .txt or .csv data into an mysql
table...
http://phpmyadmin.net can do that via a web form to upload plus has many other
good
admin features.
-Original Message-
From: Steve Grosz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 1:56 PM
well,
you can easily output into a comma separated file but the INTO OUTFILE option will not
allow you to retain the headers. You will need to build the logic into a perl script
or language of your choice to get the headers there. Sounds like your fields records
are all on one line becausing yo
i did the update to 10.3.3 (client) yesterday without a hitch. it's probably a good
idea to do a backup anyways.
> --
> From: Scott Haneda
> Sent: Tuesday, March 16, 2004 6:21 PM
> To: MySql
> Subject: OS X 10.3.3 and byte ordering update
>
> I saw a little blip ab
Hello MYSQL Genii,
I am trying to run a query that returns results to a .csv file using mysql's 'INTO
OUTFILE'.
The problem is whenever I write the file I lose my the field names for each
column. For example, when I run the query at command line mysql:
mysql> SELECT distinct count(*), Product FRO