MySQL Import and Export (.sql file) via PhpMyAdmin

来源:互联网 发布:鸿课青少儿编程 编辑:程序博客网 时间:2024/05/21 22:35
Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is larger you will need to use SSH instead of phpMyAdmin. Click Here for further instructions.

  1. Login to the Hostmonster cPanel
  2. Under the category "Databases", click on phpMyAdmin
  3. On the left column, select the database name you wish to import to
  4. Along the top of the screen click the "Import" tab
  5. Click browse under "File to Import" and locate the .sql file on your computer
  6. After you have selected the file, click GO and it will import your database.
To Export a database in phpMyAdmin:
  1. Login to the Hostmonster cPanel
  2. Under the category "Databases", click on phpMyAdmin
  3. On the left column, select the database name you wish to export to
  4. Along the top of the screen click the "Export" tab
  5. Click Select All or just the tables you need.
  6. Check the box saying Save as file and enter a name.
  7. Press Go button at bottom right.