Daniel Kasak wrote:
Greetings.
I've just hit an interesting problem. Luckily I don't actually *need* to
restore from a backup right now - I'm just trying to create a database
dump to submit an unrelated bug report.
Anyway ...
I'm using the command:
mysqldump -K DATABASE_NAME db.sql -p
i think you can use -K on your mysqldump and it'll put the hints in there
for the mysql command to use as well
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign
Michael Stassen wrote:
Before loading the file,
SET FOREIGN_KEY_CHECKS = 0;
after loading the file,
SET FOREIGN_KEY_CHECKS = 1;
That's it! Thanks :)
Even better, upgrade to a newer mysql (4.1.1+), where they are
automatically added to the dump file for you.
Not until the client
[EMAIL PROTECTED] wrote:
Hi,
Thank you for your reply. If I have the create table info in my
dump file, while doing the restore using mysql dbname dump.dmp, I am
getting errors like
mysql -uMNMSDBA -pMNMSDBA -f mnms
c:\progra~1\mitel\opsman~1\temp\almhist.dmp
ERROR 1050 at line 11: Table
Ligaya Turmelle wrote:
I'm a beginner - but can't you also use mysqlimport?
Not in the case when you have made a backup using mysqldump while using
the default options. mysqlimport is a front end for LOAD DATA INFILE
(http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html)
It is usefule when you
it from backup file.
Thanks
Anil
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 12:58 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: backup/restore
Hi,
Thank you for your reply. If I have
PROTECTED]
Subject: RE: backup/restore
Hi,
with which options of mysqldump you have taken backup. if you
use --add-drop-table option then it will add drop table statement in
dump
file. otherwise it wont add that statement and you will get that type of
errors.
if you didn't use that option then drop
-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 10:55 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: mysql@lists.mysql.com
Subject: RE: backup/restore
[snip]
I am doing backup for tables using Mysqldump. But while doing the
restore I
am not able to do
]
Subject: RE: backup/restore
Hi,
Thank you for your reply. Even though I used the --add-drop-table
option, I am getting the error messages. Actually I am taking the backup
for a group of tables as following
D:\Code\OPS\6.9.1.12\NetMgmt\OPS_src\C_src\backupmnms\Debugmysqldump
-uMNMSDBA -p
MNMSDBA
[snip]
I am doing backup for tables using Mysqldump. But while doing the restore I
am not able to do that using the same Mysqldump. Could you please help me in
that.
[/snip]
mysqldump is not intended to be used for the restore.
You need to run the following:
mysql -D dbname mysqldumpfile
You
I'm a beginner - but can't you also use mysqlimport?
Respectfully,
Ligaya Turmelle
Tom Crimmins wrote:
[snip]
I am doing backup for tables using Mysqldump. But while doing the restore I
am not able to do that using the same Mysqldump. Could you please help me in
that.
[/snip]
mysqldump is not
,
Narasimha
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 10:55 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: mysql@lists.mysql.com
Subject: RE: backup/restore
[snip]
I am doing backup for tables using Mysqldump. But while doing
I would strongly recommend proving that your solution will work acceptably
by testing it first; don't just assume that all will go well or that we can
anticipate all the problems sight unseen.
Make small test copies of your databases first and then try doing backups
and restores to verify that
DANIELE Paolo [EMAIL PROTECTED] wrote:
I have a version of MySQL on my server (mysql Worm 11.18 Distrib
3.23.56, for PC-linux (i686)) which I wish to transfer towards a more
recent server (mysql Ver 11.18 Distrib 3.23.58, for PC-linux (i686)). I
make a complete backup of the data with the
the update log is.
Currently it's in d:\mysql\bin
Pete
Original Message
Subject: RE: backup/restore of mysql
Date: Tue, 10 Jul 2001 17:48:31 +0100
From: Simon Green [EMAIL PROTECTED]
To: 'Pete Kuczynski' [EMAIL PROTECTED]
Hi Pete
To emable loffing use the --log option eg --log-update
Greg Cope wrote:
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB up
to date till the time in went down
Simon
PS update logs have all the SQL statements in them so it should be very
simple to recover!
-Original Message-
From: Pete
: Re: backup/restore of mysql
Hi,
do I need to generate these logs using the my.ini file on NT.
Pete
Simon Green wrote:
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB
up
to date till the time in went down
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
IBM Netfinity server
Hi!
At 05:44 PM 6/1/01 +0400, you wrote:
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld
20 matches
Mail list logo