Database Tables Not Showing

[Khan44]

:confused; I am following the Tutorial for setting up the PHP/SQL GlobalCar
Dynamic Page. Everything has gone fine until I got to Getting Started>Setup for
sample PHP site>Connecting to the sample database>Creating the MySQL database.
I made it fine in creating the database, but item number "7. At the system
command prompt, populate the new GlobalCar database in MySQL with the following
command: > mysql -uUser -pPassword GlobalCar < insert.sql
This command uses the insert.sql file to add tables and records to the
GlobalCar database you created in step 5."
When I try, it gives a 1064 Syntax error. I have tried entering it several
ways but still get the error. I'm using WinXP Pro. I've learned a lot from the
tutorial and would like to follow it through. Any help getting those tables
into the database would be appreciated. I'm trying to "graduate" from FrontPage
to DW ;o)

[Anthony Brown]

I would goto mysql.com and download one of there GUI interfaces for MYSQL.
I personally use "MySQL Control Center".

From your command line it looks as if you were trying to add a user and
password then run a SQL statement.

The GUI interface can do all that.


"Khan44" <webforumsuser@macromedia.com> wrote in message
news:cv4ceb$7tc$1@forums.macromedia.com...

> :confused; I am following the Tutorial for setting up the PHP/SQL
> GlobalCar
> Dynamic Page. Everything has gone fine until I got to Getting
> Started>Setup for
> sample PHP site>Connecting to the sample database>Creating the MySQL
> database.
> I made it fine in creating the database, but item number "7. At the system
> command prompt, populate the new GlobalCar database in MySQL with the
> following
> command: > mysql -uUser -pPassword GlobalCar < insert.sql
> This command uses the insert.sql file to add tables and records to the
> GlobalCar database you created in step 5."
> When I try, it gives a 1064 Syntax error. I have tried entering it several
> ways but still get the error. I'm using WinXP Pro. I've learned a lot from
> the
> tutorial and would like to follow it through. Any help getting those
> tables
> into the database would be appreciated. I'm trying to "graduate" from
> FrontPage
> to DW ;o)
>
>
>

[gareth]

Try installing PHPMyAdmin from [url]http://www.phpmyadmin.net[/url]. Just download,
unzip and change the config.php page to add your username and password for
your master MySQL user and then upload to your site. Makes it really easy to
create and administer databases and work with data, much easier than working
from the command line!


--
Gareth - TMM Dreamweaver
[url]http://www.dreamweavermxsupport.com/[/url]
[url]http://www.garethdp.com/[/url]

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
[url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox

[RichMcCrea]

I am not sure if I had (and solved) the same problem... I was using XP Pro
too, and the problem of the databases (refered to by my connection) dissapeared
in the dataset setup, update, and insert dreamweaver dialogs. This bug only
happened after XP Service pack 2 was installed. There was no cure for a long
time, but now there is. Search for XP PRO and SP2 in the dreamweaver forum, I
don't have the URL to the extension plugin anymore that fixed it but the bug
was caused by SP2. I am not sure if this applies to your environment, but the
problem sounds similar (albeit in a different language and with a different
database)

[Khan44]

Originally posted by: Newsgroup User
I would goto mysql.com and download one of there GUI interfaces for MYSQL.
I personally use "MySQL Control Center".

From your command line it looks as if you were trying to add a user and
password then run a SQL statement.

The GUI interface can do all that.




I got it installed but cant find a single option to import the info from the
insert.sql file in to the GlobalCar databse. The only options were "Create New
Table" and "Edit Table". Thanks for the tip on the GUI, though.

[Anthony Brown]

What I do is open the sql in notepad, copy and paste that into the SQL query
window in "MySQL Control".
Basically, you open the program connect to your DB and click on the "SQL"
button on the menu bar.

That will open a "notepad" kinda window that you can use to run SQL
statements with.

"Khan44" <webforumsuser@macromedia.com> wrote in message
news:cv5tk9$j44$1@forums.macromedia.com...

> Originally posted by: Newsgroup User
> I would goto mysql.com and download one of there GUI interfaces for MYSQL.
> I personally use "MySQL Control Center".
>
> From your command line it looks as if you were trying to add a user and
> password then run a SQL statement.
>
> The GUI interface can do all that.
>
>
>
>
> I got it installed but cant find a single option to import the info from
> the
> insert.sql file in to the GlobalCar databse. The only options were "Create
> New
> Table" and "Edit Table". Thanks for the tip on the GUI, though.
>

[Khan44]

Originally posted by: RichMcCrea
I am not sure if I had (and solved) the same problem... I was using XP Pro
too, and the problem of the databases (refered to by my connection) dissapeared
in the dataset setup, update, and insert dreamweaver dialogs. This bug only
happened after XP Service pack 2 was installed. There was no cure for a long
time, but now there is. Search for XP PRO and SP2 in the dreamweaver forum, I
don't have the URL to the extension plugin anymore that fixed it but the bug
was caused by SP2. I am not sure if this applies to your environment, but the
problem sounds similar (albeit in a different language and with a different
database)

SP3 will probably be issued before I install SP2. Thanks for the info for
future reference though :)

[Khan44]

Originally posted by: Newsgroup User
Try installing PHPMyAdmin from [url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox




Got it all downloaded and strted working on it, but editting that file is
about as simple as using the command prompt. I have pulled so many "all
nighters" the past two weeks trying to do this tutorial(one for 26 hours str8).
I'll save the program, just in case. DWMX may be more than I can handle, but
I'll pull a few more "all nighters" before I go back to FrontPage, because it
has so many more options. Thanks for all your help!! I appreciate it.

[Khan44]

Originally posted by: Newsgroup User
What I do is open the sql in notepad, copy and paste that into the SQL query
window in "MySQL Control".
Basically, you open the program connect to your DB and click on the "SQL"
button on the menu bar.

That will open a "notepad" kinda window that you can use to run SQL
statements with.



:)Thanks a million!! I downloaded the new GUI, instead of the older one,
thinking it would have the same options. NOT! Anyway I got the tables imported
with your instructions above. Thanks Again for all your help! :beer;

[Anthony Brown]

Drinkin one right now!


"Khan44" <webforumsuser@macromedia.com> wrote in message
news:cv6c14$6n5$1@forums.macromedia.com...

> Originally posted by: Newsgroup User
> What I do is open the sql in notepad, copy and paste that into the SQL
> query
> window in "MySQL Control".
> Basically, you open the program connect to your DB and click on the "SQL"
> button on the menu bar.
>
> That will open a "notepad" kinda window that you can use to run SQL
> statements with.
>
>
>
> :)Thanks a million!! I downloaded the new GUI, instead of the older one,
> thinking it would have the same options. NOT! Anyway I got the tables
> imported
> with your instructions above. Thanks Again for all your help! :beer;
>