mysqldump restore db syntax

mailing.database.mysql - MySQL database issues discussed in this best MySQL group in USENET 

Subject Author Date mysqldump restore db syntax Vadim 04-29-2006  Re: mysqldump restore db syntax Aggro 04-29-2006  Re: mysqldump restore db syntax Vadim 04-30-2006

Posted by Vadim on April 29, 2006, 4:38 pm Please log in for more thread options Hi! I succesfully exported my locally stored db using the following syntax: show/hide quoted text mysqldump -u root --password=111 finance > sqlbk.dump Now I created another empty db finance2 (on the same Mysql server) and try to restore their my finance db: mysqldump -u root --password=111 finance2 < sqlbk.dump Restore begins to run. I get all the "SET" lines printed, but nothing is imported. What am I doing worng? Thanks a lot in advance! Vadim Posted by Aggro on April 29, 2006, 5:09 pm Please log in for more thread options Vadim wrote: show/hide quoted text > I succesfully exported my locally stored db using the following syntax: > mysqldump -u root --password=111 finance > sqlbk.dump > > Now I created another empty db finance2 (on the same Mysql server) and > try to restore their my finance db: > > mysqldump -u root --password=111 finance2 < sqlbk.dump mysql -u root --password=111 finance2 < sqlbk.dump mysqldump is only for creating dumbs. For restoring the dump, use mysql. Posted by Vadim on April 30, 2006, 6:23 am Please log in for more thread options Many thanks to you :) Similar Threads Posted mysqldump and restore of Innodb Tables March 22, 2005, 10:51 am ERROR:Using the mysql client on freebsd to restore a mysqldump?? August 15, 2005, 2:03 am Restore db from 4.1.12 to 3.23 July 13, 2005, 11:21 am Restore Your Account August 11, 2005, 1:45 am slow restore March 7, 2006, 12:41 pm cannot restore 3.23.58 db to MySQL 4.0.22-debug November 29, 2005, 3:42 pm mysql backup and restore for 4.1.x April 16, 2006, 12:22 am Quality of Backup and Restore June 2, 2006, 3:38 am backup and restore of var lib mysq February 12, 2009, 2:12 pm What is the fastest way to restore a mysqldumped table? October 31, 2005, 8:12 pm