Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2009
Member
 
Join Date: Feb 2009
Posts: 53
How to Export the database in phpMyAdmin

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.
Reply With Quote
  #2  
Old 24-02-2009
Member
 
Join Date: Dec 2008
Posts: 202
Re: How to Export the database in phpMyAdmin

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.
Reply With Quote
  #3  
Old 24-02-2009
Member
 
Join Date: Jan 2006
Posts: 211
Re: How to Export the database in phpMyAdmin

Using your web browser,
  1. Go to the PHPMyAdmin location of the server where the database you wish to export resides. For example: for a remote database and 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
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Export the database in phpMyAdmin"
Thread Thread Starter Forum Replies Last Post
PHP - Database and PHPMyAdmin Botan Software Development 3 05-01-2011 05:28 AM
run Batch-file export in excel (its for a Movie database) rayg Software Development 4 22-12-2010 08:31 PM
Export Database Model to SQL Nakul2 Software Development 5 01-12-2010 07:42 AM
Import and export Utility in Oracle database Adriana_andros Software Development 3 25-01-2010 02:58 PM
Navicat New database import and export Zindin Software Development 2 04-04-2009 11:09 AM


All times are GMT +5.5. The time now is 12:23 AM.