Web Design Forum: HeidiSQL - Web Design Forum

Jump to content

WDF
WDF Premium Memberships Reseller Hosting
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

HeidiSQL exported sql not working w/ phpMyAdmin

#1 User is offline   sobredosis de amor 

  • Forum Newcomer
  • Pip
  • Group: Members
  • Posts: 86
  • Joined: 06-October 09
  • Reputation: 0
  • Gender:Male
  • Experience:Intermediate
  • Area of Expertise:Web Developer

Posted 11 March 2010 - 04:40 PM

Just a quick query: I've been using SQLyog until last week when the 30 day trial expired. I've now switched to the Open Source HeidiSQL, but when I copy and paste from the .sql file it exports into phpMyAdmin, there are errors, which didn't come up when using SQLyog: Is there a way to change this via the formatting options of the output (ANSI etc.) or a better SQL manager to use?

I've also tried to access phpMyAdmin through the XAMPP setup but it says that the password's not right -- where can I change this?

Thanks.
0

#2 User is online   rallport 

  • Web Guru
  • PipPipPipPipPip
  • Group: Members
  • Posts: 3,503
  • Joined: 03-January 10
  • Reputation: 247
  • Gender:Male
  • Location:England, UK
  • Experience:Advanced
  • Area of Expertise:Web Developer

Posted 02 April 2010 - 01:18 AM

View Postsobredosis de amor, on 11 March 2010 - 04:40 PM, said:

Just a quick query: I've been using SQLyog until last week when the 30 day trial expired. I've now switched to the Open Source HeidiSQL, but when I copy and paste from the .sql file it exports into phpMyAdmin, there are errors, which didn't come up when using SQLyog: Is there a way to change this via the formatting options of the output (ANSI etc.) or a better SQL manager to use?

I've also tried to access phpMyAdmin through the XAMPP setup but it says that the password's not right -- where can I change this?

Thanks.


Er, in the phpmyadmin folder: /xampp/phpMyAdmin/config.inc.php
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users