Directory existed but I did not have the right permissions on the
directory for the mysql user. Thanks my friend. :-)
On 5/28/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
John Kopanas wrote:
> I am doing the following:
>
> echo 'SELECT * FROM jobs WHERE id = 1 INTO OUTFILE
> "/Users/jkopa
Hi,
John Kopanas wrote:
I am doing the following:
echo 'SELECT * FROM jobs WHERE id = 1 INTO OUTFILE
"/Users/jkopanas/Sites/test_this_out.csv";' | mysql -uroot
backlog_development
And I get the following error:
ERROR 1 (HY000) at line 1: Can't create/write to file
'/Users/jkopanas/Sites/test_t
Lets not forget about mysqlhotcopy.
-Eric
On Fri, 4 Mar 2005 13:42:48 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> MrExecutive <[EMAIL PROTECTED]> wrote on 03/04/2005 01:12:02 PM:
>
> > Hello Guys,
> >
> > I am a newbie to mySQL and im trying to export my database via the
> > mySQ
MrExecutive <[EMAIL PROTECTED]> wrote on 03/04/2005 01:12:02 PM:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to do this. More articles are telling me to use phpAdmin or som
i'll usually pipe mysqldump into gzip if it's a large database, or gpg
if there's sensitive data in it.
-jacob
On Fri, 4 Mar 2005 12:22:08 -0600, jacob martinson
<[EMAIL PROTECTED]> wrote:
> run:
>
> mysqldump --help
>
>
> On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wr
run:
mysqldump --help
On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to do this. More articles are te
http://www.mysql.com would be a nice place to start.
On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to
Hello Guys,
I am a newbie to mySQL and im trying to export my database via the
mySQL Command line but i cant seem to find any good documentation on how
to do this. More articles are telling me to use phpAdmin or some other
gui tool. I would like to learn the commands anyone has a good doc on
On Mon, 15 Dec 2003, Roberts, Mark (Tulsa) wrote:
> I have an order taking system where the tables are store in a MySql database. I need
> to develop a select statement to output all new orders to a .csv formatted file.
>
> Is this possible to do in MySql. I would try looking this up, however, I
> How would you export your data from the mysql tables to a tab or coma
> delimiter.
There are lots of ways, here are my favorite two:
mysqldump: http://www.mysql.com/doc/en/mysqldump.html
phpMyAdmin : http://phpmyadmin.sourceforge.net/
--
Greg Donald
http://destiney.com/
-
Thanks Jeremy :)
>From: Jeremy Zawodny <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Desmond Lee <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: exporting data
>Date: Fri, 2 Aug 2002 15:59:01 -0700
>
>On Fri, Aug 02, 2002 at 03:55:52PM -
Do you mean like 'mysqldump'? You can use mysqldump to dump tables +/-
data and then upload it to a database later--or 'import' it, e.g.,
mysqldump -u
all the tables from that database.
mysqldump takes a variety of arguments. see 'man mysqldump' for more
info.
-mj
Desmond Lee wrote:
>
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
> Hi guys
>
> I know that you can import data into a table by using 'load data infile' or
> 'mysql' import.
>
> however, is there something that allows you to export the create statemtns
> for the table schema and the data of a data
Hi Dave,
This won't have purely SQL only solution , you can use SELECT .. INTO
OUTFILE .. syntax to create a file and you can zip the file with a random
name and link to that zip file.. This will force the explorer to save the
file. If you just let it stay as a text file, the browser won't downloa
At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote:
>Hello everyone,
>
>I need to export some data from one DB to another.
>
>Suppose I'm connected to DB1 and my trying to get stuff from there
>and insert into DB2. I'm using Insert Select statements. Once I'm
>connected to DB1, do I have t
EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 1:41 PM
To: Demirchyan Oganes-AOD098
Subject: Re: exporting data to a new DB
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words
Hi.
On Mon, Nov 19, 2001 at 11:32:58PM -0600, [EMAIL PROTECTED] wrote:
> Hello,
>
> Sorry about the OT, but I need to export data from various MySQL tables and
> import into Excell spread sheets. Was hoping someone could suggest the best
> format, TAB, CSV..etc delimited, which is the preferred
Cancel this,
I found the problem. Had to grant FILE privileges to this user! total forgot
about that!
TIA,
>>On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia <[EMAIL PROTECTED]> wrote:
>>
You can export using
SELECT fieldlist INTO OUTFILE "filename" FROM table;
This will
"Mike(mickalo)Blezien" wrote:
>
> On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia <[EMAIL PROTECTED]> wrote:
>
> >>You can export using
> >>SELECT fieldlist INTO OUTFILE "filename" FROM table;
> >>
> >>This will create a file with tab separated fields. It is Excel default separator.
> >>Wit
On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia <[EMAIL PROTECTED]> wrote:
>>You can export using
>>SELECT fieldlist INTO OUTFILE "filename" FROM table;
>>
>>This will create a file with tab separated fields. It is Excel default separator.
>>Within Excel, you can open the file, by giving fil
I'm by no means an authority on this kind of stuff but you could write a
portable C program that generates a big ol' SQL script containing INSERT
INTO statements :)
I can't really think of a fast way to do it since you want to go between
MySQL and Access without ODBC and other utilities (I'm not
Consider the Oracle migration work bench.
http://otn.oracle.com/software/tech/migration/workbench/software_index.htm
Joe.O'[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I have a MySql database with customer information which is to be exported
> to an oracle database. I was wondering if someone could tel
Joe.O'[EMAIL PROTECTED] (Joe.O'[EMAIL PROTECTED]) writes:
> I have a MySql database with customer information which is to be exported
> to an oracle database. I was wondering if someone could tell me the easiest
> way of doing this. Is there any such applications which look after the
> exporting
I couldn't find such product on Oracle's website.
Noor
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 5:51 PM
To: Noor Dawod; MySQL List
Subject: RE: Exporting data from MySQL to Oracle
Didn't Oracle just release a
Didn't Oracle just release a MySQL to Oracle migration kit? Check the
Oracle website.
Cal
http://www.calevans.com
-Original Message-
From: Noor Dawod [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:41 AM
To: MySQL List
Subject: Exporting data from MySQL to Oracle
Hello,
Despite the temptation to suggest RTFM ...
mysqldump database table(s)>textfile.txt
~ or ~
mysqldump -uUserID -pPassword database table(s)>textfile.txt
If you type mysqldump|more at the command prompt, the syntax for this
command is fully documented. You will also find the MySQL Manual to be
Hello,
if you want to have a file with just the bare data contents of the table, you simply
do:
mysql> SELECT * FROM table_name INTO OUTFILE '/tmp/lala.txt';
otherwise if you want your data represented in SQL, so that you can reconstruct the
table by importing at a later time (a backup form):
27 matches
Mail list logo
