EvilZone

Community => General discussion => : helloworld420 August 13, 2015, 02:31:12 PM

: phpmyadmin import problem
: helloworld420 August 13, 2015, 02:31:12 PM

I got new hosting for my web site  and when I try to import a .sql datbase I get this error below.
What can i do to fix this ???
SQL query:
  DEFAULT  CHARACTER  SET latin1 COLLATE latin1_swedish_ci;

 
 MySQL said: (https://169.55.15.165:2083/cpsess2646745080/3rdparty/phpMyAdmin/themes/dot.gif) (https://169.55.15.165:2083/cpsess2646745080/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Ferror-messages-server.html&token=835ab312e7cd2340916ab18e45e6ca85)
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line 1

: Re: phpmyadmin import problem
: P!X3LTR0N August 18, 2015, 07:57:32 AM

Dude, I think that error is self explanatory...


Nevertheless, Here is a reference: http://support.hostgator.com/articles/cpanel/how-to-import-your-mysql-database