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 character in the file name and we can't open
> them
> to do anything with the files.
>
Probably you have a unprintable character in your script.
For reference, here's what I use for backup:
---
#!/bin/sh
# dwr dump database(s) each day
DUMP=$HOME/archive/db
DBS="auth gl ar ap inv"
DIR=`date +%a`
cd $DUMP
mkdir -p $DIR
rm -f Today
ln -sf $DIR Today
cd $DIR
for K in $DBS
do
TBLS=`mysql -N -e "show tables" $K`
for I in $TBLS
do
mysqldump -e -q --add-drop-table $K $I >> $K.$I.sql
rm -rf $K.$I.sql.gz
gzip $K.$I.sql
done
done
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
