homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

Importing Databases with XAMPP and MySQL

5+ Year Member

Msg#: 3706887 posted 1:51 am on Jul 25, 2008 (gmt 0)

I'm using XAMPP 1.6.7 and would like to import my forum's database to my test server. I'm having difficulty trying to find a way to import the database. I've been looking up ways to do this for a couple days days now, but every solution I'm finding is failing and I'm becoming frustrated. This seems like such a basic procedure, so what am I missing?

What I've tried:

  • On my live servers I use SSH to import/export my databases. I don't have access to import databases like this locally as far as I'm aware.
  • I get an error when trying to upload with phpmyadmin because the file is 'too large'. It's 170 megabytes.
  • I cannot get BigDump to work. I get this error: "Database connection failed due to Client does not support authentication protocol requested by server; consider upgrading MySQL client"
  • I found a website that said I could edit phpmyadmin's config.default.php file to use an upload directory ($cfg['UploadDir'] = '';), but that config file states: "DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD". config.inc.php does not have that line and I don't know where I would add it.
  • I've found some sites with queries to import files, but I don't know where to enter these commands other than phpmyadmin, which isn't working for this.
  • I'm getting 'access violation' errors when I try to open winMySQLAdmin directly, so I haven't been able to see if there is a way to do it from there.



WebmasterWorld Administrator mack us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

Msg#: 3706887 posted 3:29 pm on Jul 26, 2008 (gmt 0)

Are you able to use PhpMyAdmin to get the sql file downloaded localy. If so you might be able to use the compression method that is available within PhpMyAdmin. This will greatly reduce the file size of the .sql file and you shoudl then be able to import this within your admin area on localhost.


Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / New To Web Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved