MySQL Forums
Forum List  »  Backup

importing backup data with events
Posted by: Troy John Policarpio
Date: March 22, 2017 09:43PM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
importing backup data with events
550
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.