Hello, I am trying to move a couple tables over to a
different database, so first I went and exported the
tables I wanted to move, and it gave me this code (moved to attachment).
OKay, so I saved this as database.sql. Now, I go to
the place where I want to import all this, and do the
usual. I click on the import tab, browse for the file,
and click "go". After clicking go, I get this error
message:
_________Error message starts here____
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 03, 2006 at 04:57 AM
-- Server version: 4.0.23
-- PHP Version: 4.4.0
--
-- Database: `galacticwebdesigns_com_2`
--
-- ----------------------------------------------------
----
--
-- Table structure for table `wiki_archive`
--
DROP TABLE IF EXISTS `wiki_archive` ;
MySQL said:
#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 '
DROP TABLE IF EXISTS `wiki_archive`' at line 1
_______error message ends here__________
Im guessing that it is creating the wrong export code
for some reason. . . . . I really have know idea, but
I need this problem fixed ASAP.
Thanks,
Austin
Logged In: YES
user_id=835650
What MySQL version are you exporting from? Trying to import to?
Logged In: YES
user_id=1602397
I have the same problem with ver 2.9.0RC1 and databse ver
4.1.20 and PHP 5.1.6.
Not all tables are put into export file!
I checked on 2.8.2.4 -> is OK.
Logged In: YES
user_id=192186
To original issue:
2.8 branch had problem with byte-order marks which might be
included in SQL dump, it has been fixed for 2.9.
peeszek:
Please create separate report for your issue with more
details (eg. do you see all tables on listings?).
Logged In: YES
user_id=1312539
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
Moved inline SQL dump to attachment.
Diff:
Diff:
Last edit: Michal Čihař 2015-07-09