Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Importation of SQL text file

Author  Topic 

brentshreve
Starting Member

1 Post

Posted - 2006-01-27 : 02:43: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:

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:
[url]http://www.onsitepcgeek.com/onsitepcgeek.sql[/url]

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

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2006-01-27 : 03:21:21
Hello Brent

What you have looks like MySQL, this is a SQL Server site. I for one know nothing about mySQL.


steve

-----------

Facts are meaningless. You could use facts to prove anything that's even remotely true!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-27 : 03:35:06
Post your question at MySQL forum of www.DBForums.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -