Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-06 Thread agd85
On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman" wrote: > > Excluding 'performance_schema' appears to eliminate the error. And it > > seems does NOT cause a reliability-of-the-backup problem. > > Hah, no, backing that up is utterly pointless. that's a useful/final confirmation. thx. > No,

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-06 Thread Johan De Meersman
- Original Message - > From: ag...@airpost.net > > Excluding 'performance_schema' appears to eliminate the error. And it > seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. Never noticed it doing that. It's basically a virtual schem

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-06 Thread agd85
On Mon, 06 Jun 2011 12:44 +0200, "Johan De Meersman" wrote: > > I haven't bothered to look for the "bug", but it seems to me to be quite > reasonable default behaviour to lock the whole lot when you're dumping > transactional tables - it ensures you dump all tables from the same > consistent vi

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-06 Thread Johan De Meersman
I haven't bothered to look for the "bug", but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view. I would rather take this up with the ZRM people - it should "just

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
Am 05.06.2011 23:55, schrieb ag...@airpost.net: > i still have no idea why this is necessary. take it or not it is a professional solution which works for databses with 20 GB every day here with rsync without interrupt/lock mysqld a second and it is much faster > there seems to be a but, prob

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
i still have no idea why this is necessary. there seems to be a but, problem, misconfiguration, etc. wouldn't it make some sense to try to FIX it, rather than setting up a completely different server? perhaps someone with an idea of the problem and its solution will be able to chime in. -- My

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
Am 05.06.2011 23:49, schrieb ag...@airpost.net: > > On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald" > wrote: >> i would use a replication slave and stop him for consistent backups >> because dumb locks are not really a good solution independent >> if this works "normally" > > unfortunately, i

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald" wrote: > i would use a replication slave and stop him for consistent backups > because dumb locks are not really a good solution independent > if this works "normally" unfortunately, i have no idea what that means. something's apparently broken w

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
On Sun, 05 Jun 2011 23:30 +0200, "Reindl Harald" wrote: > BTW > WHY is everybody ansering to the list AND the author of the last post? > this reults in get every message twice :-( Reply -> sends to ONLY the From == h.rei...@thelounge.net Reply to all sends to BOTH the From == h.rei...@thelounge.n

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( Am 05.06.2011 23:26, schrieb ag...@airpost.net: > fwiw, others are seeing this. e.g., in addition to the two bugs i'd > already referenced, > > http://www.directadmin.com/forum/s

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
hm - bad i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works "normally" Am 05.06.2011 23:26, schrieb ag...@airpost.net: > fwiw, others are seeing this. e.g., in addition to the two bugs i'd > already refer

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced, http://www.directadmin.com/forum/showthread.php?p=202053 and one http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command claims a solution "Add --skip-add-locks to

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
the grant statements does nobody interest maybe use phpmyadmin for a clearer display mysql> select * from mysql.user where user='root' limit 1; +---+--+---+-+-+-+-+-+---+

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
hi, On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald" wrote: > have you checked you permissions-table if all privileges are active for root i've got, mysql> show grants for 'root'@'localhost'; +--

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread Reindl Harald
have you checked you permissions-table if all privileges are active for root and have you started "ymsql_upgrade" after all updates? Am 05.06.2011 22:20, schrieb ag...@airpost.net: > i use ZRM to do backups of my databases. > > with v5.1.x, this works fine, > > mysql-zrm-scheduler --now --back

upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

2011-06-05 Thread agd85
i use ZRM to do backups of my databases. with v5.1.x, this works fine, mysql-zrm-scheduler --now --backup-set manual --backup-level 0 to execute a manual backup. i recently upgraded from v5.1.x -> v5.5.12, mysqladmin -V mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686 now, at exec

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
: "mysql@lists.mysql.com" Sent: Sat, September 4, 2010 12:06:27 PMSubject: mysqldump error 1064 for database Use commandHi All, I have 10 mysql databases all the tables use MyIsAm mysql storage engine. Database names are 1,2,3,4,...10. When I use mysqldump command with --all-databases opt

Re: mysqldump error 1064 for database Use command

2010-09-04 Thread Nitin Mehta
name (of database in your case). Hope that helps. Regards, Nitin From: Manasi Save To: "mysql@lists.mysql.com" Sent: Sat, September 4, 2010 12:06:27 PM Subject: mysqldump error 1064 for database Use command Hi All,   I have 10 mysql databases all

mysqldump error 1064 for database Use command

2010-09-03 Thread Manasi Save
Hi All,   I have 10 mysql databases all the tables use MyIsAm mysql storage engine.  Database names are 1,2,3,4,...10.   When I use mysqldump command with --all-databases option. This gives me following error:   mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql   ERROR MESSAGE

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 +

MYSQLDUMP ERROR

2009-05-01 Thread Krishna Chandra Prajapati
Hi lists, I have given select privileges to database tables. when i am taking mysqldump remotely it's giving error. [prajap...@beta2 prajapati]$ mysqldump --verbose -h 152.20.1.115 -u dip dip states -pdip > state.sql -- Connecting to 152.20.1.115... mysqldump: Got error: 1044: Access denied for u

mysqldump error

2009-03-03 Thread Madonna DeVaudreuil
Just recently a script that backups up

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

mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Daniel Kasak
Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have always done nightly backups with: mysqldump --opt db_name > db_name.sql -p Recently this started failing with: Error 2013: Lost connection to MySQL server I have checked all tables for corruption - nothing found. Also as far as I

Re: mysqldump: Error 5: Out of memory

2008-10-24 Thread Moon's Father
t; > > I get this error while taking mysqldump of an InnoDB table (say > "mytable") > > mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping > > table `mytable` at row: 484911* > > > > > > *current my.cnf settings:* >

Re: mysqldump: Error 5: Out of memory

2008-10-02 Thread Krishna Chandra Prajapati
nd read various suggestions. But > havnt found an appropriate solution yet. > > I get this error while taking mysqldump of an InnoDB table (say "mytable") > mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping > table `mytable` at row: 484911* > > > *cur

mysqldump: Error 5: Out of memory

2008-10-01 Thread Uma Bhat
Hey Guys! I have been googling a lot on this error and read various suggestions. But havnt found an appropriate solution yet. I get this error while taking mysqldump of an InnoDB table (say "mytable") mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping table `mytab

Re: mysqldump error

2006-08-02 Thread Dominik Klein
> [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt > drupal > mysqldump: Got error: 1: Can't create/write to file > '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when > executing 'SELECT INTO OUTFILE' Change the owner of that directory so the mysql serve

Re: mysqldump error

2006-08-02 Thread Dominik Klein
I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Change the owner of that direct

mysqldump error

2006-08-02 Thread Kaushal Shriyan
Hi ALL I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Thanks and Regards Kaush

RE: mysqldump: Error 2013

2005-09-02 Thread Gustafson, Tim
Hello everyone! I just wanted to give everyone an update. I'm still getting this error when I try to back up this database table. I don't get it at the same row each time - today was at row 1,618, yesterday it was at row 24,566. Just a reminder of my symptoms: 1. mysqldump is the only thing rep

RE: mysqldump: Error 2013

2005-08-30 Thread Gustafson, Tim
> Have a look here: > http://dev.mysql.com/doc/mysql/en/gone-away.html Gleb, Thanks for the response. The only one that seems to apply is this one: > You may also see the MySQL server has gone away error if > MySQL is started with the --skip-networking option. I do start mySQL without networki

RE: mysqldump: Error 2013

2005-08-29 Thread Gustafson, Tim
> I believe it's the size of the row, not the size of a > single field, that matters. Is it possible you have a > row which exceeds max_allowed_packet size? No. There is one blob fields (always less than 50MB) and like 10 other fields, all integers. smime.p7s Description: S/MIME cryptographic

Re: mysqldump: Error 2013

2005-08-29 Thread Michael Stassen
Hassan Schroeder wrote: > Does the size of the contents of that field exceed your defined > max_allowed_packet size? > Gustafson, Tim wrote: No, max_allowed_packet is 100 megabytes, and the maximum data field in the database is 50MB right now, and most are well below 10MB. Tim Gustafson MEI Te

Re: mysqldump: Error 2013

2005-08-29 Thread Gleb Paharenko
one table is very >large - it accounts for the other 20GB of the dataset. > >When backing up this table, I get this error message every night: > >/usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server >during query when dumping table `DocumentVariants` at row: 134

Re: mysqldump: Error 2013

2005-08-29 Thread Hassan Schroeder
Gustafson, Tim wrote: No, max_allowed_packet is 100 megabytes, and the maximum data field > in the database is 50MB right now, and most are well below 10MB. mmm. OK, not having any more bright ideas :-) I would try dumping it using an explicit `--where=` claus to guarantee fixed ordering, and s

RE: mysqldump: Error 2013

2005-08-29 Thread Gustafson, Tim
: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:51 AM To: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 Gustafson, Tim wrote: > When backing up this table, I get this error message every night: > > /usr/local/bin/mysqldump: Error 2013: Lost conn

Re: mysqldump: Error 2013

2005-08-29 Thread Hassan Schroeder
Gustafson, Tim wrote: When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `DocumentVariants` at row: 13456 The table actually has 94,916 rows in it. There are no entries in the

RE: mysqldump: Error 2013

2005-08-29 Thread Gustafson, Tim
0001 Office (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:35 AM To: Gustafson, Tim Cc: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 "Gustafson, Tim" <[EMAIL PROTECTED]>

Re: mysqldump: Error 2013

2005-08-29 Thread SGreen
is error message every night: > > /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server > during query when dumping table `DocumentVariants` at row: 13456 > > The table actually has 94,916 rows in it. There are no entries in the > mySQL server log and nothing in /

mysqldump: Error 2013

2005-08-29 Thread Gustafson, Tim
across more than a hundred tables. However, one table is very large - it accounts for the other 20GB of the dataset. When backing up this table, I get this error message every night: /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Re: Mysqldump error 1017: errno: 24 - help?

2005-01-11 Thread Mysql user
Yep, that seems to have done it, at least when I'm testing it. I'm pretty sure the problem is fixed, but the next couple of days of automated backups will tell. Thanks! On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote: > Hello. > > Try '--open-files-limit=8192' at least. Check the real value o

Re: Mysqldump error 1017: errno: 24 - help?

2005-01-11 Thread Gleb Paharenko
Hello. Try '--open-files-limit=8192' at least. Check the real value of open_file_limits with such statement: show variables like '%open_f%'; You can find some recommendations for SuSe Linux at: http://dev.mysql.com/doc/mysql/en/Linux-post-install.html Mysql user <[EMAIL PROTECTED]>

Mysqldump error 1017: errno: 24 - help?

2005-01-10 Thread Mysql user
Hi.. I've got an ISP, and all of our customers have databases in our mysql system. My backup command is: mysqldump --force --opt -A -p' | gzip -c > /var/sqlbackup/mysqldump-`date +\%A`.sql.gz This has worked fine for some time. Now, however, I get an error message: mysqldump: Got

Re: mysqldump error

2004-10-27 Thread Gleb Paharenko
following error: > > mysqldump: ERROR: unknown variable 'local-infile=1' > > I tried using --force and it didn't help. > > Showing the variables, I get local-infile to be TRUE. I looked in my.ini > and found 3 instances of local-infile=1, for [mysqld], [mysql], a

Re: mysqldump error

2004-10-27 Thread Paul DuBois
At 15:47 -0400 10/27/04, Michael Ragsdale wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variabl

mysqldump error

2004-10-27 Thread Michael Ragsdale
Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my

mysqldump: Error 2013

2004-09-29 Thread David Perron
Hello - Since recently switching from MyISAM to InnoDB tables in 4.1 on RH Linux I receive this error when attempting to dump some tables. mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `campaigns` at row: 14721 Any idea what could be causing this

Re: mysqldump error

2004-03-21 Thread Paul DuBois
your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error

Re: mysqldump error

2004-03-21 Thread tait sanders
: mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17

RE: mysqldump error

2004-03-21 Thread DChristensen
id and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie

RE: mysqldump error

2004-03-21 Thread DChristensen
nal Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckU

mysqldump error

2004-03-21 Thread tait sanders
hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog > BckUpmtweblog.sql' from CLI it gives "Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using pa

Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Director General: NEFACOMP
`TableNamesOr FieldNames` - Original Message - From: "Kelley Lingerfelt" <[EMAIL PROTECTED]> To: "Rusty Wright" <[EMAIL PROTECTED]>; "Mysql List" <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 09:10 Subject: Re: mysqldump error (

Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Victoria Reznichenko
Rusty Wright <[EMAIL PROTECTED]> wrote: > I have a user who unfortunately named one of his tables "order". He also > has table names with a dash in them. mysqldump is unable to dump the > "order" table and I'm unable to use the ALTER command on it and the tables > with the dashes in their names t

Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Kelley Lingerfelt
Try putting the name inside of backticks; >From the Manual: 6.1.2 Database, Table, Index, Column, and Alias Names --- Note that if the identifier is a restricted word or contains special characters you must always quote it with a

mysqldump error (mysql 4.0.14)

2003-09-28 Thread Rusty Wright
I have a user who unfortunately named one of his tables "order". He also has table names with a dash in them. mysqldump is unable to dump the "order" table and I'm unable to use the ALTER command on it and the tables with the dashes in their names to rename them. Is there any way to quote the ta

Re: mysqldump ERROR 1064

2003-01-05 Thread Bruce MacDonald
- Original Message - From: "David & Angela Ehmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 11:00 PM Subject: mysqldump ERROR 1064 > Hi > > I am having problems generating the mysqldump file. I have tried a range

Re: mysqldump ERROR 1064

2003-01-04 Thread John Coder
On Sun, 2003-01-05 at 00:00, David & Angela Ehmer wrote: > Hi > > I am having problems generating the mysqldump file. I have tried a range of > options and carefully studied several tutorials I have on using this > command. Each time I get the following errror. > > ERROR 1064 you have an error

mysqldump ERROR 1064

2003-01-04 Thread David & Angela Ehmer
Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db >sql.du

Re: mysqldump error

2002-12-06 Thread Carlos A.
mysql 3.23.49a From: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]> Reply-To: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]> To: "Carlos A." <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: mysqldump error Date:

Re: mysqldump error

2002-12-05 Thread Carlos A.
." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error > thanks for your answer. Now the problem is worst. When I do a sql request > with mysql client and the number of register i

Re: mysqldump error

2002-12-05 Thread Stefan Hinz, iConnect \(Berlin\)
Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error > thanks for your answer. Now the problem is worst. When I do a sql request > with mysql client and the number of register is a litte big, for example 50, > the error appears again: > mysql --debug -e"select *

Re: mysqldump error

2002-12-05 Thread Carlos A.
server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: "Listen Hinz" <[EMAIL PROTECTED]> To: "Carlos A." <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: my

Re: mysqldump error

2002-12-05 Thread Listen Hinz
<[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error > Hello > I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an > error when run mysqldump in order to backup my dbs. The error is followin

mysqldump error

2002-12-05 Thread Carlos A.
Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump w

Re: How to direct mysqldump error to a file?

2002-11-19 Thread Jannie Qu
ot;bash-2.05a$" is PS1 setting. From: Paul DuBois <[EMAIL PROTECTED]> To: "Jannie Qu" <[EMAIL PROTECTED]> Subject: Re: How to direct mysqldump error to a file? Date: Tue, 19 Nov 2002 16:12:53 -0600 At 22:09 + 11/19/02, Jannie Qu wrote: Hi, Paul, Here is more mea

Re: How to direct mysqldump error to a file?

2002-11-19 Thread Paul DuBois
At 20:45 + 11/19/02, Jannie Qu wrote: Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output > /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb > bkp1.sql 2> err.log Ambiguous output

How to direct mysqldump error to a file?

2002-11-19 Thread Jannie Qu
Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output > /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb > bkp1.sql 2> err.log Ambiguous output redirect.

re: mysqldump ERROR

2002-09-26 Thread Egor Egorov
tl, Thursday, September 26, 2002, 3:44:30 PM, you wrote: t> Please help me "mysqldump": t> ON: t> mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 > database.gz t> I have an error : t> mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm' (errno: 24) when u

mysqldump ERROR

2002-09-26 Thread tl
Please help me "mysqldump": ON: >mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 > database.gz I have an error : >mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm' >(errno: 24) when using LOCK TABLES Thanks very much. -

Re: mysqldump Error

2001-03-14 Thread Joel Caturia
iginal Message - From: "Quentin Bennett" <[EMAIL PROTECTED]> To: "'Joel Caturia'" <[EMAIL PROTECTED]>; "Gerald L. Clark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 2:19 PM Subject: RE: my

RE: mysqldump Error

2001-03-14 Thread Quentin Bennett
Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. A

RE: mysqldump Error

2001-03-14 Thread Quentin Bennett
] Subject: mysqldump Error I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The in

Re: mysqldump Error

2001-03-14 Thread Vivek Khera
> "JC" == Joel Caturia <[EMAIL PROTECTED]> writes: JC> I've searched around a bit, and haven't been able to find what an JC> errcode 13 is, so I'm out of ideas. mysql comes with a program called perror. Run "perror 13" and see what it has to say. Also, what are your mysql permissions (from

Re: mysqldump Error

2001-03-14 Thread Joel Caturia
l Message - From: "Gerald L. Clark" <[EMAIL PROTECTED]> To: "Joel Caturia" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error > Joel Caturia wrote: > > > > I'm trying to use mysq

Re: mysqldump Error

2001-03-14 Thread Gerald L. Clark
Joel Caturia wrote: > > I'm trying to use mysqldump to dump a database (obviously). > > Here's the commandline I'm using: > [root@fugu work]# mysqldump --tab=. wonderdesk > > mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: >13) > > The interesting thing, i

mysqldump Error

2001-03-14 Thread Joel Caturia
I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it