How to Import the MySQL Database on a Remote Server


show more Importing the MySQL database on a remote server 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 the MySQL database on a remote server

When you generate a script from phpMyAdmin, it can be executed either in another copy of phpMyAdmin or in any other user interface for MySQL. In most cases, if you're working with an Internet Service Provider, you'll have a copy of phpMyAdmin that you can use. If you're working with an independent copy of MySQL, you can download a copy of the MySQL user interface tools from the MySQL web site. The script should work in that software as well. Before you run the script on your remote server, go into the script and make any changes you need.

For example, I'm going to change the name of my database from explorecalifornia, the local name, to exploreremote. Changing this comment doesn't have any actual effect on the database itself. You'll still create the database manually in phpMyAdmin, but then you'll run the script in phpMyAdmin against the new database. I'll save the changes and close the text editor, and then I'll go to phpMyAdmin.

Within phpMyAdmin, I...

Importing the MySQL database on a remote server
Video duration: 2m 24s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Importing the MySQL database on a remote server 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 ...