So, as a followup, I ran mysqldump on the actual server (with the output
directed over AFP to another machine on the network) -- as opposed to running
mysqldump on the destination server and connecting to the databases over TCP/IP
(both are running 5.1.39 PPC 64-bit). *That* dump file imported O
Except that, in my case, both machines are running 5.1.39. Mac "OS X" PPC
64-bit. I tried importing another, different dump file of the same database,
and this time mysql returned a different error:
Sat Nov 21 13:16:20 -- Minas-Tirith :: mysql -u root -p < dump_file.sql
Enter password:
ERROR
There is a bug in mysqldump that prevents mysql from version 5.0.80 from
importing dumps from a old version of mysqldump.
I had this verified by MySQL support.
You can have a look at this bug: http://bugs.mysql.com/bug.php?id=41486
Cheers
Claudio
2009/11/21 René Fournier
> It's just odd, bec
It's just odd, because that error was on 5.0. I'm running 5.1.39 -- surely
enough time for the MySQL devs to fix it right?
Could it be with extended inserts that the max statement length is greater than
the default 16MB max allowed packet? I'm increasing that value to 256 MB and
going to try ag
> From: René Fournier [mailto:m...@renefournier.com]
> Sent: Friday, November 20, 2009 8:31 AM
> To: mysql
> Subject: Strange problem with mysqldump / automysqlbackup (ERROR 1300)
>
> I've been using automysqlbackup 2.5 for years on a particular database, and
> it's
range problem with mysqldump / automysqlbackup (ERROR 1300)
I've been using automysqlbackup 2.5 for years on a particular database, and
it's always performed great. Recently, however, I've become encountering
problems when trying to re-import one of its dumped sql files. (Not sure
I've been using automysqlbackup 2.5 for years on a particular database, and
it's always performed great. Recently, however, I've become encountering
problems when trying to re-import one of its dumped sql files. (Not sure if it
matters, but the database file in question is large and growing -- a
Mark van Herpen <[EMAIL PROTECTED]> writes:
> Hi,
>
> I want to backup my databases with mysqldump, but mysqldump won't run
> because I use the 'local-infile=1' option in the my.cnf file:
>
> [client]
> port= 3306
> socket = /tmp/mysql.sock
> local-infile= 1
>
> This is be
It looks to me that local-infile is a command-line parameter
to mysql client
mysql --local-infile -u user dbname
I've not been able to find this option elsewhere.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Mon, April 16, 2007 12:14, Mark van Herpen wrote:
> Hi,
>
> I want to
Hi,
I want to backup my databases with mysqldump, but mysqldump won't run
because I use the 'local-infile=1' option in the my.cnf file:
[client]
port= 3306
socket = /tmp/mysql.sock
local-infile= 1
This is because I want php and other clients to use local-infile. This
Hi,
Have you tried '\\' ?
Mathias
Selon nyem <[EMAIL PROTECTED]>:
> Hello,
>
> I have a database (on Win2k) with merge table. Mysqldump output includes
> some path information on the merged tables such as DATA DIRECTORY and
> INDEX DIRECTORY
>
> DROP TABLE IF EXISTS `rptpricing1996`;
> CREATE TA
Hello,
I have a database (on Win2k) with merge table. Mysqldump output includes
some path information on the merged tables such as DATA DIRECTORY and
INDEX DIRECTORY
DROP TABLE IF EXISTS `rptpricing1996`;
CREATE TABLE `rptpricing1996` (
`PricingId` int(11) NOT NULL default '0',
`commodity`
-- Original message --
From: Tom Crimmins <[EMAIL PROTECTED]>
>
> $ mysqldump -u root -p govern > test.sql
> Enter password:
> mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
> (errno: 24) when using LOCK TABLES
>
perror says 24 is too m
perror 24
Error code 24: Too many open files
Looks like you've hit a system limit.
Michael
Tom Crimmins wrote:
In mysql version 4.1.7 running on Redhat 3ES I get the following error from
mysql dump.
$ mysqldump -u root -p govern > test.sql
Enter password:
mysqldump: Got error: 1017: Can't find f
In mysql version 4.1.7 running on Redhat 3ES I get the following error from
mysql dump.
$ mysqldump -u root -p govern > test.sql
Enter password:
mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
(errno: 24) when using LOCK TABLES
This file does in fact exist and mysql h
Hello,
I did a mysql dump of a database between two servers we have using the
following command:
mysqldump --opt -u --password= | mysql
--host= -C -u
--password=
This command seemed to run ok as it transferred all the structure and data
from the original server to the new server database.
"neal" <[EMAIL PROTECTED]> wrote:
> I need to backup a mysql 4.1 database with UTF8 characters using InnoDB
> and then restore the backup on another machine
>
> I tried the following (same machine - Windows XP)
> mysqldump.exe -u root stp2 city > d1.sql# backup
> stp2.city
> mysql.e
I need to backup a mysql 4.1 database with UTF8 characters using InnoDB
and then restore the backup on another machine
I tried the following (same machine - Windows XP)
mysqldump.exe -u root stp2 city > d1.sql# backup
stp2.city
mysql.exe -u root t1 < d1.sql
query.
Mikhail.
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 4:32 PM
Subject: Re: problem with mysqldump
> jan,
> Tuesday, August 13, 2002, 12:34:23 PM, you wrote:
>
> jb>
jan,
Tuesday, August 13, 2002, 12:34:23 PM, you wrote:
jb> Hello i got a problem with mysqldump,
jb> i'm forced to dump it to to place the database on a new laptop
jb> mysql -u root -p hardwaredb < hardwaredbbackup.sql
jb> Enter password:
jb> ERROR 1065 at line 25: Qu
Hello i got a problem with mysqldump,
i'm forced to dump it to to place the database on a new laptop
mysql -u root -p hardwaredb < hardwaredbbackup.sql
Enter password:
ERROR 1065 at line 25: Query was empty
and the corresponding line:
) TYPE=MyISAM;
25: /*!4 ALTER TABLE mo
Nick,
Wednesday, April 10, 2002, 7:27:20 PM, you wrote:
NP> I'm using Mysql 4.0.1 with query caching:
NP> set-variable = query_cache_limit=10M
NP> set-variable = query_cache_size=10M
NP> set-variable = query_cache_startup_type=1
N
roduce this reliably maybe we could get a fix! Can you
> do this everytime?
> Ken
>
> - Original Message -
> From: "Nick Pasich" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 10, 2002 12:27 PM
> Subject: Problem with mysqldump when using
pril 10, 2002 12:27 PM
Subject: Problem with mysqldump when using query caching
>
> >Description:
> I'm using Mysql 4.0.1 with query caching:
>
> set-variable = query_cache_limit=10M
> set-variable = query_cache_size=10M
> set-variable = query_cache_startup
t;How-To-Repeat:
Execute a mysqldump command more than once.
>Fix:
>Submitter-Id:
>Originator:Nick Pasich
>Organization:
>MySQL support: email support
>Synopsis: Problem with mysqldump when using query caching
>Severity: serious
>Priority:
tung)
iConnect e-commerce solutions GmbH
www.iConnect.de - www.js-webShop.de
TEL +49 30 46307-382 - FAX -388
---
- Original Message -
From: Agent Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 4:28 AM
Subject: problem with mysqldump
> Hi everybody,
&
Hi,
Agent Smith wrote:
>
> Hi everybody,
>
> I got a problem with the "mysqldump" function.
>
> I connect to mySql trough phpMyAdmin, select the database "xyz", which
> is the only database on the server.
> Then I enter the following string into the text field "Run SQL
> query/queries on datab
Hi everybody,
I got a problem with the "mysqldump" function.
I connect to mySql trough phpMyAdmin, select the database "xyz", which
is the only database on the server.
Then I enter the following string into the text field "Run SQL
query/queries on database xyz:":
mysqldump xyz | mysql --host=XX
To import you should do
cat filename | mysql -uusername -ppassword databasename
ryan
- Original Message -
From: "Rachel-MY" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 9:38 PM
Subject: Problem with mysqldump
Hi everyone,
-3341
- Original Message -
From: "Rachel-MY" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 10:38 PM
Subject: Problem with mysqldump
Hi everyone,
I'm trying to backup all the databases from Server_A to Server_B.
I'd issue "mysq
Hi everyone,
I'm trying to backup all the databases from Server_A to Server_B.
I'd issue "mysqldump" command in server_A to backup every single database, as below :-
> mysqldump -uusername -ppassword databases_name > file_name
In server_B, i create a new database using the command b
I used mysqldump to backup a database before I ran a structure change script
on it. Well, things didnt work right, so I deleted the database, recreated
it, and tried to import the data again. No luck. I am getting this error
message..
[root@fg tep_catalog-pr2.1]# mysql -p catalog/ <
/root/tep_c
cerveja:/var/lib/mysql# mysqldump -e -l -F -h champagne velop >
champagne.velop.20010214.dump
Segmentation fault
cerveja:/var/lib/mysql#
:/
---
Tenha uma conta de email Grátis no ACBusca!
---
33 matches
Mail list logo