Re: mysqldump question

2006-04-17 Thread Frank
Randy Paries wrote: > Hello, > I have just created a new fedora 4 box with the latest mysqldump > mysqldump Ver 10.9 > > something has changed. > > Before all my tables entries had their own insert statements for each > row. Now each table has one insert with all the values appended to the > en

Re: mysqldump question

2005-05-13 Thread Eric Bergen
Is there a reason you can't run mysqldump on the server? You could then gzip it and use any transport method with throttling you want (like wget) -Eric Aaron Wohl wrote: http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do what you want... I havent tried it yet, but noted the URL

Re: mysqldump question

2005-05-13 Thread Aaron Wohl
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do what you want... I havent tried it yet, but noted the URL for the next time I needed that functionality. - Original message - From: "Amit M Bhosle" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Date: Fri, 13 May 2005 09

Re: mysqldump question

2004-07-26 Thread Paul DuBois
At 20:58 -0600 7/21/04, Jim McAtee wrote: (Apologies in advance for the crossposting, but I asked the same questions on the MySQL Windows list and didn't get any replies) I need a simple backup mechanism for MySQL (3.2x) that will backup all databases on a server. Something that can be run from a

Re: mysqldump question

2004-07-26 Thread Egor Egorov
"Jim McAtee" <[EMAIL PROTECTED]> wrote: > Can I easily restore individual databases and/or individual tables from a > backup made with mysqldump? Yes if you will individually dump the tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponso

RE: mysqldump question

2002-07-24 Thread Diana Soares
rsion history online > anywhere? Check this: http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x It shows some release dates. > -Original Message- > From: Diana Soares [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 3:22 AM > To: Bill

Re: RE: mysqldump question

2002-07-24 Thread Egor Egorov
Bill, Tuesday, July 23, 2002, 11:04:27 PM, you wrote: BB> Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is BB> old, but I can't find out how old, is there a version history online BB> anywhere? Check MySQL manual: http://www.mysql.com/doc/index.html -- For techn

RE: mysqldump question

2002-07-23 Thread Bill Bernat
IL PROTECTED]] Sent: Tuesday, July 16, 2002 3:22 AM To: Bill Bernat Cc: [EMAIL PROTECTED] Subject: Re: mysqldump question On Tue, 2002-07-16 at 02:31, Bill Bernat wrote: > Question: is there anything I need to be aware of when writing dump > files to a local directory for my user, I'm

Re: mysqldump question

2002-07-16 Thread Diana Soares
On Tue, 2002-07-16 at 02:31, Bill Bernat wrote: > Question: is there anything I need to be aware of when writing dump > files to a local directory for my user, I'm having the following > problem. > > 1. I create a directory in my own home directory (linux, red hat 7.2) > ~/dumps and give it 777

Re: mysqldump question

2001-11-27 Thread Benjamin Pflugmann
Hi. On Mon, Nov 26, 2001 at 05:39:57PM +0300, [EMAIL PROTECTED] wrote: [...] > diff database_dump/Mtable.txt `mysqldump > --databases MYdatabase --tables MYtable` > ... > and make a conclusions depending of diff output. > > But according to well known SQL standarts the order of stored records i

RE: mysqldump question (very basic)

2001-09-11 Thread Jay Fesco
> > Hi. > > I'm trying to run a mysqldump. I enter mysqldump > -databases in order to backup all the databases. For > some reason all I'm getting back is a help on the > mysqldump. What am I doing wrong? > > thanks > > = > It returns help whenever it doesn't understand what you're asking it

Re: mysqldump question (very basic)

2001-09-10 Thread Paul DuBois
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote: >Hi. > >I'm trying to run a mysqldump. I enter mysqldump >-databases in order to backup all the databases. For >some reason all I'm getting back is a help on the >mysqldump. What am I doing wrong? If you're really entering the option as -databases,

Re: mysqldump question

2001-06-10 Thread pmetha
o: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, June 10, 2001 5:27 PM Subject: Re: mysqldump question > [EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: > > > Is there a way that I can make mysqldump output a row in a single line ? > > The line is fairly long, an

Re: mysqldump question

2001-06-10 Thread Ed Carp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: > Is there a way that I can make mysqldump output a row in a single line ? > The line is fairly long, and wraps to something like 20 lines or so, > due to one column that is a clob. Total there are 67K records. I thought the default was to not wrap

Re: mysqldump question

2001-03-07 Thread Geoff Coffey
on 3/7/01 6:39 PM, Cindy at [EMAIL PROTECTED] wrote: > How would I copy ONE table from a database over to another? > > I used this last time: > > mysqldump -h mysql.io.com -u DB1 -p --opt DB1 > ! backup-file.sql > mysql -h mysql.io.com -u DB2 -p DB2 < backup-file.sql > > But it copies the who

RE: mysqldump question

2001-03-07 Thread Quentin Bennett
Hi, Just add your table name to the mysqldump command Quentin -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 March 2001 2:40 p.m. To: [EMAIL PROTECTED] Subject: mysqldump question How would I copy ONE table from a database over to another? I used this la

Re: mysqldump question!

2001-01-10 Thread Atle Veka
try adding a -u (--user=) and -p, this will tell the mysql server what user you are connecting as and it will prompt you for a password. It could be many other things though, depending on how you have set up your access tables. It's usually a bad idea to not restrict connections by either host o