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
Swati,
You can also use mysqldump to be part of the mechanism to move the
database(s) from one computer to another. Something like:
Prompt mysqldump --add-drop-table databasename -uuserid -ppassword | mysql
--host=your.new.host.IP databasename -uuserid -ppassword
-Original Message-
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
Best
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.