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
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
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.
> >
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
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
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
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 +
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
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
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
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
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
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
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
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
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
> [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
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
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
> 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
> 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
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
Hello.
>Has anyone else had similar problems? Can anyone shed some light on how
>to successfully back up this database?
Have a look here:
http://dev.mysql.com/doc/mysql/en/gone-away.html
>Hello
>
>I am using mysqldump to backup my entire database (about 40GB total)
>each night.
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
: 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
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
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]>
"Gustafson, Tim" <[EMAIL PROTECTED]> wrote on 08/29/2005 09:24:36 AM:
> Hello
>
> I am using mysqldump to backup my entire database (about 40GB total)
> each night. I dump each table separetly, so that if mysqldump crashes
> in the middle somewhere, the rest of the database still gets backed up.
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
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]>
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
and upgrade to the latest stable release.
Michael Ragsdale <[EMAIL PROTECTED]> 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:
>
> mys
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 variables, I get local-i
At 10:12 +1100 3/22/04, tait sanders wrote:
thanks - i ran the command below and it worked. and now I'm trying
to import using:
'mysql -u root -p mtweblog < Bckupmtweblog.sql' on CLI on different
machine and am getting "Error 1 at line 11: Can't create/write to
file'./mtweblog/mt_author.frm' Er
thanks - i ran the command below and it worked. and now I'm trying to
import using:
'mysql -u root -p mtweblog < Bckupmtweblog.sql' on CLI on different
machine and am getting "Error 1 at line 11: Can't create/write to
file'./mtweblog/mt_author.frm' Errorcode 13".
any suggestions here?
tait
O
ump -uuser -ppassword --no-data mtweblog > mtweblog.ddl
mysql -uuser -ppassword < mtweblog.ddl
mysql -uuser -ppassword < bkupmtweblog.sql
-Original Message-
From: tait sanders [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 5:13 PM
To: [EMAIL PROTECTED]
Cc: mysql
Sub
First, mysqldump is a command in and of itself so it does NOT execute from
within the mysql command line tool. Next, expand your command entry a bit
to include your userid and password, for example:
mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql
-Original Mes
`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 (
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
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
- 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
of
> options and carefully studied sever
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
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:
." <[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
from table" > /tmp/lista.log
> ERROR 2013 at line 1: Lost connection to MySQL 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
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
Dear Carlos,
> Got error: 2013: Lost connection to MySQL server
> during query
> when retrieving data from server
In your my.cnf / my.ini configuration file, set the value for the
communication buffer high (maximum is 16 MB):
[mysqldump]
set-variable = max_allowed_packet=16M
Restart the server,
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
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
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
Hi,
Error 13 is permissions. Your server has to have permission to write to the
directory, and over-write any existing file of the same name.
Regards
Quentin
-Original Message-
From: Joel Caturia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 10:07 a.m.
To: [EMAIL PROTECTED]
> "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
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
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
53 matches
Mail list logo
