Results 1 to 4 of 4

Thread: RESOLVED:how to make script of mysql database using phpmyadmin?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2005
    Posts
    1,907

    Resolved RESOLVED:how to make script of mysql database using phpmyadmin?

    Hi all could any one tell me how i can make a backup of my mysql database using phpmyadmin? i want to use it as backup and also want to transfer a copy of my database tables and data to diffrent mechine .Thanks
    Last edited by tony007; Apr 21st, 2006 at 04:01 PM.

  2. #2
    Frenzied Member sciguyryan's Avatar
    Join Date
    Sep 2003
    Location
    Wales
    Posts
    1,763

    Re: how to make script of mysql database using phpmyadmin?

    Quote Originally Posted by tony007
    Hi all could any one tell me how i can make a backup of my mysql database using phpmyadmin? i want to use it as backup and also want to transfer a copy of my database tables and data to diffrent mechine .Thanks
    Well, your better off doing it directly from CPanel like so:

    CPanel >> Backup >> Download a MySQL Database Backup >> Click the DB you wish to backup, download the file and your done :-)

    There are scripts out there that will backup a database for you though.

    Cheers,

    Ryan Jones
    My Blog.

    Ryan Jones.

  3. #3
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,956

    Re: how to make script of mysql database using phpmyadmin?

    Quote Originally Posted by sciguyryan
    Well, your better off doing it directly from CPanel like so:

    CPanel >> Backup >> Download a MySQL Database Backup >> Click the DB you wish to backup, download the file and your done :-)

    There are scripts out there that will backup a database for you though.

    Cheers,

    Ryan Jones
    You've made the assumption that everyone has CPanel.... which they do not. And not all control panels are created a like.

    Within phpmyadmin, in the navigation on the left, click the database name.
    Then after the page loads, there should be a tab across the top "Export".
    Click It.
    Select All Tables. Fill out the rest of the form, be sure to save to file. Include what ever options you want, and click the appropriate button.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  4. #4
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,651

    Re: how to make script of mysql database using phpmyadmin?

    When you export be sure to choose compatability as "Mysql 4", and add the options +drop database and +use statement. That makes life easier

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width