Sample Header Ad - 728x90

Error while restoring a Database from an SQL dump

19 votes
7 answers
71952 views
I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error: $ >mysql -u root -p -h localhost -D database -o mysql -u root -p -h localhost -D database --binary-mode -o < dump.sql but this gave me the following ERROR at line 1: Unknown command '\☻'.` It is a 500 Mb dump file, and when I view its contents using gVIM, all I can see is expressions and data which is not comprehensible. Also when I try to copy contents from the file to post here all I can copy is :SQLite format 3 This kind of seems strange.
Asked by user1434997 (291 rep)
Jun 18, 2013, 12:05 AM
Last activity: Jul 30, 2025, 02:05 PM