Re: Problem with mysqldump and local-infile

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

Re: Problem with mysqldump and local-infile

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

Re: problem with mysqldump when there is a merge table

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

Re: Problem with mysqldump

-- 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

Re: Problem with mysqldump

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

Re: problem with mysqldump, ustf8 with mysql 4.1

"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

Re: problem with mysqldump

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>

Re: problem with mysqldump

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: Query was empty jb> and t

Re: Problem with mysqldump when using query caching

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

Re: Problem with mysqldump when using query caching (4.01)

Ken, On Wed, Apr 10, 2002 at 01:24:46PM -0400, Ken Menzel wrote: > Hi Nick, >I am seeing some rather strange problem here with mysqldump, after > trying very hard to reproduce the problem on a test server, I gave > up. Do the options make any difference when you run it? Can you send

Re: Problem with mysqldump when using query caching

Hi Nick, I am seeing some rather strange problem here with mysqldump, after trying very hard to reproduce the problem on a test server, I gave up. Do the options make any difference when you run it? Can you send a trace of the actual dump? I was seeing mysqldump terminate in my case, now

Re: problem with mysqldump

Dear Agent Smith, as said, mysqldump is a command line program, not an SQL command. In PhpMyAdmin, use the CSV or SQL dump function built in. To dump a database, select the database (left frame), then click "dump database" (right frame), best with options "structure and data", "with drop table s

Re: problem with mysqldump

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

Re: Problem with mysqldump....

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, I'm trying to backup al

Re: Problem with mysqldump....

Dont use mysqldump to import. Use mysql. I can't remember the exact syntax, but reference mysql.com for mysqldump, then in the syntax example for that, they show you how to import it. Ryan Shrout Production Manager Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] (859) 653-3341 - Origina