Ann
|
Posted: 04/28/2002, 8:04 AM |
|
Hi,
Not sure if anyone can help with this. Love CC and CCS looks very
impressive, but I'm having trouble running the MySQL scripts or importing
the mdb's in MySQL-Front. Error is 1064 you have an error in your sql
syntax near DROP TABLES .. DROP TABLE if exist bugs at line 2 when running
the script after importing it into MySQL-Front. Lots of errors like Error:
1146 - Table 'portal.yp_listings' doesn't exist when I try to import mdb
into MySQL-Front.
I'm probably doing something wrong that's really simple, hope someone can
point me in the right direction.
Ann
|
|
|
TonyC
|
Posted: 04/28/2002, 8:15 PM |
|
Hi Ann,
I found it easier to use access to export the database tables one at a time
into a mysql db. If you have access reply and I will give you the steps.
TonyC
|
|
|
Riccardo Novello
|
Posted: 04/30/2002, 3:35 AM |
|
Try to replace -- sql comments with #- (MySQL compatible comments).
"Ann" <a-goth@-remove_this-gothik.freeserve.co.uk> ha scritto nel messaggio
news:aah31o$i8r$1@news.codecharge.com...
> Hi,
>
> Not sure if anyone can help with this. Love CC and CCS looks very
> impressive, but I'm having trouble running the MySQL scripts or importing
> the mdb's in MySQL-Front. Error is 1064 you have an error in your sql
> syntax near DROP TABLES .. DROP TABLE if exist bugs at line 2 when running
> the script after importing it into MySQL-Front. Lots of errors like Error:
> 1146 - Table 'portal.yp_listings' doesn't exist when I try to import mdb
> into MySQL-Front.
>
> I'm probably doing something wrong that's really simple, hope someone can
> point me in the right direction.
>
> Ann
>
>
|
|
|
|