How about going to the dir where the mysql database is then just cp * /backupsqldatabase
And just the other way when you want to restore then use fix database. Thats what I have done and it seems to work fine. > Hi, > > I am quite new with MySQL and I have a question. How can I easily make a > copy of a mysql database locally stored on a server where I have all admin > rights etc. I did not find such a utility/command in the standard MySQL > manual nor in admin utilities I use. > > I use currently the mysqldump utility and then I send the SQL commands > through mysql to the mysql-server, like > > mysql <xx.sql > > where xx.sql is the file that was created by the mysqldump command. This > runs very slowly though. It used to run much quicker, I don't know whether > it is an error or what ... > In any case, is my method of database copying the best one? > > Thanks for any hint > > Ivo > > > --------------------------------------------------------------------- > 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
