Export the MySQL database to a script Dreamweaver and PHP


show more Exporting the MySQL database to 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 ...

Exporting the MySQL database to a script

In addition to posting your php files on your web site, you also need to create a copy of your database on your remote server. The particular installation of MySQL will depend on how you're using your server on the remote site. In many cases, your database is created for you by your Internet Service Provider or by your web site manager, but it's up to you to create an SQL script that you can run to re-create your database structure remotely. In this video, I'll show you how to create the script using phpMyAdmin.

If you're working with WampServer on Windows, you can open up phpMyAdmin from the admin menu. And if you're working on MAMP on Mac OS X, go to the MAMP homepage and then click phpMyAdmin. From there, click into your database. My database is named explorecalifornia and then click Export at the top of the table list. In the Export Screen, you're asked which tables you want to export. I'm going to select all of the tables. Then there're some options ...

Exporting the MySQL database to a script
Video duration: 3m 8s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Exporting the MySQL database to 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 ...