We're trying to set up some scripts that will run mysqldump to create export
files for each table in a database that can be downloaded to a test server
and reloaded. What's weird is that the files are created with the ?
character as the trailing character in the file name and we can't open them
[snip]
We're trying to set up some scripts that will run mysqldump to create
export
files for each table in a database that can be downloaded to a test
server
and reloaded. What's weird is that the files are created with the ?
character as the trailing character in the file name and we can't open
To: Christensen, Dave; [EMAIL PROTECTED]
Cc: Dickey, Dallas
Subject: RE: Odd thing
[snip]
We're trying to set up some scripts that will run mysqldump to create export
files for each table in a database that can be downloaded to a test server
and reloaded. What's weird is that the files are created
[snip]
Just creating shell scripts with one line creating each file. This is
our
first attempt to see how working with the smaller files performs while
transferring data between sites.
[/snip]
It sounds as if (based on past experience) that the filename is being
created with an additional
: Dickey, Dallas
Subject: RE: Odd thing
Just creating shell scripts with one line creating each file. This is our
first attempt to see how working with the smaller files performs while
transferring data between sites.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED
Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:52 AM
To: Christensen, Dave; [EMAIL PROTECTED]
Cc: Dickey, Dallas
Subject: RE: Odd thing
[snip]
Just creating shell scripts with one line creating each file. This is our
first attempt to see how working with the smaller files
Delphi is being used to create a file with a mysqldump command per table
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:43 AM
To: Christensen, Dave; [EMAIL PROTECTED]
Cc: Dickey, Dallas
Subject: RE: Odd thing
[snip]
We're trying to set
[snip]
mysqldump AgentAdminDB activitylookup -u UserName -pPassword
//var/data/mysql/activitylookup.sql
mysqldump AgentAdminDB agencies -u UserName -pPassword
//var/data/mysql/agencies.sql
mysqldump AgentAdminDB agentdocuments -u UserName -pPassword
//var/data/mysql/agentdocuments.sql
mysqldump
PROTECTED]
Cc: Dickey, Dallas
Subject: RE: Odd thing
Hi,
are you using MSDOS/Windows anywhere here - it might be a trailing ^M which
Windows uses before ^J as the end of line character.
Regards
Matthew
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
Sent: 19 June 2003
]
mailto:[EMAIL PROTECTED] ]
Sent: Thursday, June 19, 2003 10:10 AM
To: Dickey, Dallas; Christensen, Dave; [EMAIL PROTECTED]
Subject: RE: Odd thing
[snip]
mysqldump AgentAdminDB activitylookup -u UserName -pPassword
//var/data/mysql/activitylookup.sql
mysqldump AgentAdminDB agencies -u UserName
, June 19, 2003 10:58 AM
To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave;
'[EMAIL PROTECTED]'
Subject: RE: Odd thing
I've also tried creating the script manually (script follows) and all that's
being created is a text header with nothing else in the file. At least in
these instances we can
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script
file.
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:34 AM
To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]'
Subject: RE: Odd thing
Importance: High
: Odd thing
Importance: High
When I run this script file, I receive errors like this:
[EMAIL PROTECTED] work]# ./BackupByTable.bat
mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist
when doing LOCK TABLES
-Original Message-
From: Christensen, Dave [mailto:[EMAIL
On 19-Jun-2003 Christensen, Dave wrote:
We're trying to set up some scripts that will run mysqldump to create
export
files for each table in a database that can be downloaded to a test
server
and reloaded. What's weird is that the files are created with the ?
character as the trailing
-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 12:19 PM
To: Christensen, Dave
Cc: '[EMAIL PROTECTED]'
Subject: Re: Odd thing
Christensen, Dave wrote:
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my
script file.
-Original Message-
From
15 matches
Mail list logo