Importation of SQL text file

brentshreve · #1 (**permalink**) 01-27-06, 13:55

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 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 '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!

Pat Phelan · #2 (**permalink**) 01-27-06, 14:48

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

brentshreve · #3 (**permalink**) 01-27-06, 20:25

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?