Import a completed database from a script Dreamweaver and PHP


show more Importing a completed database from a script provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL show less
please wait ...

Importing a completed database from a script

In the exercises in the remainder of this video series, I am going to use a database that I have defined in an SQL script file. If you don't have access to the exercise files, you can find a copy of this database script in the free exercise files available on the lynda.com web site with this video series. If you have access to the exercise files, you'll be able to import the database quickly and easily in phpMyAdmin. You'll find the SQL file in the 04_createdatabase folder, under Exercise Files.

It's named explorecalifornia.sql. You can open this up in any text editor. I am using TextPad on Windows. I am first going to walk through the database structure and show you how the database is defined. In the top of the SQL file, there are some comments that indicate the character set, connection, and names. Then the table structures and data are added. For each table there is a DROP TABLE command and then a CREATE TABLE command.

This allows you to run the script, and it will wipe out...

Importing a completed database from a script
Video duration: 5m 34s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Importing a completed database from a script provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL

Subjects:
Business Developer Web
Software:
Dreamweaver
Author:
please wait ...