Your server is probably set up to disallow you from creating databases via a .sql import.
So, either edit your .sql file before you attempt to upload it, and put a # before the CREATE DATABASE `fr201jus_zc1` .... line,
or, when you do your export, select your database from the pulldown on the left, so that all your tables are displayed, and *then* click the "Export" tab. This should cause it to skip building the CREATE DATABASE statement.
FAQ: https://www.zen-cart.com/tutorials/i...hp?article=103
Thread: Unable to import MYSQL database
Results 1 to 10 of 26
Threaded View
-
16 Nov 2007, 10:41 PM #7
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: Unable to import MYSQL data he base
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
Unable to correctly export/import zen cart MySQL data file
By gamenano in forum General QuestionsReplies: 0Last Post: 14 Oct 2010, 04:02 AM -
Import Datafeed to MySQL database?
By kirei in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 27 Nov 2009, 10:09 PM -
MySQL database import error
By xikan in forum Installing on a Linux/Unix ServerReplies: 1Last Post: 24 Aug 2009, 02:39 AM -
Unable to import products
By kathsta in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 3 Jul 2009, 11:54 PM -
Unable to import database
By cherif in forum General QuestionsReplies: 2Last Post: 7 Jul 2007, 05:13 PM
