Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Sep 2011
    Thanked 0 Times in 0 Posts

    How to get your database file in XAMPP?

    I use XAMPP at home, right now I am dong a project, however, I want to get my database file which I am working to install on another computer, but where to get it in XAMPP? A guy told me I must dump the database in 'Export' section in PHPMyAdmin...it is true?

    I did go on the Export section, but there are options in settings which I dont know what to choose..

  2. #2
    Master Coder
    Join Date
    Feb 2011
    Your Monitor
    Thanked 614 Times in 600 Posts
    Go with the default selected options and don't worry about the rest. The other options are for advanced users.

    You may be able to locate the database in the mysql folder in xampp. You can copy/paste but it's almost certainly best to use the export option as you'll get an sql file which contains instructions for another mysql server to run when you import it.
    Quote Originally Posted by deathshadow View Post
    So seriously, loosen up that tie, let out the belt, and try relating to normal people on the street instead of the gentleman's club crowd.

  3. #3
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Saskatoon, Saskatchewan
    Thanked 2,668 Times in 2,637 Posts
    Use the export for sure. I just fought with old frm and innodb files to create an exportable script to import into my new build since the frm and innodb files cannot just be used directly. It wasn't fun (but only because I mistaken -- as - when trying to set recovery mode >.<). All that let me do is create a mysqldump of the data there to import into the database.
    The alternative of course is to simply call the mysqldump command. Which is what the export is doing I'm sure, but with a nice gui instead of just the cli.


Posting Permissions

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