Re: mysqldump with single-transaction option.

2014-10-08 Thread Andrew Moore
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

Re: mysqldump with single-transaction option.

2014-10-07 Thread yoku ts.
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,

Re: mysqldump with single-transaction option.

2014-10-06 Thread geetanjali mehra
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. wrote: > Hello, > > If you use any *NOT InnoDB*

Re: mysqldump with single-transaction option.

2014-10-06 Thread yoku ts.
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. http://dev.mysql.com/doc/refm

Re: mysqldump with single-transaction option.

2014-10-06 Thread geetanjali mehra
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.

Re: mysqldump with single-transaction option.

2014-10-06 Thread shawn l.green
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

RE: Mysqldump routines dump, problem with lock tables.

2013-02-04 Thread Rick James
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

Re: mysqldump Got error 1034 Incorrect key file for table

2012-11-20 Thread Inigo Medina
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 -- --

Re: mysqldump not escaping single quotes in field data

2012-06-16 Thread Ananda Kumar
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

RE: mysqldump not escaping single quotes in field data

2012-06-15 Thread Rick James
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

Re: mysqldump not escaping single quotes in field data

2012-06-15 Thread Ananda Kumar
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 (1,'ananda'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3

RE: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-25 Thread Shafi AHMED
@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. Rega

Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-24 Thread Suresh Kuna
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

Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-23 Thread Prabhat Kumar
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.

Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-23 Thread Dan Nelson
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

Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

2011-09-23 Thread Johan De Meersman
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

Re: mysqldump --ignore-table

2011-06-08 Thread Claudio Nanni
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

Re: mysqldump except one table

2011-01-18 Thread jayabharath
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 wrote: > Dear all, > > > I am researching about diffe

Re: mysqldump except one table

2011-01-18 Thread a . smith
Check the manual? Its here under ignore-table http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Quoting Adarsh Sharma : Dear all, I am researching about different parameters provided by the *mysqldump* utility. It provides a method to dump databases with all tables. My problem is I w

Re: mySQLdump has a lot of variation for time to complete

2011-01-12 Thread Dan Nelson
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'

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-20 Thread Tanmay Pradhan
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 wrote: > Yes, r...@localhost entry is still present in user

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-19 Thread Tanmay Pradhan
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 +---

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-19 Thread Shawn Green (MySQL)
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 oth

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-19 Thread Michael Dykman
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 t

Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

2010-10-19 Thread Krishna Chandra Prajapati
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 wrote: > Hi, > > I am using the following version of MySQL on my Mac

Re: mysqldump error 1064 for database Use command

2010-09-08 Thread Nitin Mehta
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the dump remotely from a Linux box. Regards, Nitin From: Manasi Save To: win.a Cc: "mysql@lists.mysql.com" Sent: Wed, September 8, 2010 3:57:40 PM Subject: Re: mysql

Re: mysqldump error 1064 for database Use command

2010-09-08 Thread Manasi Save
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 >AllNew_Databa

Re: mysqldump error 1064 for database Use command

2010-09-06 Thread Manasi Save
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. > >

Re: mysqldump error 1064 for database Use command

2010-09-06 Thread Jangita
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

Re: mysqldump error 1064 for database Use command

2010-09-05 Thread Manasi Save
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-wi

Re: mysqldump error 1064 for database Use command

2010-09-04 Thread Nitin Mehta
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 (of

RE: mysqldump backup

2010-05-28 Thread Jerry Schwartz
>-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 wrote: > >> [1 ] >>

Re: mysqldump backup

2010-05-28 Thread Raj Shekhar
In infinite wisdom Angelina Paul wrote: > [1 ] > 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 should give you an indication. -- Raj Shek

Re: mysqldump backup

2010-05-28 Thread 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 wrote: > redirect your standard errors to some log file.. > > mysqldump --all-databases --flush-logs --ma

Re: mysqldump backup

2010-05-28 Thread Anand.S
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 wrote: > Cou

Re: mysqldump "hex-blob" option

2010-03-08 Thread Barry Leslie
On 3/4/10 7:21 PM, "peng yao" 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 tables. As a resul

Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Wang Zi Feng
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 test>test.sql phpmyadmin is with following checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION /

Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Mark Goodge
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

Re: mysqldump Unknown command '\''.

2009-10-14 Thread Michael Dykman
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 wrote: > We dumped a mysql 4.1.22 database using the mysqld

Re: mysqldump warning or actual error?

2009-09-02 Thread Mikhail Berman
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

Re: mysqldump warning or actual error?

2009-09-02 Thread Michael Dykman
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 Neimeye

Re: mysqldump and access rights

2009-07-27 Thread walter harms
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 correspondi

Re: mysqldump and access rights

2009-07-26 Thread peng yao
you also can do this:#sudo -u mysql "mysqldump command" or #su - mysql -c "mysqldump command" 2009/7/24 walter harms > > > muhammad subair schrieb: > > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote: > > > >> Hi list, > >> i use mysqldump --tab to create database dumps. this will prod

Re: mysqldump and access rights

2009-07-24 Thread walter harms
muhammad subair schrieb: > On Thu, Jul 23, 2009 at 10:10 PM, walter harms 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

Re: mysqldump and access rights

2009-07-23 Thread peng yao
# chown mysql.mysql datafile 2009/7/23 walter harms > 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 ? > > r

Re: mysqldump output

2009-07-23 Thread peng yao
#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/

Re: mysqldump output

2009-07-20 Thread zhu dingze
we need more information, such as your client and server version, the command that exactly your input etc. 2009/7/14 JingTian > 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 database_name.sql, ther

Re: MYSQLDUMP ERROR

2009-05-01 Thread Ian Simpson
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 +

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Jim Lyons
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 -e"show 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"

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Uwe Kiewel
>> 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*) >> >> -BEGI

RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread ChoiSaehoon
me. Plz tell me what I've 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

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Uwe Kiewel
s' mean? (as in linux command 'ls'?) you have to use 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.

RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread ChoiSaehoon
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

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Jim Lyons
try something like: mysqldump -u(user) -p (db-name) `ls z*` > (filename) 2009/4/19 ChoiSaehoon > > 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 doesn't work. >

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt'

2009-04-04 Thread Ray Anderson
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

Re: mysqldump failing to load data

2009-04-02 Thread ewen fortune
Hi, On Thu, Apr 2, 2009 at 1:18 PM, Virgilio Quilario 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 --databas

Re: mysqldump failing to load data

2009-04-02 Thread Virgilio Quilario
> 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 1

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Andrew Garner
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote: > On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner > 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

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Dan
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner 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 specify it as an option on

Re: < ? Solved ? > Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-13 Thread Andrew Garner
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 dbna

< ? Solved ? > Re: mysqldump: Error 2 013: Lost connection to MySQL server

2009-01-13 Thread Dan
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 2>>bkp.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 redirecti

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Aaron Blew
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

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Dan
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru 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 2>>bkp.err > > check if you get some thing in the b

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Chandru
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 2>>bkp.err check if you get some thing in the bkp.err file. Regards, Chandru, www.mafiree.com On Mon, Jan 12, 20

Re: MysqlDump destination file

2008-12-19 Thread Amit Sharma
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 na

Re: mysqldump: Got error: 1030

2008-11-20 Thread Moon's Father
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`':

Re: mysqldump: Got error: 1030

2008-11-20 Thread Moon's Father
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`':

Re: mysqldump: Error 5: Out of memory

2008-10-24 Thread Moon's Father
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

Re: mysqldump: Error 5: Out of memory

2008-10-02 Thread Krishna Chandra Prajapati
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 suggestion

בעניין: Re: mysqldump questions

2008-08-23 Thread Nanu Kalmanovitz
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]

