WordPress.org

1. Martin Hasan
   Member
   Posted 2 years ago #

   I'm trying to move wordpress from one server to another. Once I try to upload the sql file I get this:

   #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 utf8 COLLATE utf8_general_ci' at line 12

   Please, if anyone knows how I can fix this it would be very much appreciated.

2. Martin Hasan
   Member
   Posted 2 years ago #

   Any ideas?

3. whooami
   Member
   Posted 2 years ago #

   where are you uploading that to?

4. Martin Hasan
   Member
   Posted 2 years ago #

   Phpmyadmin. It's a back-up sql file.

5. Martin Hasan
   Member
   Posted 2 years ago #

   Basically I have an SQL back-up file of a previous installation of WordPress and I'm trying to move it to another server. When I try to upload the back up I get that error.

6. whooami
   Member
   Posted 2 years ago #

   ok,

   open it in a plain text editor. whats on lines 1-15?

7. Martin Hasan
   Member
   Posted 2 years ago #

   -- phpMyAdmin SQL Dump
   -- version 2.8.2.4
   -- http://www.phpmyadmin.net
   --
   -- Host: localhost:3306
   -- Generation Time: Sep 29, 2009 at 10:45 AM
   -- Server version: 4.1.20
   -- PHP Version: 5.0.5
   --
   -- Database: foster_wordpress
   --
   CREATE DATABASE foster_wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
   USE foster_wordpress;

   -- --------------------------------------------------------

8. Martin Hasan
   Member
   Posted 2 years ago #

   Does that help?

9. whooami
   Member
   Posted 2 years ago #

   yes.

   immesnsely.

   what you probably want to do is NOT let that create the db. You do that. so backup that dump file, then edit it to remove the Create database ... crap.

   You also dont need to tell it what DB to use, so remove that USE statement also.

   save the file.

   Then you create the db.

10. Martin Hasan
    Member
    Posted 2 years ago #

    Thank you. Very helpful.

Topic Closed

This topic has been closed to new replies.