Re: Mysql backup for large databases

at doesn't take long and don't impact system >>> 2. Restore needs to be done on a quick as possible way in order to >> minimize downtime. >>> >>> The one client is running master - master replication with master server >> in usa, and slave in south africa. They need mast

Re: Mysql backup for large databases

ster - master replication with master server > in usa, and slave in south africa. They need master backup to be done in > the states. > > > > > > Sent via my BlackBerry from Vodacom - let your email find you! > > > > -Original Message- >

Re: Mysql backup for large databases

; Sent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck &g

RE: Mysql backup for large databases

machiel.richa...@gmail.com [mailto:machiel.richa...@gmail.com] > Sent: Thursday, November 01, 2012 8:54 AM > To: Reindl Harald; mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > Well, the biggest problem we have to answer for the clients is the > followin

Re: Mysql backup for large databases

ent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck >

Re: Mysql backup for large databases

ith master server in usa, and slave in south africa. They need master backup to be done in the states. Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: Reindl Harald Date: Thu, 01 Nov 2012 16:49:45 To: mysql@lists.mysql.com Subject: Re: Mysql backup

Re: Mysql backup for large databases

good luck i would call snapshots on a running system much more dumb than "innodb_flush_log_at_trx_commit = 2" on systems with 100% stable power instead waste IOPS on shared storages Am 01.11.2012 16:45, schrieb Singer Wang: > Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2

Re: Mysql backup for large databases

Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2 and etc, you should be fine. We have been using the trio: flush tables with read lock, xfs_freeze, snapshot for months now without any issues. And we test the backups (we load the backup into a staging once a day, and dev once

Re: Mysql backup for large databases

Am 01.11.2012 16:36, schrieb Singer Wang: > On Thu, Nov 1, 2012 at 11:34 AM, Rick James > wrote: > > Full backup: > * Xtrabackup (Backup: slight impact on source; more if you have MyISAM > (as mentioned)) > * Slave (Backup: zero impact on Master -- once

Re: Mysql backup for large databases

e (5.6.x?), you can disconnect a partition from a > table and move it to another table; this will greatly speed up "archiving". > > > -Original Message- > > From: Reindl Harald [mailto:h.rei...@thelounge.net] > > Sent: Thursday, November 01, 2012 4:47 AM > > To:

RE: Mysql backup for large databases

t] > Sent: Thursday, November 01, 2012 4:47 AM > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > > > Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail: > > Using mysqldump and restores on an 80-100GB database seems a bit > > un

Re: Mysql backup for large databases

Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail: > Using mysqldump and restores on an 80-100GB database seems a bit unpractical > as the restore times seems to > get quite long as well as the backup times. * setup a master/slave configuration * stop the slave * rsync the raw datadir to wh

Re: Mysql backup for large databases

On 01/11/2012 11.28, Machiel Richards - Gmail wrote: [...] I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise

Mysql backup for large databases

Hi All I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise license. However, when using the GA (fre

Re: MySQL Backup solution for non-technical user

On Fri, May 13, 2011 at 10:21, Joerg Bruehe wrote: > Hi everybody! > > > Dotan Cohen wrote: >> Is there a simple browser-based MySQL backup solution for >> non-technical users. [[...]] >> The main features needed are: >> 1) Automatic scheduled off-site backups

Re: MySQL Backup solution for non-technical user

Hi everybody! Dotan Cohen wrote: > Is there a simple browser-based MySQL backup solution for > non-technical users. [[...]] > The main features needed are: > 1) Automatic scheduled off-site backups (via SSH or FTP) Off-site = good (for reliability purposes). > 2) Backup multipl

Re: MySQL Backup solution for non-technical user

On Tue, May 10, 2011 at 22:58, Michael Heaney wrote: > Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html > > Michael Heaney > JCVI > On Wed, May 11, 2011 at 10:00, Johan De Meersman wrote: > Zmanda ZRM backup, although the fancy webinterface is only available in the > commercial

Re: MySQL Backup solution for non-technical user

;Michael Heaney" > To: mysql@lists.mysql.com > Sent: Tuesday, 10 May, 2011 9:58:43 PM > Subject: Re: MySQL Backup solution for non-technical user > > Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html > > > Michael Heaney > JCVI > -- Bier met grenady

