Menu

#952 Generating incorrect export code?

2.8.1
closed
nobody
5
2015-07-09
2006-09-03
Austin
No

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

1 Attachments

Discussion

  • Austin

    Austin - 2006-09-03
    • priority: 5 --> 9
     
  • Isaac Bennetch

    Isaac Bennetch - 2006-09-07

    Logged In: YES
    user_id=835650

    What MySQL version are you exporting from? Trying to import to?

     
  • Piotrek

    Piotrek - 2006-09-20

    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.

     
  • Michal Čihař

    Michal Čihař - 2006-09-21
    • priority: 9 --> 5
    • status: open --> pending
     
  • Michal Čihař

    Michal Čihař - 2006-09-21

    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?).

     
  • SourceForge Robot

    • status: pending --> closed
     
  • SourceForge Robot

    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).

     
  • Michal Čihař

    Michal Čihař - 2015-07-09

    Moved inline SQL dump to attachment.

     
  • Michal Čihař

    Michal Čihař - 2015-07-09
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,24275 +1,6 @@
     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:
    -
    -\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_Code starts here\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
    -[skipped]
    -\_\_\_\_\_\_\_\_\_\_code ends here\_\_\_\_\_\_\_\_\_\_\_\_\_
    +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 
    
    • Attachments has changed:

    Diff:

    --- old
    +++ new
    @@ -0,0 +1 @@
    +galacticwebdesigns_com_2.sql (1.1 MB; text/x-sql)
    
    • Group: --> 3.4.7
     

    Last edit: Michal Čihař 2015-07-09
  • Michal Čihař

    Michal Čihař - 2015-07-09
    • Group: 3.4.7 --> 2.8.1
     
MongoDB Logo MongoDB