Newbie

I've just installed heidiSQL without really knowing if it solves my proble,

I want to write a database locally (in my PC) to upload it into the server at a later stage.

1. will HeidiSQL be useful for that?

2. If so, what do I have to do now?

3. How can I test a connection to the server?

Thank you

First you need to understand that HeidiSQL is a client for MySQL, MSSQL and PostgreSQL. HeidiSQL is not a database server, and it does not work without at least one of those servers. You should probably go to the short help section for connecting to a server.

I host with Vidahost and I created a database today with MySQL 5.5.46-cll

What I need now is to compile all the data that will eventually go into the server's database. If I were in the 70s I would use a word processor and simply write the each field's data separated by a comma, and that would be it as it was all in ASCII characters. Not any more!


So, where could HeidiSQL help me, right now?

As said, please read the help document.

Hi

Sorry to go on.

I have connected to the server, looked and read the help document but still can't find the answer to my question. The Help mentions export but not import, although I assume that it can do that.

But what I need to know is the format I must write the records in, before uploading them to the server.

Normally you don't write data into a separate file and then import it into the server. But that's doable. You can use some valid CSV format, with any field terminator, field quote char and line terminator you want. You can import such csv files later using HeidiSQL's import dialog (Tools > Import CSV file). But you will have to create the table(s) structure before actually importing the file(s).

Danke!