When doing the Export - configure the "Object creation options" as follows:
Add statements:
Add CREATE DATABASE / USE statement -tick
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement - tick
Add CREATE PROCEDURE / FUNCTION / EVENT statement -untick
CREATE TABLE options: -tick
IF NOT EXISTS -tick
AUTO_INCREMENT -untick
Cheers
RodG
Results 1 to 9 of 9
Threaded View
-
22 Aug 2015, 02:47 AM #3
Deceased
- Join Date
- Jan 2007
- Location
- Australia
- Posts
- 6,167
- Plugin Contributions
- 7
Re: Problem Importing SQL database to new database ready for testing Zencart 1.5
Last edited by RodG; 22 Aug 2015 at 02:51 AM.
Reply With QuoteSimilar Threads
-
Error importing old database to the new database
By wmorris in forum Upgrading to 1.5.xReplies: 1Last Post: 3 Jan 2012, 08:27 AM -
HELP importing sql database
By mrtwelvevolts in forum Installing on a Linux/Unix ServerReplies: 4Last Post: 6 Feb 2011, 06:38 PM -
HELP importing sql database
By mrtwelvevolts in forum General QuestionsReplies: 1Last Post: 6 Feb 2011, 04:33 PM -
Error creating database while importing old SQL into new database to move site. Help!
By pap74 in forum Templates, Stylesheets, Page LayoutReplies: 4Last Post: 15 Oct 2010, 07:18 AM -
SQL Errors when importing to new database - #1062 - Duplicate entry '3' for key 1
By countingsheep in forum Upgrading from 1.3.x to 1.3.9Replies: 3Last Post: 17 Sep 2009, 09:43 PM
