, Ganeswar Mishra wrote:
Hi Everyone,
I am trying to backup a database regularly, without using
Administrator
tool in mysql,
Can anyone help to write a scipt regarding backup database.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi Everyone,
I am trying to backup a database regularly, without using Administrator
tool in mysql,
Can anyone help to write a scipt regarding backup database.
-Thanks in Advance
Ganeswar
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
However when I create
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
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the
following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when it is
executed
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword
backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly) but when
Rafael Diaz Valdes wrote:
Hi,
I 'm using mysqldump to backup my database, I wrote in my backup.sh the following string:
$MYSQL/bin/mysqldump --opt databasename -user=root --password=rootpassword backup/mysql/databasename.sql
I include backup.sh in my cron weekly (/etc/cron.weekly
-Original Message-
From: N. Kavithashree [mailto:[EMAIL PROTECTED]
Sent: 18 January 2005 05:35
To: mysql@lists.mysql.com
Subject: backup of database
hello,
how to take a backup of database?
i have a database with name1 now i want to move all the tables into
another
Hello.
how to take a backup of database?
See:
http://dev.mysql.com/doc/mysql/en/Backup.html
N. Kavithashree [EMAIL PROTECTED] wrote:
hello,
how to take a backup of database?
i have a database with name1 now i want to move all the tables into
another database? how
hello,
how to take a backup of database?
i have a database with name1 now i want to move all the tables into
another database? how to do?
kavi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear MySQL'ers,
I have backed up my db using :
% mysqldump -p -u tfiedler --opt BigData ./db_backup.sql
When db_backup.sql is scp'd (secure copy) to another machine running
mysqld, then I ssh to that machine and execute :
$ mysql -u tfiedler BigData db_backup.sql
ERROR 1044: Access denied for
On Fri, 6 Feb 2004, Tristan Fiedler wrote:
Dear MySQL'ers,
I have backed up my db using :
% mysqldump -p -u tfiedler --opt BigData ./db_backup.sql
When db_backup.sql is scp'd (secure copy) to another machine running
mysqld, then I ssh to that machine and execute :
$ mysql -u tfiedler
Hi there. Do u know how can i backup my database?
(create insert)
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
On Mon, 12 Jan 2004, Alaios wrote:
Hi there. Do u know how can i backup my database?
(create insert)
http://www.mysql.com/doc/en/Backup.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello:
This is my first message to this list, I want to know how to make a
backup of a database that has memo fields, those memo fields are html
articles (it's a php-nuke web), I use mySQLFront, to extract the .sql with
structure+data, and then I uses mySQLAdmin to create the new database
Hello:
I have already searched on the archives, but any of the solutions are
valid for me because I only have remote access to a windows server to get
the data+structure, and to the new server I only have mySQLAdmin access to
the database.
Best Regards
Visual PHP Studio, RAD
how to copy database from one pc to another without networking
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
-
Before
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
Please read the manual and list archive
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
with best regards,
Keneth
Read the ma
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote:
mysqldump "spits" not only table structures but data also. When you use
mysql to import data it will first attempt to create the table and then load
its values. If your table's got AUTO_INCREMENT set it will work fine after
On 28.02.2001 19:51:13 Gerald L. Clark wrote:
In the dump, the autoincrement columns will have their actual values,
not 0.
Yes, correct - and if the actual value is 0, it will contain just this. And
inserting a row with the col set to 0, will change the column value.
TRY IT!
Try using mysqldump.
BR,
Fbio Ottolini
-Original Message-
From: Keneth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 28, 2003 5:06 AM
To: [EMAIL PROTECTED]
Subject: how to backup mySQL database?
Anyone know how to backup mySQL database?
with best regards,
TOM
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
with best regards,
Keneth
- Original Message -
From: &quo
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine. But now the row will not have
On 28.04.2003 10:55:50 Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
You did not specify the username an
[EMAIL PROTECTED] wrote:
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine.
o Ottolini
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald L. Clark
Sent: Wednesday, February 28, 2001 12:04 PM
To: [EMAIL PROTECTED]
Cc: Fabio Ottolini; [EMAIL PROTECTED]
Subject: Re: Antwort: RE: how to backup mySQL database?
[EMAIL PROTEC
[EMAIL PROTECTED] wrote:
On 28.02.2001 16:03:57 Gerald L. Clark wrote:
But the dump who't have it set to zero, so it will reload with its
proper value.
No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
(AutoCol) VALUES (0)" means that AutoCol should be set to
night or whenever you want to do backups
- write another script which rotates the update logs and install the script under
crontab also
when you need to restore a backup just recreate the database you need to restore and
pipe the last database backup through the mysql program. then do the same
:21 a.m.
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: how to backup mySQL database?
This is the way i do it:
- write a script that will run mysqldump on the database of choice and then
pipe the result though gzip (this is only to reduce the size)
- the script also copies the new backup
Anyone know how to backup mySQL database?
with best regards,
TOM
34 matches
Mail list logo