Re: MySQL Backup solution for non-technical user

On 5/10/2011 3:55 PM, Dotan Cohen wrote: Is there a simple browser-based MySQL backup solution for non-technical users. The server is running Red Hat Enterprise Linux. The main features needed are: 1) Automatic scheduled off-site backups (via SSH or FTP) 2) Backup multiple databases and all

MySQL Backup solution for non-technical user

Is there a simple browser-based MySQL backup solution for non-technical users. The server is running Red Hat Enterprise Linux. The main features needed are: 1) Automatic scheduled off-site backups (via SSH or FTP) 2) Backup multiple databases and all their tables 3) Single-table recovery via GUI

Re: MySQL-Backup incremental Backups in a Master/Slave Environment

Hi, first thanks for your response Are you using InnoDb or MyISAM? If you are using Inno, I would add --single-transaction to your mysqldump command within the Perl script and flush the logs prior to doing the backup and not backup the new bin-log file until the next. No, there is a mixture b

MySQL-Backup incremental Backups in a Master/Slave Environment

Hello everybody, i have a Question concering MySQL-Backups in a Master/Slave Replication-Setup (MYISAM and InnoDB Tables) and incremental Backups using the Binary-Logs from the Slave. Well, in case something will go wrong (hopefully not) I'm currently trying to implement a recovery System. There

Re: best practice MySQl backup onto tape

Jenny Chen wrote: Hi, Keith, In my case, it is just single MySQL server(no replication). Thanks for your info, I'll check with mk-parallel-dump tools, since the speed of backup is important considering the database is locked for the duration of the backup. Well, if you're saying that you're

Re: best practice MySQl backup onto tape

; > > ># Do backup > > tar cvf /dev/rmt/0 /backup/mysql > > > > My question is: is there any other better solutions(including commercial > > solutions) to do hot MySQL backup to tape that can provide better > > performance, or can backup directly to the ta

Re: best practice MySQl backup onto tape

ction --flush-logs > all_databases.sql mysqldump --database=mysql --lock-all-tables --flush-logs > system.sql # Do backup tar cvf /dev/rmt/0 /backup/mysql My question is: is there any other better solutions(including commercial solutions) to do hot MySQL backup to tape that

best practice MySQl backup onto tape

-logs > all_databases.sql mysqldump --database=mysql --lock-all-tables --flush-logs > system.sql # Do backup tar cvf /dev/rmt/0 /backup/mysql My question is: is there any other better solutions(including commercial solutions) to do hot MySQL backup to tape that can provide better performa

Re: Mysql backup scheduler.

gw.googlepages.com/index.html > -- > View this message in context: > http://www.nabble.com/Mysql-backup-scheduler.-tf4436845.html#a12658327 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >

Mysql backup scheduler.

/index.html -- View this message in context: http://www.nabble.com/Mysql-backup-scheduler.-tf4436845.html#a12658327 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: mysql backup methods

Vitaliy Okulov a écrit : > Здравствуйте, mysql. > > Hi all. I searching mysql backup script, which detect type of table & > use mysqlhotcopy for MyISAM or mysqldump --single-transaction for > InnoDB. > Also save structure of table in file. > And support recover

mysql backup methods

Здравствуйте, mysql. Hi all. I searching mysql backup script, which detect type of table & use mysqlhotcopy for MyISAM or mysqldump --single-transaction for InnoDB. Also save structure of table in file. And support recovery for dumped db an tables. Somebody meet such type of mysqlbackup sc

Review O'Reilly MySQL backup chapter?

I'm the author of the O'Reilly book "Backup & Recovery," due to be released in Q3 of this year. Among other things, it has a chapter on backing up MySQL. I'm looking for a few MySQL-knowledgeable folks to provide a technical review of this chapter. Obviously I'd want you to be experience

Re: Mysql Backup/Dump

I just moved my databases to 4.1 from 3.23. It went pretty smoothly. First I used mysqldump to back up the data. Then installed 4.1. First thing did was import only the mysql table. Then ran /mysql_fix_privilege_tables command. After that I was able to login to mysql with my old root password.

Re: Mysql Backup/Dump

