importing backup data with events
Hi! I dont know if I'm in the right section. Can anyone help me on importing my backup data along with the events?
Im using this command to backup my db along with the events:
mysqldump --user=root --password=rootpass --host=localhost --port=3307 --result-file="mydir\backup.sql" --default-character-set=utf8 --single-transaction=TRUE --routines --events "myDatabase"
Im using this command to copy it to another database:
mysql --user=root --password=rootpass --host=localhost --port=3307 myDatabase2 < "mydir\backup.sql"
I have no problems on copying the table data from "myDatabase" to "myDatabase2" except that events are not copied in the process. I tried using this command but it doesnt work haha:
mysql --user=root --password=rootpass --host=localhost --port=3307 myDatabase2 < "mydir\backup.sql" --events
Any kind of help will be appreciated. Thanks!
Subject
Views
Written By
Posted
importing backup data with events
1625
March 22, 2017 09:43PM
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.