Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2006
    Posts
    3

    Exclamation Unanswered: Importation of SQL text file

    Hey all,

    I backed up a SQL database from a previous site and am now trying to upload it to my new site. I receive this error when I try to upload the file:

    PHP Code:
    Error

    SQL query
    :

    DATABASE onsitepcgeek running ON mysql99.secureserver.net# phpMyAdmin SQL Dump
    # version 2.5.6
    # http://www.phpmyadmin.net
    #
    # Host: mysql99.secureserver.net
    # Generation Time: Aug 08, 2004 at 04:13 AM
    # Server version: 4.0.20
    # PHP Version: 4.2.3
    #
    # Database : `onsitepcgeek`
    #
    # --------------------------------------------------------
    #
    # Table structure for table `_dummy`
    #
    DROP TABLE IF EXISTS `_dummy` ;

    MySQL saidDocumentation
    #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 'Database onsitepcgeek running on mysql99.secureserver.net 
    The rest of my SQL file can be located at the following address:
    http://www.onsitepcgeek.com/onsitepcgeek.sql

    If you need anymore informaion from me in order to shed some light on this problem please let me know. Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What version of MySQL is the destination site running? I'd bet that it is earlier (probably pre-4.0) than the source site was running.

    -PatP

  3. #3
    Join Date
    Jan 2006
    Posts
    3

    Unhappy Version Info

    I have the site hosted by GoDaddy. They are currently running the following versions on their shared linux/php servers:

    mySQL - 4.0.24
    php - 4.3.11

    The database name on my site is 'onsitepcgeek'
    and it is running on 'localhost'

    Is there something I'm missing? Why will this not import?

  4. #4
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Shouldn't that first line be commented out?
    DATABASE onsitepcgeek running ON mysql99.secureserver.net

  5. #5
    Join Date
    Jan 2006
    Posts
    3

    Talking Thanks a bunch!

    That worked. Don't know how that became uncommented in the first place. Many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •