----- Original Message ----- From: "Barry Zimmerman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 7:24 AM Subject: Ho do I backup
> Hi there, > > I am a novice with mysql on the terminal side using shell. > > Basically I need to back up a database and have it saved locally from my > server. I have tried using phpmyadmin but it fails as I think the data is > too large. > > I have tried the following: > > mysqldump -u admin -p --databases yabbse > yabbsebackup.sql > > It seemed to work, but where can I find the yabbsebackup.sql file? Not very > experienced with backing up. > > Any help appreciated. > > Thanks > I suspect most people would use the -r (or --result-file) option to indicate where they want the backup written. That's what I do. I haven't tried running mysqldump without one of those options to see what it would do. My guess is that the backup gets written to whatever directory you were in when you ran the command but that could be wildly wrong. Your file system probably has a command that will help you find the file via its name; in Unix/Linux the 'find' command would do that and in Windows, there is also a 'find' or 'search' feature, depending on which version of Windows you are running, built into the GUI. Your best bet would be to run the backup again using the -r or --result-file option and identify where you want the backup written, then verify that it was actually written to the desired location. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
