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
Last activity: Jul 30, 2025, 02:05 PM