If I understand you correctly, you are interested in backing up a database without using the mysqldump command, correct?
You have a couple of options: 1) Issue a 'flush tables with read lock', backup the binary files of the database, issue a 'unlock tables'. However, no one will be able to access the database during the period from the flush tables to the unlock tables. (see: http://www.mysql.com/doc/F/L/FLUSH.html) 2) Run replication and backup the slave with the above method. Access to the main database will not be affected. Tony Jarriault wrote: > > Bonjour, > > J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la > base de donnée est de 1Go 5. > Quelles sont les limites pour le bon fonctionnment de mysql ? > Existe il un moyen plus rapide de faire des copies de bases que le dump ? > > Merci > > Cordialement, > > Tony Jarriault > > ----------------------------------------------------------------------- > Service webmaster : mailto:[EMAIL PROTECTED] > Tel : 01-34-49-06-69 > MGN : http://www.mgn.fr > ----------------------------------------------------------------------- > > Tony Jarriault > mailto:[EMAIL PROTECTED] > Tel : 01-34-49-06-43 > MATRA GLOBAL NETSERVICES > Societé du groupe PROSODIE > 8, rue Grange Dame Rose > 78140 Vélizy > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
