InnoDB HotBackup but it costs money.
http://www.innodb.com/hot-backup
-Original Message-
From: Ofer Inbar [mailto:[EMAIL PROTECTED]
Sent: 18 July 2007 00:12
To: mysql@lists.mysql.com
Subject: quickly copying a database
I've got a server with a database that's about 10G. I ne
I've got a server with a database that's about 10G. I need several
other copies of this database, with different names, on the same host
and same MySQL instance.
I could mysqldump the db and then restore it into the others...
mysql> create database one;
mysql> create database two;
...
mysqldum
Egor Egorov wrote:
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise create new database, make a dump of tables
Ed Curtis <[EMAIL PROTECTED]> wrote:
>
> How would you go about copying a database? I need to make a copy with all
> the tables and names the same. I just need to name the database something
> different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise c
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
gt; > - Original Message -
> > From: "Marko Milutinoviè" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 20, 2001 8:05 AM
> > Subject: Renaming and/or copying a database
> >
> >
> > > Hi!
one on 3.23.33.
Regards,
Fred.
> - Original Message -
> From: "Marko Milutinoviè" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 20, 2001 8:05 AM
> Subject: Renaming and/or copying a database
>
>
> > Hi!
> >
> >
t: Tuesday, March 20, 2001 8:05 AM
Subject: Renaming and/or copying a database
> Hi!
>
> I'm running MySQL on Win NT 4. I'm trying to rename a database from my
> program, but I haven't found any inforamtion about this on the MySQL site.
> Can anybody help me?
>
Hi!
I'm running MySQL on Win NT 4. I'm trying to rename a database from my
program, but I haven't found any inforamtion about this on the MySQL site.
Can anybody help me?
Can a database named 2001 be created? Can a database be copied to another
one via SQL statements?
regards,
m@rko
---
