You could use something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd > /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. after a mysql_install_db command. Ciao, Stefano > -----Original Message----- > From: Relihan, Daniel [mailto:[EMAIL PROTECTED]] > Sent: 18 July 2002 15:48 > To: '[EMAIL PROTECTED]' > Subject: MYSQL freezing > > > Hi, > > mySQL wasnt allowing anyone to write to it, so I deleted some > stuff and > mySQL started working again. However, even though I had freed > up more than > enough space, the problem repeated itself. When I tried to drop an old > database, mysql hung and I cant even get into mysql anymore. > Any ideas on > what to do? Thankfully, I backed up the database that I need, > so if I fresh > install is needed, then it wont be a problem. Thank you for > your help. I > really appreciate it. > > - Dan R. > > --------------------------------------------------------------------- > 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
