Skip to content

Instantly share code, notes, and snippets.

@monkyz
Created October 12, 2012 21:50
Show Gist options
  • Save monkyz/3881752 to your computer and use it in GitHub Desktop.
Save monkyz/3881752 to your computer and use it in GitHub Desktop.
error with mysql
hexdump sqldump.sql | head
0000000 6157 6e72 6e69 3a67 5420 6568 6f20 7470
0000010 6f69 206e 2d27 612d 6c6c 2027 7369 6420
0000020 7065 6572 6163 6574 2064 6e61 2064 6977
0000030 6c6c 6220 2065 6572 6f6d 6576 2064 6e69
0000040 6120 6620 7475 7275 2065 6572 656c 7361
0000050 2e65 5020 656c 7361 2065 7375 2065 2d2d
0000060 7263 6165 6574 6f2d 7470 6f69 736e 6920
0000070 736e 6574 6461 0a2e 2d2d 4d20 5379 4c51
0000080 6420 6d75 2070 3031 312e 2033 4420 7369
0000090 7274 6269 3520 312e 362e 2c33 6620 726f
file sqldump.sql
sqldump.sql: ASCII English text, with very long lines
head sqldump.sql -n 5
Warning: The option '--all' is deprecated and will be removed in a future release. Please use --create-options instead.
-- MySQL dump 10.13 Distrib 5.1.63, for debian-linux-gnu (i486)
--
-- Host: localhost Database: awdb
------------------------------------------------------------
conclusion:
the problem was with the dump creation syntax, the --all was removed and everything went fine
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment