Getting Started - Having trouble with 1&1 and importing SQL file

Print Page | Close Window

Having trouble with 1&1 and importing SQL file

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3872
Printed Date: 05-July-2024 at 2:00pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Having trouble with 1&1 and importing SQL file

Posted By: pzula
Subject: Having trouble with 1&1 and importing SQL file
Date Posted: 22-July-2010 at 6:58pm

Has anyone else had trouble with version 4.1 and setting up the SQL file with 1&1 hosting?
The contents of the SQL file are too long to copy & paste into the query analyzer, so I had to import the SQL file as a .bak and it has been "running" for about 5 hours. It's only 511MB and its still not done. Does anyone have any tricks to getting around these issues?? I really need to get this store set up! Thanks!

Replies:

Posted By: cognecy
Date Posted: 22-July-2010 at 7:12pm

Sorry to hear you are having trouble.

Here are a few pointers:

If you are working on a SQL Server, you really need to be using SQL Server Management Studio that corresponds with the version of SQL Server you are on. This software is free form Microsoft.

You cannot import the SQL file as a BAK. This file is a query and must be ran against the database you have created.

When you stated the query was too long for the Query analyzer this makes me thing you are using the online version that was specific for SQL2000 (not too many people use this anymore). Regardless, I know of no such limits on queries mainly because they are queries (mini programs that get compiled and ran ... can be literally thousands of lines long).

If are having difficulty with this and need assistance give me a call. If you have remote login credentials for your SQL server I can log into it and get this set up pretty quick.

I will send you an IM with my contact information.

-------------
Mark Shipp
Cognecy Solutions, LLC
Hosting/Design/Customization/Database Migration
www.cognecy.com
www.cognecy.co.uk