It is recommended that you upgrade to 4.0.x first from 3.23.xx, because of any changes to the grant tables in the mysql database, make sure you read the upgrade notes before upggrading, here's a good link to upgrade, http://dev.mysql.com/doc/mysql/en/upgrade.html I find it very simple to zip all

Re: Mysql Backup/Dump

If you are on Windows then you can use a GUI like SQLyog (www.webyog.com) to do the job. I think it will be the easiest way to do that. Karam --- Kory Wheatley <[EMAIL PROTECTED]> wrote: > I want to backup our entire Mysql database structure > for > mysql 3.23.58 and dump it in the newly insta

Re: Mysql Backup/Dump

different box, different versions, use export/import (backup table or LOAD DATA) Mathias Selon Kory Wheatley <[EMAIL PROTECTED]>: > I want to backup our entire Mysql database structure > for > mysql 3.23.58 and dump it in the newly installed > mysql 4.1.10 > > What is the best command to do a

Mysql Backup/Dump

I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed mysql 4.1.10 What is the best command to do a backup and dump everything into the new MYSQL version on a different box? __ Do You Yahoo!? Tire

Re: MySQL backup not backing up all tables

I assume you are running this with cron. Do you get an error message from cron? Do you have enough room on the destination disk for all 88 tables? How big is the backup file? For completeness, what is your OS, and what is your mysql version? Michael Danny Smitherman wrote: I am having trouble

MySQL backup not backing up all tables

I am having trouble with a nightly backup of our MySQL database. Using the mysqldump command, we dump our entire database to a backup directory. But consistently the backup file contains only 33 of the 88 tables in the database. The 33 getting backed up are the first 33 of the 88 as sorted alphabet

MySQL backup not backing up all tables

I am having trouble with a nightly backup of our MySQL database. Using the mysqldump command, we dump our entire database to a backup directory. But consistently the backup file contains only 33 of the 88 tables in the database. The 33 getting backed up are the first 33 of the 88 as sorted alphabet

Re: mysql backup script

Thanks to all that responded. The answer was a little different from the one below. So what it came out to was this: while [ -f $mysqlpid ] do sleep 1 /etc/rc.d/init.d/mysqld stop done For those that recommended webmin. Although I have webmin installed, because of the

Re: mysql backup script

On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote: > I am having a problem with a backup script that is written in a shell > (/bin/sh) script to backup my mysql databases. For some reason on any day > with an even number I get the following error: > MySQL could not be stopped, exitin

mysql backup script

I am having a problem with a backup script that is written in a shell (/bin/sh) script to backup my mysql databases. For some reason on any day with an even number I get the following error: MySQL could not be stopped, exiting... It is really weird because it will run on odd number days without

Re: MySQL Backup advice

y, March 04, 2004 12:09 PM Subject: Re: MySQL Backup advice > Hi Ware Adams, > > thanks for your answer. Here's another question: > > Is it possible to set MySQL to save all the changes that can happen, for > example, if some one insert a new record into table X, MySQL save a l

Re: MySQL Backup advice

Andre MATOS wrote: >Is it possible to set MySQL to save all the changes that can happen, >for example, if some one insert a new record into table X, MySQL save >a log about this task performed and all data that was inserted. I >another person update one field from table Y, MySQL save all the >info

Re: MySQL Backup advice

Hi Ware Adams, thanks for your answer. Here's another question: Is it possible to set MySQL to save all the changes that can happen, for example, if some one insert a new record into table X, MySQL save a log about this task performed and all data that was inserted. I another person update one

Re: MySQL Backup advice

Andre MATOS wrote: >What is the best way to make a good and trustable backup from a live >database, in other words, without shutdown the database? Is there any >free open source tool for this also? There's no free/open source tool that makes a true hot backup when you're using InnoDB. mysqldump

MySQL Backup advice

Hi, I am using MySQL 4.0.18 with InnoDB and I would to have some suggestions about how can I backup the data. I read in this list that some people are using mysqldump, others are using some tools such as Hot Backup. What is the best way to make a good and trustable backup from a live database,

