> -----Original Message----- > From: N. Kavithashree [mailto:[EMAIL PROTECTED] > Sent: 18 January 2005 05:35 > To: mysql@lists.mysql.com > Subject: backup of database > > > > hello, > > > how to take a backup of database? > i have a database with name1 now i want to move all the tables into > another database? how to do?
Could be mysqldump that you need: http://dev.mysql.com/doc/mysql/en/mysqldump.html examples: mysqldump [--no-data] name1 | mysql name2 mysqldump [--no-data] name1 > name1.sql HTH Graham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]