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 t
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-
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.
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