Re: Mysql backup problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Binay -- Saw your post over in php-general but it's better over here :-) ...and then Binay said... % % Hi all ! Hi! % % I have two systems. % one with mysql-version: 3.23.37 % other with mysql-version: 3.23.58 OK. % % now i want to take the

Mysql backup problem

Hi all ! I have two systems. one with mysql-version: 3.23.37 other with mysql-version: 3.23.58 now i want to take the backup of 3.23.37 data and copy to 3.23.58 ... i know i can take backup using mysqldump command ... and then copy using mysql commands but as mysql create folder for ea

Re: question about mysql backup

You may tar de mysql data directory but you shouldn't do it with mysql server running (because it is using the files). If you do not want to stop the mysql server (or lock it from writes), you can, for example, use mysqlhotcopy first to create an identical data directory and then do a tar on that

question about mysql backup

Hi all, Up until now we always created database backups using the mysqldump tool. But I'm wondering, if it is possible to just create a tar archive of the complete mysql data directory. We are running on Linux (2.4.18) and we use mysql 4.014. Thanks, Harm de Laat Informatiefabriek The Netherl

is this proper use of mysql BACKUP?

Hi, I've just had the first look at the BACKUP command. Is this proper use? db_connect($dbuser, $dbpassword, $dbdatabase); // Lock and flush tables before backup $query = "LOCK TABLES un_article READ, un_article_writer READ"; $result = mysql_query($query) or error(mysql_error()); $query = "FLUS

Re: The MySQL Backup problem

At 16:11 -0300 3/19/03, Dyego Souza do Carmo wrote: Hi, I am developing a mySql Backup software and I intend to develop two different options for backup: Complete and Incremental, where Complete means the full copy of a database, and Incremental means that only the log file have to be

The MySQL Backup problem

Hi, I am developing a mySql Backup software and I intend to develop two different options for backup: Complete and Incremental, where Complete means the full copy of a database, and Incremental means that only the log file have to be copied. The logic is the follow: Once a week, my

Re: Programmatic MySQL backup in Perl

