Welcome to WebmasterWorld Guest from 54.166.245.10

Forum Moderators: keyplyr & mack

Message Too Old, No Replies

Importing Databases with XAMPP and MySQL

     
1:51 am on Jul 25, 2008 (gmt 0)

New User

5+ Year Member

joined:July 25, 2008
posts: 1
votes: 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.
3:29 pm on July 26, 2008 (gmt 0)

Moderator This Forum from GB 

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

joined:June 15, 2001
posts:7692
votes: 37


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.

Mack.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members