distal-attribute
distal-attribute
distal-attribute
distal-attribute

Opening SQL file to work offline?

User, date Message
Written by chrismv48
2 years ago
Category: General
2 posts since Fri, 01 Jun 12
Hello all,

I am eager to disclose that I HAVE searched this forum extensively for an answer to my question, but haven't seen any conclusive workarounds...

Also please note I'm a complete novice, so please bare with me.

I am a student attempting to learn SQL outside of class and to start out, I was using phpmyadmin since I already had hosting at 1and1.com. I feel that while phpmyadmin is adequate for basic stuff, I was missing out on the power and ease of use of some of the SQL clients I'd been reading about. So I decided to download Heidi and give begin editing my database using that. The problem is, my host won't allow me to connect to the database using an outside client without upgrading my account to a 'Server Package' or something similar.

As a workaround, I exported my database to an SQL file, and attempted to open using Heidi. That's when I ran into the prompt to enter server information. I tried using localhost, 127.0.0.1 and the username/pw for my windows account but nothing has worked.

Is it just not possible to do this with Heidi, or is there something I'm doing wrong?
Written by jfalchMoney, Euro
2 years ago
407 posts since Sat, 17 Oct 09
heidisql is only a client software; you also need a database server to execute sql.

download server software from MariaDB">http://mirror2.hs-esslingen.de/mariadb">MariaDB or MySQL, and install and configure it on your computer (this is probably easier with MySQL, which has a configuration wizard).

then you can call heidisql to connect to this server via localhost on your pc, and execute an sql file.
Written by jfalchMoney, Euro
2 years ago
407 posts since Sat, 17 Oct 09
sorry, MariaDB download link is broken in previous post; see here, and choose "MSI Package" / "Windows 32-bit".
Written by chrismv48
2 years ago
2 posts since Fri, 01 Jun 12
Hey, thx for the quick reply. Turns out you can connect to the localhost, I just had to configure mysql properly then input those credentials into Heidi...however now I'm having trouble importing the SQL file which may soon appear as a new post smile
 

Please login to leave a reply, or register at first.