Ann
|
Posted: 04/28/2002, 2:25 PM |
|
Hello,
Can Support at Codecharge please help? I am unable to create a MySQL
database using either the supplied MySQL scripts or the mdb's using
MySQLFront. I get errors with both. With the mdb there seems to be a problem
with just one of the tables; with the script it falls over immediately.
I have and can still create MySQL databases from the mdb and scripts
supplied with CodeCharge v2 using MySQLFront so I think I am doing
everything right.
I would be grateful for any assistance.
Ann
|
|
|
webmaster
|
Posted: 04/28/2002, 3:13 PM |
|
for .sql file
Examples\Internet\Internet_MySQL.sql
remove all "--" lines.
--
--DROP TABLES
--
...
--
--CREATE TABLES
--
also you don't need all "drop table"
Ann <aahpce$qvk$1@news.codecharge.com> wrote:
>Hello,
>
>Can Support at Codecharge please help? I am unable to create a MySQL
>database using either the supplied MySQL scripts or the mdb's using
>MySQLFront. I get errors with both. With the mdb there seems to be a problem
>with just one of the tables; with the script it falls over immediately.
>
>I have and can still create MySQL databases from the mdb and scripts
>supplied with CodeCharge v2 using MySQLFront so I think I am doing
>everything right.
>
----------------------------------------------
IMS Japanese CodeCharge http://www.imsj.com/codecharge/
Hot Demo http://www.myphpportal.com/
|
|
|
TonyC
|
Posted: 04/28/2002, 8:24 PM |
|
Hi Ann,
It is easier to use phpMyAdmin. Create the db named internet then Open with
notepad Internet_MySQL.sql script and copy it into the Run SQL section of
phpMyAdmin.
TonyC
|
|
|
Ann
|
Posted: 04/29/2002, 3:53 AM |
|
Hi,
Many thanks for the help. Removing all those "-- etc" did the trick. Very
please as I am used to MySQLFRONT and am pleased to be able to continue
using it.
I just assumed (big mistake, I know) that those two dashes were comments;
lines that SQL would just ignore. I know a bit better now.
Ann
"webmaster" <webmaster@myphpportal.com> wrote in message
news:3ccc73df.2597%webmaster@myphpportal.com...
>
> for .sql file
> Examples\Internet\Internet_MySQL.sql
>
> remove all "--" lines.
> --
> --DROP TABLES
> --
> ..
> --
> --CREATE TABLES
> --
>
> also you don't need all "drop table"
>
|
|
|
Riccardo Novello
|
Posted: 04/30/2002, 3:40 AM |
|
Easier? Are you sure?
"TonyC" <tonyc@adc2001.com> ha scritto nel messaggio
news:aaiech$uvp$1@news.codecharge.com...
> Hi Ann,
>
> It is easier to use phpMyAdmin. Create the db named internet then Open
with
> notepad Internet_MySQL.sql script and copy it into the Run SQL section of
> phpMyAdmin.
>
> TonyC
>
>
|
|
|