Thank you so much! On Nov 13, 2007 2:40 PM, Craig Huffstetler <[EMAIL PROTECTED]> wrote: > No, but a table lock or two may be expected. This is to PREVENT data loss > (which you were also worried about). > > The mysqldump process will most likely be quick and painless (quick being a > relative term, depending on the amount of data in your database(s)). > > Craig > > > > On Nov 13, 2007 2:35 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > > > > > > So is it safe to take the dump while database is running. I mean is > > there any loss of data expected because of taking dump while a > > database is running. > > > > > > > > > > > > > > > > On Nov 13, 2007 2:26 PM, Michael Dykman < [EMAIL PROTECTED]> wrote: > > > > > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > > Hello everyone, > > > > > > > > Few conceptual questions which I can't understand. If any one can > > > > please gimme a a quicky! > > > > > > > > Am I correct when I say that "mysqldump' only works when the database > > > > is up and running? and if it is true can any one please tell me that > > > > does taking a dump when a database is running is ok. Also the whats > > > > the difference in usage of mysqldump and taking just the backup of the > > > > database. > > > > > > > > Regards > > > > Naufal > > > > > > Yes, mysqldump is just a specialized client for MySQL, it performs all > > > of it's operations through a server. > > > > > > Whereas a raw file dump is, well, a raw file dump, mysqldump generates > > > SQL scripts which will recreate your databases, tables and data when > > > piped in to a simple command line client thus: > > > > > > mysqldump -h localhost -u user -p mydatabase > mydatabase.sql > > > > > > then, it may be recreated > > > > > > mysql -h otherserver -u user -p databasewhichexists < mydatabase.sql > > > > > > (command line examples are for *nix, but windows variants exist) > > > > > > - michael dykman > > > > > > > > > > > > -- > > > - michael dykman > > > - [EMAIL PROTECTED] > > > > > > - All models are wrong. Some models are useful. > > > > > > > -- > > 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]
