My sent folder shows that I sent an email on this topic before I
finished editing it, but so far it hasn't shown up on the list. If it
does, my apologies. Apparently I shouldn't have skipped watching the
company training video on how to use our new email client!
We have a script that uses
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
end.
is there switch that puts it back
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
end.
is
Hello.
Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
mysql version 3.23.45 using mysqldump:
.
loki# mysqldump clasificados /usr/backup/clasificados.sql
You should remove column and table options. Some of
Hi all
Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
mysql version 3.23.45 using mysqldump:
in the source server I executed:
loki# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1955 to server version: 4.1.5-gamma-log
:00 +0530
Subject: mysqldump question
Hi:
i was wondering if there's any way to limit the bandwidth used by
mysqldump to dump data from remote hosts. since i couldn't find any
documentation on this, i assume that mysqldump will use all the
available bandwidth of the network.
the issue
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:18:00 +0530
Subject: mysqldump question
Hi:
i was wondering if there's any way to limit the bandwidth used by
mysqldump to dump data
Hi:
i was wondering if there's any way to limit the bandwidth used by
mysqldump to dump data from remote hosts. since i couldn't find any
documentation on this, i assume that mysqldump will use all the
available bandwidth of the network.
the issue is that i'm looking to fetch data to the tune
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 sponsored
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
(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 scheduled Windows
batch file. From what
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
/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 Bernat
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump question
On Tue, 2002-07-16
: 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 having the following
problem.
1
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
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 permissions
2.
I run /usr/local/mysql/bin/mysqldump
Hi.
On Mon, Nov 26, 2001 at 05:39:57PM +0300, [EMAIL PROTECTED] wrote:
[...]
diff database_dump/Mtable.txt `mysqldump appropriate options
--databases MYdatabase --tables MYtable`
...
and make a conclusions depending of diff output.
But according to well known SQL standarts the order of
Hi.
Suppose I have dumped all database tables using mysqldump with --tab=... option and
I've got some *.sql and *.txt files one per table.
Ok, through the some time I want to see how changed a table living in server compared
with it's old copy I have dumped early.
I've decided to use some of
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 to do
(or
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
=
__
Do You Yahoo!?
Get email alerts NEW
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, try
Hello MySQLers:
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 am trying to output mysqldump and then import into Oracle using
: 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, and wraps to something like 20 lines or so,
due to one column that is a clob. Total
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 whole shebang (all tables in DB1). The situation I
have now is that I
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
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 whole
26 matches
Mail list logo
