Re: updates during database dump

2006-05-08 Thread Jeremy Cole
Hi Luke, When mysql is doing a dump, do the updates that happen during the dump get included in the dump. I assume you mean 'mysqldump'. I have a dump that starts at 11pm and goes for 2 hours. If someone updates data at say 11:45pm, does that update get included in the dump? When does the

Re: updates during database dump

2006-05-07 Thread Merlin, the Mage
--- > > -Original Message- > From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] > Sent: Monday, 8 May 2006 8:32 AM > To: MySQL List > Subject: updates during database dump > > Hi. > > When mysql is doing a dump, do the updates that

RE: updates during database dump

2006-05-07 Thread Logan, David (SST - Adelaide)
t --- -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Monday, 8 May 2006 8:32 AM To: MySQL List Subject: updates during database dump Hi. When mysql is doing a dum

updates during database dump

2006-05-07 Thread Luke Vanderfluit
Hi. When mysql is doing a dump, do the updates that happen during the dump get included in the dump. I have a dump that starts at 11pm and goes for 2 hours. If someone updates data at say 11:45pm, does that update get included in the dump? When does the window, on what gets included in a du

Re: database dump query

2004-03-25 Thread Tim Cutts
On 25 Mar 2004, at 15:23, joe collins wrote: Hi, anyone know what happens if, while I am doing a database dump, someone logs into the database and updates records, what records are trapped in the dump, or can the dump proceed under this circumstance...in other words must I knock all users off

database dump query

2004-03-25 Thread joe collins
Hi, anyone know what happens if, while I am doing a database dump, someone logs into the database and updates records, what records are trapped in the dump, or can the dump proceed under this circumstance...in other words must I knock all users off the database before the dump is done? Many

RE: Database Dump

2003-11-17 Thread Christensen, Dave
age- From: Swati K [mailto:[EMAIL PROTECTED] Sent: Saturday, November 15, 2003 5:41 AM To: [EMAIL PROTECTED] Subject: Database Dump Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to anot

Re: Database Dump

2003-11-15 Thread Jan Pieter Kunst
At 14:13 +0200 15-11-2003, Davut Topcan wrote: > I have just started working on MYSQL. Can ne one help on How to take a database Backup? Backup; shell # mysqldump table > table.sql I use a command-line PHP script (-rwx--, owned by root, executed with a cron job) to backup MySQL databases.

Re: Database Dump

2003-11-15 Thread Davut Topcan
Hi From: "Swati K" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 15, 2003 1:40 PM > I have just started working on MYSQL. > Can ne one help on How to take a database Backup? Backup; shell # mysqldump table > table.sql for details; http://www.mysql.com/doc/en/Backup.html

Database Dump

2003-11-15 Thread Swati K
Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to another one? Regards Swati kalia http://www.mecklai.com where risk meets its match *** This message i

Re: mysql database dump (remotely, How?)

2003-06-28 Thread Jerry M. Howell II
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote: > On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote: > > lol of course > > > > mysqldump -u username -p databasename > databasename.sql > > > > I am atempting to backup a database remotely. I added something like the

Re: mysql database dump (remotely, How?)

2003-06-28 Thread Jerry M. Howell II
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote: > lol of course > > mysqldump -u username -p databasename > databasename.sql > I am atempting to backup a database remotely. I added something like the following. mysql> GRANT ALL PRIVILEGES ON db.* -> TO david@'192.58.197.0/255.

Re: mysql database dump

2003-06-28 Thread Paul DuBois
At 1:08 -0400 6/28/03, Asif Iqbal wrote: Can I dump a database while the database is running in mysql ? Yes. You can, for example, use the mysqldump program. mysqldump is a MySQL client program that, like all MySQL clients, requires the server to be running. -- Asif Iqbal http://pgpkeys.mit.edu:1

RE: mysql database dump

2003-06-28 Thread electroteque
lol of course mysqldump -u username -p databasename > databasename.sql -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Saturday, June 28, 2003 3:08 PM To: [EMAIL PROTECTED] Subject: mysql database dump Can I dump a database while the database is running in my

mysql database dump

2003-06-27 Thread Asif Iqbal
Can I dump a database while the database is running in mysql ? -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: script for complete Database dump?

2002-09-05 Thread nick gatsis
I suggest you to copy the database files. If you are the administrator in a Linux system make a cron once (for example) a week to copy this files to somwere else. --- Kai Vermehr <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > is there any single MySQL script that would backup > my co

Re: script for complete Database dump?

2002-09-03 Thread Egor Egorov
Kai, Tuesday, September 03, 2002, 3:09:45 PM, you wrote: KV> is there any single MySQL script that would backup my complete database? What about mysqldump? http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This emai

RE: script for complete Database dump?

2002-09-03 Thread Ben Joyce
use mySQLdump. c:\mysql\bin\mysqldump.exe there is a switch for dumping the whole DB. heh, .b > -Original Message- > From: Kai Vermehr [mailto:[EMAIL PROTECTED]] > Sent: 03 September 2002 13:10 > To: MySQL List > Subject: script for complete Database dump? &

script for complete Database dump?

2002-09-03 Thread Kai Vermehr
is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To