MySQL Forums
Forum List  »  Backup

from MySQLDUMP File Remove USE
Posted by: Ganapathy Arvindan
Date: January 19, 2017 03:45AM

I am trying to take records from multiple databases and storing into single database, for that i am taking backup using mysqldump like this ..

mysqldump.exe --user=root --password=root --no-create-db --no-create-info --databases shipdb1 shipdb2 > "D:\dump\six.sql"

then restore.. but in the six.sql(dump file) i am getting USE databasename statement. i got the solution like remove --databases it works fine for single db backup, in multiple db backup it shows "mysqldump: Couldn't find table: "shipdb2"

Please help me in this to resolve this error or any other way to take records from multiple databases and storing into single database.

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
from MySQLDUMP File Remove USE
866
January 19, 2017 03:45AM
429
January 19, 2017 09:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.