We will tend to use binary backups (Xtrabackup) for full consistent dataset
restore (think slave provisioning and disaster recovery) and logical
backups to perform single table restores in the event that a rollback may
need to occur if someone drops a table or carries out an insane update. We
will
Hello,
If you use any *NOT InnoDB* storage engine, you're right.
mysqldump with --single-transaction doesn't have any consistent as you say.
If you use InnoDB all databases and tables, your dumping process is
protected by transaction isolation level REPEATABLE-READ.
So, in case of * NOT Innodb * storage engine, say MyISAM, will this dump be
of any useful?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Consultant and Database Security
Specialist
On Tue, Oct 7, 2014 at 11:55 AM, yoku ts. yoku0...@gmail.com wrote:
Hello,
If you use
Maybe no, as you knew.
It means that after lock is released, dump is made while the read and
write
activity is going on. This dump then, would be inconsistent.
Not only binary logs, each tables in your dump is based the time when
mysqldump began to dump *each* tables.
It means, for example,
Hello Geetanjali,
On 9/23/2014 7:14 AM, geetanjali mehra wrote:
Can anybody please mention the internals that works when we use mysqldump
as follows:
*mysqldump --single-transaction --all-databases backup_sunday_1_PM.sql*
MySQL manual says:
This backup operation acquires a global read lock
It seems to me that once the read lock is acquired, only the binary log
coordinates are read. Soon after binary log coordinates are read, lock is
released. Is there anything else that happens here?
It means that after lock is released, dump is made while the read and write
activity is going on.
Do not try to dump or reload information_schema. It is derived meta
information, not real tables.
-Original Message-
From: Rafał Radecki [mailto:radecki.ra...@gmail.com]
Sent: Monday, February 04, 2013 12:17 AM
To: mysql@lists.mysql.com
Subject: Mysqldump routines dump, problem
On Tue, 20 Nov 2012, Ricardo Barbosa wrote:
Hi all.
I'm trying to do a recover on a table for a client, with the following message
root@falcon:~# mysqldump -u root -pXXX database
-- MySQL dump 10.13 Distrib 5.1.30, for pc-linux-gnu (i686)
--
-- Host: localhost Database: database
--
mysqldump --databases test --tables ananda test.dmp
mysql show create table ananda\G;
*** 1. row ***
Table: ananda
Create Table: CREATE TABLE `ananda` (
`id` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT
I have mysql 5.5.
I am able to use mysqldump to export data with quotes and the dump had
escape character as seen below
LOCK TABLES `ananda` WRITE;
/*!4 ALTER TABLE `ananda` DISABLE KEYS */;
INSERT INTO `ananda` VALUES
Are you using an abnormal CHARACTER SET or COLLATION?
SHOW CREATE TABLE
Show us the args to mysqldump.
-Original Message-
From: James W. McNeely [mailto:j...@newcenturydata.com]
Sent: Friday, June 15, 2012 10:19 AM
To: mysql@lists.mysql.com
Subject: mysqldump not escaping single
@lists.mysql.com
Subject: Re: mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error, we need to check whether the table is present or not
and the engine type specifically.
Thanks
Suresh Kuna
On Sat, Sep 24, 2011 at 3:31
Someone seems to have deleted that file, which contains the description of the
corresponding table. Recreate the exact same table (EXACT, including keys,
indices, datatypes, encoding, the lot) and copy that tables's .frm file to
replace the lost one. Then pray to the elder gods and restart your
In the last episode (Sep 23), Shafi AHMED said:
I have a mysql database of 200G size and the backup fails due to the foll.
Issue.
mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Can someone assist pls.?
$ perror 24
OS
correct. mysqldump by default has --lock-tables enabled, which means it
tries to lock all tables to be dumped before starting the dump. And doing
LOCK TABLES t1, t2, ... for really big number of tables will inevitably
exhaust all available file descriptors, as LOCK needs all tables to be
opened.
Hi Daniel,
you can use a workaround from the shell,
cd /path/to/your/database (e.g.: cd /var/lib/mysql/mydb)
ls -al *table** | awk '{print $8}' | awk -F. '{print --ignore-table=*mydb
*.$1}' | xargs mysqldump -u*root* -p*toor* *--your-flags **mydb*
It's not that beautiful but it should work.
Check the manual? Its here under ignore-table
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Quoting Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
I am researching about different parameters provided by the
*mysqldump* utility.
It provides a method to dump databases with all
you can use --ignore-table option for this,
mysqldump -u -p dbname --ignore-table=dbname.tablename xyz.sql
you can use this option multiple times to ignore multiple tables.
Rgds,
Jay
On Tue, Jan 18, 2011 at 6:18 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
I am
In the last episode (Jan 12), Feighen Oosterbroek said:
I know that this is a bit of a vague question, but over a period of days
mysqldump will take on one day 2min to complete and on the following day
25min to complete, with the resulting sql file being maybe 200M bigger.
The dataset isn't
Appreciate any help on this.
Any alternative of mysqldump is also fine with me to take backup while
restricting root login access from localhost only.
Thanks in advance.
Regards,
Tanmay
On Wed, Oct 20, 2010 at 10:14 AM, Tanmay Pradhan tanma...@gmail.com wrote:
Yes, r...@localhost entry is
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Krishna
CGI.COM
On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan tanma...@gmail.com wrote:
Hi,
I am using the following version of
Of course you know you did not delete r...@localhost, just root @ '%'
which generally should not matter to mysqldump.
What I suspect is the issue here is that the database you are trying
to dump contains procedures/methods that were defined by a user while
logged in as root@'%'. If you recreate
Hellpo Krishna,
On 10/19/2010 8:40 AM, Krishna Chandra Prajapati wrote:
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Not true. The utility mysqldump is just a client like any
Yes, r...@localhost entry is still present in user table. Only
root@'%' is deleted. So it's not obvious to fail.
Hi yu.zou,
The r...@localhost entry already had all privileges, except this entry
had empty password column.
u...@localhost entry before GRANT
Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote:
use another user and dump the data ,eg the root .
mysqldump -uroot -p --al-databases
: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysqldump error 1064 for database Use command
Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote:
use another
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same
No it does not. But when I dump database name mydb it does. but not
the database with name 1.
--
Regards,
Manasi Save
On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote:
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql
Dear Nitin,
I have newly installed mysql on this server.
mysql Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same command on Fedora-with same mysql
Hi,
Have you recently upgraded your MySQL installation? 1064 in earlier days used
to
mean use of reserved word. Few clients have reported this error in last couple
of months after they upgraded from 5.1.41 to higher versions. As of now, I
don't
have a solution other than changing the name
redirect your standard errors to some log file..
mysqldump --all-databases --flush-logs --master-data=2
/bk01/all_databases_`date +%a`.sql 2 /tmp/test.log
i follow the above syntax for logging the errors in my script.
Thanks
Anand
On Fri, May 28, 2010 at 5:44 PM, Angelina Paul
I looking for a way to corrupt a mysql database forcefully for testing
purpose
and then the mysqldump utility will fail for taking backup against it.
On Fri, May 28, 2010 at 8:06 AM, Anand.S anand@gmail.com wrote:
redirect your standard errors to some log file..
mysqldump --all-databases
In infinite wisdom Angelina Paul arshup...@gmail.com wrote:
[1 text/plain; ISO-8859-1 (7bit)]
I looking for a way to corrupt a mysql database forcefully for testing
purpose
and then the mysqldump utility will fail for taking backup against it.
kill -9 MYSQLD_PID while the backup is running
-Original Message-
From: Raj Shekhar [mailto:rajl...@rajshekhar.net]
Sent: Friday, May 28, 2010 2:40 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: Re: mysqldump backup
In infinite wisdom Angelina Paul arshup...@gmail.com wrote:
[1 text/plain; ISO-8859-1 (7bit)]
I
On 3/4/10 7:21 PM, peng yao xwei...@gmail.com wrote:
hello erveryone, I have a question about mysqldump.I have some blob data,
someone tell me mysqldump the data must use hex-blob options, why?
mysqldump just creates a file containing insert statements that when
executed rebuild your
Wang Zi Feng wrote:
Hi everyone,
Here is a rookie question.
The problem what I found is that mysqldump and phpmyadmin generate different
size of backup file against same database.
I try to dump same database with the 2 different methods, the original
database is 2.8mb, phpmyadmin export 1.5mb
hi there, thanks for your reply.
the mysql server is running on windows xp sp3, every time I use root user to
log in.
the command line i use for mysqldump is
mysqldump --user=root --password=pass testtest.sql
phpmyadmin is with following checked
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION /
mysqldump is by no means the fastest way to move data between systems.
For a bulk job of this magnitude, try this:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
- michael dykman
On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni claudio.na...@gmail.com wrote:
We dumped a mysql 4.1.22
If you look at the options for mysqldump more closely, you will see
that you can specify the version of the server which will be importing
the result file. These cause MySQL to taylor the SQL syntax according
to the target platform.
- michael dykman
On Wed, Sep 2, 2009 at 11:03 AM, Matt
Hi Matt,
The error you are getting is very particular to information_schema
database.
Information_schema does NOT actually have tables, they are views:
|INFORMATION_SCHEMA| is the information database, the place that stores
information about all the other databases that the MySQL server
ok, i see
now the resultings files are owned by mysql.
every file has the same user granted, but the wrong one since
i can not chown user.group * as normal user.
So far i see it is the same problem as with select into outfile
Is there a fancy trick for mysqldump so i will create the
you also can do this:#sudo -u mysql mysqldump command
or
#su - mysql -c mysqldump command
2009/7/24 walter harms wha...@bfs.de
muhammad subair schrieb:
On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
Hi list,
i use mysqldump --tab to create database dumps. this
muhammad subair schrieb:
On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and
sql files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
is
#mysqldump -u username -p -h mysqld_host databasename database_name.sql
username is the mysqld server login name
mysqld_host is the mysqld server address or hostname
databasename is the database which you should dump
You can use man mysqldump or mysqldump --help to get more infomation
2009/7/21
# chown mysql.mysql datafile
2009/7/23 walter harms wha...@bfs.de
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and
sql files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
is there any way to change that
we need more information,
such as your client and server version, the command that exactly your input
etc.
2009/7/14 JingTian jingtian.seu...@gmail.com
hi all,
i use mysqldump to backup my database,
the command line is; mysqldump -p -u -h database_name database_name.sql
i find in the
MySQL dump calls LOCK TABLES before dumping the data (presumably to
prevent data modification halfway through the process).
LOCK TABLES has its own privilege (conveniently given the same name)
which your user account will have to be given in order to run a
mysqldump.
On Fri, 2009-05-01 at 15:49
try something like:
mysqldump -u(user) -p (db-name) `ls z*` (filename)
2009/4/19 ChoiSaehoon saeho...@hotmail.com
Is there a way to dump only specific tables starting with a certain
character?
For example, I only want to dump tables starting with the character 'z'.
The following
I tried it, then it gives the following error message
mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*'
doesn't exist)
What does 'ls' mean? (as in linux command 'ls'?)
:)
Date: Sun, 19 Apr 2009 08:53:36 -0500
Subject: Re: mysqldump syntax - dumping only
the ` sign, not the '
Uwe
:)
Date: Sun, 19 Apr 2009 08:53:36 -0500
Subject: Re: mysqldump syntax - dumping only specific tables starting with a
certain character. (e.g. z*)
From: jlyons4...@gmail.com
To: saeho...@hotmail.com
CC: mysql@lists.mysql.com
try something like:
mysqldump -u
done wrongly this time. :)
Date: Sun, 19 Apr 2009 16:29:48 +0200
From: m...@kiewel-online.ch
To: saeho...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: mysqldump syntax - dumping only specific tables starting with a
certain character. (e.g. z*)
-BEGIN PGP SIGNED MESSAGE
...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: mysqldump syntax - dumping only specific tables starting
with a certain character. (e.g. z*)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ChoiSaehoon schrieb:
I tried it, then it gives the following error message
mysqldump: Can't get CREATE
actually, that was stupid of me - you need a list of tables not files.
I think the only to do this, and the way we do it, is to run some command
like:
mysql -eshow tables in db-name like 'z%' tabnames
Note the use of double-quotes and single-quotes.
then use a loop to read the file tabnames and
I wanted to respond with what I found:
APPARMOR blocks mysql from writing to any other directory than the data
dir and /tmp.
I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the
following:
/backups/mysql** rwk,
to the bottom.
Hope this helps someone.
Ray
--
MySQL General
Hi,
MySQL v4.1.22 on Linux 2.6.18-6-686
I have a dump file generate with mysqldump created by a version 4.1.10 server.
I want to import the dump file into a different server. When I run
mysqldump --database mydb --debug mydumpfile.sql
I get the following:
-- MySQL dump 10.9
--
--
Hi,
On Thu, Apr 2, 2009 at 1:18 PM, Virgilio Quilario
virgilio.quila...@gmail.com wrote:
Hi,
MySQL v4.1.22 on Linux 2.6.18-6-686
I have a dump file generate with mysqldump created by a version 4.1.10
server.
I want to import the dump file into a different server. When I run
mysqldump
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote:
Hi,
Did u try using this command
mysqldump --opt db_name db_name.sql -p 2bkp.err
Not quite. Firstly, I had to alter the normal backup cron job, and that
doesn't happen until late at night.
Secondly, yes I added the redirection to
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or specify it as an option on the command line mysqldump --opt ...
--max_allowed_packet=1G
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
andrew.b.gar...@gmail.com wrote:
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or
On Tue, Jan 13, 2009 at 6:06 PM, Dan d...@entropy.homelinux.org wrote:
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
andrew.b.gar...@gmail.com wrote:
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
Hi,
please increase your interactive_timeout variable to some big number and
also try to log the erros if any thing by using the command:
mysqldump --opt db_name db_name.sql -p 2bkp.err
check if you get some thing in the bkp.err file.
Regards,
Chandru,
www.mafiree.com
On Mon, Jan 12, 2009
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru chandru@gmail.com wrote:
Hi,
please increase your interactive_timeout variable to some big number and
also try to log the erros if any thing by using the command:
mysqldump --opt db_name db_name.sql -p 2bkp.err
check if you get some
I'm also having a similar issue with some tables I've been trying to dump
(total data set is around 3TB). I'm dumping directly from one host to
another (mysqldump -hSOURCE DATABASE | mysql -hLOCALHOST DATABASE) using
mysql 4.1.22. One system is Solaris 10 SPARC, while the other is Solaris 10
x64
Hi Nanu,
According to me
You could use
1. --result-file=file, -r file
2. file (complete path or present working directory would be the place
where your file would be saved)
Since you are not mentioning the output to be in any different format apart
from SQL, it would be a sql file. You can
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
Show the details of your hardware us.
On Thu, Oct 2, 2008 at 3:02 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi,
Just try the below command on console. It will give that the error is
exactly related to what.
$perror 5
What is total ram in your box.
On Thu, Oct 2, 2008 at
Hi,
Just try the below command on console. It will give that the error is
exactly related to what.
$perror 5
What is total ram in your box.
On Thu, Oct 2, 2008 at 12:26 PM, Uma Bhat [EMAIL PROTECTED] wrote:
Hey Guys!
I have been googling a lot on this error and read various suggestions.
Whatever you name it
Wherever you place it
Mysqldump (options) filename
--Original Message--
From: Nanu Kalmanovitz
Sender:
To: mysql@lists.mysql.com
Sent: Aug 22, 2008 23:48
Subject: mysqldump questions
Hi!
What is the name dumped file and where it is created?
System is :Novell
Thanks!
Nanu
[EMAIL PROTECTED] 23/08/2008 09:50:13
Whatever you name it
Wherever you place it
Mysqldump (options) filename
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
@lists.mysql.com
Subject: Re: mysqldump
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
-- --
-- Server version 4.0.18-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE
In the last episode (Jul 26), John Nietzsche said:
i am in need to migrate a database between two mysql server. The
server source is running mysql 4.0.18-log, the destination server is
running mysql 5.0.51a-log.
I dumped the database (in the server source) using mysqldump utility.
The
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
-- --
-- Server version 4.0.18-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: mysqldump
CC: mysql@lists.mysql.com
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
In the last episode (Jul 02), Martin Gainty said:
How do I get mysqldump to turn off quotes e.g from
INSERT INTO table
to
INSERT INTO table
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)
, 2008 12:20 PM
Subject: Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from
:* Moon's Father [EMAIL PROTECTED]
*To:* [EMAIL PROTECTED]
*Cc:* mysql@lists.mysql.com
*Sent:* Saturday, June 21, 2008 12:20 PM
*Subject:* Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All
If you create all your databases and tables with utf8,then every thing is
fine.
On Mon, Apr 28, 2008 at 1:43 AM, Velen [EMAIL PROTECTED] wrote:
Hi,
I'm storing some ascii codes in a table. When I do a dump using mysqldump
from the server and then restoring it on another station, the ascii
Thanks. That sounds pretty labor intensive, since I'd have to do the copy
for each table. That makes the process much harder to automate. And I'm not
sure the end result would be what I wanted anyway. I would like to be able
to do this without copying data around. Does anybody have another
You can import your data into a test database,then export the data using
statement select ... into ...
then You can complare the two.
On Tue, May 20, 2008 at 9:14 AM, Dan Lipsitt [EMAIL PROTECTED] wrote:
Is there a set of flags for mysqldump that will include the auto_increment
specifier for
On Tue, Apr 15, 2008 at 3:11 PM, minky arora [EMAIL PROTECTED] wrote:
Hi Gurus,
I am a newbie.Please bear with me.
Could someone pls guide me as to the best way of adding excel files as
tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
LOAD DATA [LOCAL]
Am Dienstag, den 15.04.2008, 15:11 -0400 schrieb minky arora:
Could someone pls guide me as to the best way of adding excel files as
tables to Mysql ?
You can import CSV files into MySQL:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
Norbert
--
MySQL General Mailing List
For
use can say mysqldump --help, it would give you all the options.
To speedup the dump, you can use -e -q and --single-transaction,
regards
anandkl
On 4/16/08, minky arora [EMAIL PROTECTED] wrote:
Thanks.
I will successful in executing LOAD DATA INFILE
Now i need to do a SqlDump as well to
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to dump all the columns of a table but one in a
restructuring of my schema. I found this post:
http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html
which seems to indicate that this isn't
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one in a
restructuring of my schema.
By dump, I assume you mean output, not delete.
I suspect I'm too inexperienced in MySQL
Thanks for the responses, Inline:
On Sun, Mar 9, 2008 at 7:49 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one
MySQL does provide LOAD DATA INFILE
(http://dev.mysql.com/doc/refman/5.0/en/load-data.html), but I was
hoping to do it through mysqldump instead of SELECT INTO because I
assumed the performance was faster. If that's not the case, though,
I'll go ahead and use SELECT INTO OUTFILE and
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
PROTECTED] /]#
Thanks,
Mike
Jed Reynolds [EMAIL PROTECTED]
02/22/08 07:04 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql list mysql@lists.mysql.com
Subject
Re: mysqldump: Got error: 1: Can't create/write to file
'dumpdir/tablename.txt' (Errcode: 13
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subject
Re: mysqldump: Got error: 1: Can't create/write to file
'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
Mike Spreitzer wrote:
Sorry if I have confused people by presenting
evidence in the wrong order. Also, it seems that the .sql file is
written by the client while the .txt file is (attempted to be) written
by the server. Here is a single typescript with all the evidence:
[EMAIL PROTECTED]
Maybe too much data is being pumped in through the pipe
This sounds spot on. I redid the command to take the pipe out of the
equation and it seems to be working now. Thanks for the feedback.
Rolando Edwards-3 wrote:
'errno 32 on write'
That's a broken pipe error (Run 'perror 32' in
'errno 32 on write'
That's a broken pipe error (Run 'perror 32' in Linux)
Maybe too much data is being pumped in through the pipe.
Instead of this :
/usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c
/backups/mysql_backup.gz
Try it this way :
/usr/bin/mysqldump --all-databases -u
Hi,
On Dec 4, 2007 2:58 PM, Rolando Edwards [EMAIL PROTECTED] wrote:
'errno 32 on write'
That's a broken pipe error (Run 'perror 32' in Linux)
Maybe too much data is being pumped in through the pipe.
Instead of this :
/usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c
Unfortunately the additional parameters didn't solve my problem. But
thanks for your response!
ssh [EMAIL PROTECTED] \
mysqldump -u XYZ --verbose --password=XYZ --quick
--single-transaction --net_buffer_length=1G --max_allowed_packet=1G
dbmail | /bin/gzip \
I see one conflict that could be causing your lost connection message -
you are specifying a 1 GB max_allowed_packet for the client, but the
server is configured to only support 64 MB.
You should adjust the max_allowed_packet = 64M setting on the server to
match or exceed what you specify on the
Hello,
thanks. I just wonder why this isn't actually documented in the --help
output of mysqldump.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 576 matches
Mail list logo