MySQL Forums
Forum List  »  Newbie

Backup using MySqlDump and MySql 5.6
Posted by: Enio Donci
Date: January 08, 2015 02:21AM

I have used this command script:
echo mysqldump --host=127.0.0.1 --user=utente --password=ed230558 --port=3306 --quick --add-drop-table -v "upama" > "D:\a\upama.sql"
echo ***************
echo backup ok
echo ***************
pause

this is ok with Mysql 5.5

With MySql 5.6 I have the following error:
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error
in your SQL sintax; check the manual that corresponds to your Mysql server version
for the right sintax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1

Is there anyone for help me to rewrite this script ?
many thanks

Options: ReplyQuote


Subject
Written By
Posted
Backup using MySqlDump and MySql 5.6
January 08, 2015 02:21AM


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.