Hello, I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option. When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB < JeffsDB.sql I get: ERROR 1065 at line 21: Query was empty Now, line 21 of the SQL file contains: /*!4 AL

RE: Programmatic MySQL backup in Perl

- -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:16 To: [EMAIL PROTECTED] Subject: Programmatic MySQL backup in Perl Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running

RE: Programmatic MySQL backup in Perl

ent: Thursday, December 19, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: Programmatic MySQL backup in Perl Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running

Programmatic MySQL backup in Perl

Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running on a machine remote to the MySQL server. Ta, Jeff - Before posting, please check: http://www.mysql.com/manua

mysql backup user permissions?

i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance, shon --

RE: MySQL Backup

> >> > >> > > > >I usually just copy the complete DB directory from one > computer to another > >one. With fast ethernet it takes around 5-10 minutes (30 > minutes if I have > >to backup the table where I store images). Only thing is > that mysql can't > >write to the table currently being

Re: MySQL Backup

Hello! Erlend Hopsø Strømsvik wrote: > > >>-Original Message- >>From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] >>Sent: 3. september 2002 11:59 >>To: [EMAIL PROTECTED] >>Subject: MySQL Backup >> >> >>Hi, can someo

RE: MySQL Backup

> -Original Message- > From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] > Sent: 3. september 2002 11:59 > To: [EMAIL PROTECTED] > Subject: MySQL Backup > > > Hi, can someone point me in the right direction please > regarding backing

MySQL Backup

Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a Windows 2000 server? Is there a script I can use to dump the database to a cold file where I can back it up off-line or are there agents available to enable me to back the database

mysql backup ahead of re-install

Hi, Im running Linux 7.0 with mysql 3.23.35 installed via rpm. I have some very strange problems where web forms submitted to my php insert page seems to trigger an insert but only the new row's id gets inserted and nothing else. I have tried everything to reproduce the error from my side ( ov

Re: Again regarding MySQL Backup and Recovery

John Hughes wrote: > Please allow me to broaden this thread to include backup for mySQL > users who have accounts with ISPs. > In my case I have mySQL access on a Web server where I have NO access > to the server-level options. What is my best option of making a > backup of the database and tabl

Re: Again regarding MySQL Backup and Recovery

Please allow me to broaden this thread to include backup for mySQL users who have accounts with ISPs. In my case I have mySQL access on a Web server where I have NO access to the server-level options. What is my best option of making a backup of the database and tables that I use? Also, what i

RE: Again regarding MySQL Backup and Recovery

urred during this procedure. Thanks and regards, Chetan Lavti -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 10:19 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: Again regarding MySQL Backup and Recovery On Mon, Mar 04, 2002 at 10:05:

Re: Again regarding MySQL Backup and Recovery

On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote: > > I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform. > Now,for this database backup and recovery procedures are given as : > > 1.Taking 'binary' backup of the database. > 2.Using the mysqldump utility > > I

Again regarding MySQL Backup and Recovery

OTECTED] Subject: Re: MySQL Backup and Recovery On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > Hi, > > I am planning to have MySQL database backup and recovery from the > web interface. Is it possible to do this. If yes, then what > procedure I should follow

RE: RE: MySQL Backup and Recovery

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 1:53 PM To: Chetan Lavti Subject: Re: RE: MySQL Backup and Recovery Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the

Re: MySQL Backup and Recovery

CTED]> Sent: Saturday, March 02, 2002 9:31 PM Subject: Re: MySQL Backup and Recovery > On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > > > Hi, > > > > I am planning to have MySQL database backup and recovery from the > > web interface. Is it possi

Re: MySQL Backup and Recovery

On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > Hi, > > I am planning to have MySQL database backup and recovery from the > web interface. Is it possible to do this. If yes, then what > procedure I should follow. If anybody have any idea about this then > please, do help me.

MySQL Backup and Recovery

Chetan, Friday, March 01, 2002, 5:56:36 AM, you wrote: CL> I am planning to have MySQL database backup and recovery from the web CL> interface. CL> Is it possible to do this. If yes, then what procedure I should follow. Well, specify what exactly do you need - a backup procedure initiated from

MySQL Backup and Recovery

Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Thanks and regards, Chetan Lavti -

MySQL Backup and Recovery

Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Thanks and regards, Chetan Lavti ---

MySQL backup

Hello everyone, I am trying to do backups using the crond daemon on my Linux server. Can I write a similar line as below on my crontab file. Any examples would be appreciated. mysqldump impex > siteroot/home/hasan/backup/backup.sql Alternatively i am thinking of running a perl file ...which

Repost: MySQL Backup and Restore Using Binary Log

Hi I am reposting this just in case someone who would be able to assist me did not see it first time around. Thanks Deon. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (o

MySQL Backup and Restore Using Binary Log

Hi There I have only just subscribed to this list - thank you in advance for any assistance. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (on a different disk to my datab

MySQL backup

Hello, Anybody has any experiences as how to best backup the databases? It should be a part of an automated process, and should happen in such a way as to secure that database integrity is preserved, even upon restoring. So I cannot just backup the files of the databases, because they might be wr

MySQL backup

Hello, Anybody has any experiences as how to best backup the databases? It should be a part of an automated process, and should happen in such a way as to secure that database integrity is preserved, even upon restoring. So I cannot just backup the files of the databases, because they might be wr

Re: [MySQL] Backup error

>Fortunately, these were only test databases so there won't be much >loss. My question is in the future, is there a recommended way of backing >up the databases that will not cause any errors? I'm using mysqldump to create backups.. but that's on linux, I'm not sure about windooz version. Pr

Re: [MySQL] Backup error

Unfortunately, you're using MySQL on a Microsoft product, and you've probably run into one of those issues where Redmond decided what's best for you (changing the 'case' of the filenames). BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on UNIX using 'tar' and 'gzip',

[MySQL] Backup error

Hello, I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my databases/tables to CD-ROM last week. When I tried to access them again from the CD-ROM, I noticed that all file names had been altered to be displayed in uppercase and now they will not function in the php scr

MySQL Backup

Hi, I`m having trouble backing up MySQL on my Cobalt RAQ4r server, I have tried all the methods I can find in the manual but all it ever seems to do is print out some instructions which leads me to beleive I`m doing something wrong, can anyone help? I basically want to backup all of my databa

Re: MySql backup and restore.

You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Admin

MySql backup and restore.

Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the m