How to Export the database in phpMyAdmin

[Nurhan]

I'm trying to move my mySQL database. I'm creating an install script (PHP) that will create the database on the new machine.

The problem is that when I go to phpMyAdmin and export the database, the views have database/user specific information in the create statement. Is there a simple way to remove them? (or a simpler way to create this script?) or will I have to go and hand retouch them all?

Thanks.

[pancham]

Login to the phpMyAdmin there you could see the complete phpMyAdmin structure there Import and Export Database structure will be available then in the export section uncheck the box next to data and you'll only get the database structure.

Hope this helps to export the structure.

[PARRISH]

Using your web browser,

1. Go to the PHPMyAdmin location of the server where the database you wish to export resides. For example:

   http://www.example.com/phpmyadmin/

   for a remote database and

   http://localhost/phpmyadmin/for

   a database hosted on your Apache2Triad installation. Select the name of the database you wish to export from the combo box on the left side of the page and you will be taken to that database's main operations page.
2. Click the tab labeled "Export" and you will be taken to the Export database page.
3. In the EXPORT group, select the check box:
   
   * Select the check box marked "select all" to select all of the tables in the database for export.
   * The radio button selected below should be "SQL".
   
4. Within the OPTIONS group; under the STRUCTURE sub group,
   
   * Select the check box next to "Structure"
   * Select the check box labeled "add DROP TABLE"*
   * Select the check box labeled "Add AUTO_INCREMENT value"
   * Select the check box labeled "Enclose table and field names with backquotes"
   
5. Within the OPTIONS group, under the DATA sub group:
   * Select the check box marked "Complete inserts".
   * Select the check box labeled "Use hexadecimal for binary fields" may be selected
   * Select "INSERT" in the combo box labeled "Export type:"
   
6. Below, select the check box labeled "Save as file" group,
7. then type a name for the database and
8. click the button labeled "Go".
9. Select a location to save your database