Hello.
See:
http://dev.mysql.com/doc/mysql/en/Backup.html
To backup one database to another on the same MySQL instance
you may FLUSH TABLES WITH READ LOCK and use CREATE TABLE ... SELECT ...
to create tables in the second database from tables in the first one.
Don't forget to UNLOCK TAB
N. Kavithashree wrote:
hello,
i hv a database ONE with some 10 tables;
i want to have a backup so how can i copy these tales to another database
in the same server and also to any other server?
The mysqldump utility can be used for this kind of things:
http://dev.mysql.com/doc/mysql/en/mysqldump.ht
hello,
i hv a database ONE with some 10 tables;
i want to have a backup so how can i copy these tales to another database
in the same server and also to any other server?
N. Kavithashree
===
-