Does anybody know of any issues when have a large (+1000) databases in MySQL? It will be running on RedHat 9. Would there be any problems running backups with this many DBs on one box?
Regards Richard ----- Original Message ----- From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 12:15 PM Subject: Re: mysqldump with innoDB > In article <[EMAIL PROTECTED]>, > Daniel Kasak <[EMAIL PROTECTED]> writes: > > > Paul DuBois wrote: > >> If you have problems reloading the table due to the order > >> in which the InnoDB tables appear in the dump files, add > >> > >> SET FOREIGN_KEY_CHECKS = 0; > >> > >> to the beginning of the file before reloading it. > >> > > Our backups are quick large - over 500 MB. Opening the file and adding > > the above line at the top takes a lot of CPU time and memory - and > > when I'm restoring, I don't have a lot of time... > > > Is there an easier way to get it there - can I 'cat' to the beginning > > of a file, or should I make my backup scripts cat the output of > > mysqldump to the end of a file with 'set foreign_key_check=0;' at the > > top? Maybe we could have a switch for mysqldump that does this for us? > > Here's an excerpt from my backup script: > > for db in $DBNAMES; do > ( echo "SET FOREIGN_KEY_CHECKS = 0;" > echo "" > mysqldump -u backup --opt $db > echo "SET FOREIGN_KEY_CHECKS = 1;" > ) | bzip2 >$date.$db.bz2 > done > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
