Re: How to backup and restore
Hello Ben, all! Ben Burford wrote: Hello, This is my first message, I'm an absolute beginner in Mysql. I did a defaul t installation of version 3.23.58 on RH Linux AS3.0. [[...]] I will not comment on the backup issue, that has been done already. However, I _strongly_ urge you to upgrade to 4.1 (or, even better, 5.0) as soon as possible, or to scrap your 3.23 and restart from scratch using 4.1 or 5.0. There have been so many improvements (both bug fixes and features) in comparison to 3.23 that I do not see any good reason to use that old version for which you will never get upgrades, as for any difficulty you will get the hint: Upgrade! Regards, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore
mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql or mysql --add_drop-table < backup_06082006.sql or maybe mysql < --add_drop-table backup_06082006.sql mysqldump --opt... This will add DROP TABLE .. IF EXISTS to a dump. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore
On 6/9/06, Ben Burford <[EMAIL PROTECTED]> wrote: Hello, This is my first message, I'm an absolute beginner in Mysql. I did a defaul t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to do a backup and a restore. The user's manual says: 5.9.2.1 Backup Policy The following command makes a full backup . . : mysqldump --single-transaction --all-databases > backup_06082006.sql When I did this I got the message: unrecognized option '--single-transaction' So I tried the following: mysqldump --verbose --all-databases > backup_06082006.sql It seemed to work OK (no error messages) and created the file backup_0608200 6.sql According to the manual: 5.9.2.2 Using Backups for Recovery . . restoring it is very easy: mysql < backup_06082006.sql When I tried this I got the following error message: ERROR 1050 at line 19: Table 'Indian' already exists Do I need to delete the table 'Indian'?? I hope someone can tell me in a simple, clear way (minimum of commands, noth ing fancy) how to do a full backup and a full restore (I don't need partials). Thanks very much in advance. man mysqldump Has everything you need to know. And also, consider using an updated version, the one you're using is too old. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore
Hi Eugene, Good to hear from you. Should I use this on the creation or the restore? A s in: mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql or mysql --add_drop-table < backup_06082006.sql or maybe mysql < --add_drop-table backup_06082006.sql or maybe something else?? Thank you, Ben At 16:53 2006/06/09 +0400, you wrote: > > > Ben Burford wrote: > > Hello, > > > > Do I need to delete the table 'Indian'?? > > Try --add_drop-table option > man mysqldump > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore
Ben Burford wrote: Hello, Do I need to delete the table 'Indian'?? Try --add_drop-table option man mysqldump -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore database
I prefder to use a FREE GUI like SQLyog found at http://www.webyog.com Karam --- Gary Richardson <[EMAIL PROTECTED]> wrote: > try mysqldump -keq SDN > SDN.sql > > Then you can import it on another instance using > mysql -u root > new_instance < SDN.sql > > On 5/5/05, zlf <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have installed a MySQL5.0 instance on > Windows. And then created a > > database( named 'SDN' ). Now I want to move this > database to another > > MySQL5.0 envirnment on Linux. > > How can I make it. Thx > > > > zlf > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to backup and restore database
try mysqldump -keq SDN > SDN.sql Then you can import it on another instance using mysql -u root new_instance < SDN.sql On 5/5/05, zlf <[EMAIL PROTECTED]> wrote: > Hi all, > I have installed a MySQL5.0 instance on Windows. And then created a > database( named 'SDN' ). Now I want to move this database to another > MySQL5.0 envirnment on Linux. > How can I make it. Thx > > zlf > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]