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 TABLES! "N. Kavithashree" <[EMAIL PROTECTED]> 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? > > ==================================================== > N. Kavithashree > =================================================== > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