Re: mysqldump questions

2008-08-22 Thread chaim . rieger
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 6

RE: mysqldump

2008-07-28 Thread Mary Bahrami
Cc: mysql@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=@

RE: mysqldump

2008-07-26 Thread Martin Gainty
300 > 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

Re: mysqldump

2008-07-26 Thread John Nietzsche
[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 TIME_ZONE='+

Re: mysqldump

2008-07-26 Thread Dan Nelson
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

Re: Mysqldump turn off quotes

2008-07-02 Thread Dan Nelson
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

Re: mysqldump giving errors [SOLVED]

2008-06-21 Thread Moon's Father
> > - Original Message - > *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

Re: mysqldump giving errors [SOLVED]

2008-06-21 Thread cr.vegelin
ne 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, I am running mysqldump with --no-data option, but it gives error: "can't e

Re: mysqldump giving errors

2008-06-21 Thread Moon's Father
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) (2

Re: mysqldump character set

2008-05-24 Thread Moon's Father
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 as

Re: mysqldump and auto_increment

2008-05-20 Thread Dan Lipsitt
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 suggesti

Re: mysqldump and auto_increment

2008-05-19 Thread Moon's Father
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 fo

Re: mysqldump

2008-04-15 Thread Ananda Kumar
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 w

Re: Mysqldump

2008-04-15 Thread Norbert Tretkowski
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 Fo

Re: Mysqldump

2008-04-15 Thread Daniel Brown
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 [

Re: mysqldump on specific columns only?

2008-03-09 Thread Rob Wultsch
> 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

Re: mysqldump on specific columns only?

2008-03-09 Thread Waynn Lue
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 tryin

Re: mysqldump on specific columns only?

2008-03-09 Thread Tim McDaniel
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&q

Re: mysqldump on specific columns only?

2008-03-09 Thread Rob Wultsch
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

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

2008-02-22 Thread Jed Reynolds
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] ~]

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

2008-02-22 Thread Mike Spreitzer
.00$ ls -l total 16 -rw-r--r-- 1 mysql mysql 29 Feb 22 20:46 foo.bar -rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql -bash-3.00$ Thanks, Mike Jed Reynolds <[EMAIL PROTECTED]> 02/22/08 07:24 PM Please respond to [EMAIL PROTECTED] To Mike Spreitzer/Watson/[EMAIL PROTECTED] cc

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

2008-02-22 Thread Jed Reynolds
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]

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

2008-02-22 Thread Mike Spreitzer
19:11 red1_p2.sql [EMAIL 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 Subject Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/ta

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

2008-02-22 Thread Jed Reynolds
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

RE: mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-05 Thread FMGreen
"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' i

Re: mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-04 Thread Baron Schwartz
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 >

RE: mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-04 Thread Rolando Edwards
'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 roo

Re: mysqldump of huge innodb database

2007-09-24 Thread Dan Buettner
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

Re: mysqldump of huge innodb database

2007-09-24 Thread Benjamin Schmidt
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" \ > /Backup/HD-Save/

RE: mysqldump of huge innodb database

2007-09-04 Thread Hartleigh Burton
Hiya, I was backing up a 95GB InnoDB database and forever had problems. It ended up working and I never really worked out exactly what the cause was... but try using the following: --opt (does --quick + extended-insert + others) --net_buffer_length=1G (set this to whatever you want, 1G is the l

  1   2   3   4   5   6   >