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 m
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
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 t
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 o
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
Ty
d 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
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 from remote hosts. since i couldn't find any
documentation on this, i assume that mysqldump will use all the
available bandwidth of t
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 o
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
"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
(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
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
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
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
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 -ur
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
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 th
>
> 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
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,
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
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
[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
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
SQLLoade
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
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
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 u
host or password (preferrably both!)
On Wed, 10 Jan 2001, Web Master wrote:
> Hello,
>
> can any one help me with my following mysqldump question.
>
> I want to dump a complete database from one server to another server. I am
> trying the following comment
>
> mysql
Hello,
can any one help me with my following mysqldump question.
I want to dump a complete database from one server to another server. I am
trying the following comment
mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase
when I tried, the remote host is failing with invalid log
29 matches
Mail list logo
