Cal Evans wrote:
mysqldump products products.sql
grep s/products/products1/ products.sql products1.sql
mysql products1.sql
Assuming that nothing else in the database is named products. (i.e. you
don't have any fields or tables named products) If you did have fields or
tables, you
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
mysqldump products products.sql
grep s/products/products1/ products.sql products1.sql
mysql products1.sql
Assuming that nothing else in the database is named products. (i.e. you
don't have any fields or tables named products) If you did have fields or
tables, you would most likely have to
copy a table:
mysqldump database table_name table.sql
or to copy the whole db:
mysqldump database db.sql
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate of a db?
If you want a copy of the DATABASE and not of a table, I would suggest
(using unix) ...
cp -R insert mysql data path here/products insert mysql datapath
here/products1
Where the datapath is the dir that contains all the databases.. in my setup
I usually make it /var/mysql... but often its in
At 6:10 PM -0500 7/9/01, ryc wrote:
If you want a copy of the DATABASE and not of a table, I would suggest
(using unix) ...
cp -R insert mysql data path here/products insert mysql datapath
here/products1
Would this only be in the case when there was no activity on the
server? Would there be